In Excel for Mac 2011, one could put a 'Microsoft Excel Open XML spreadsheet template' file named 'Workbook', with no file extension, in the folder /Applications/Microsoft Office. Default startup template for Excel 2016 for Mac. The desired effect is for Excel 2016 for the Mac to start up using a copy of the specified file, without the. Since the release of Excel 2016 for Mac, customers have given great. Pane, you can modify not only charts, but also shapes and text in Excel!
In this article, we plan to show you 5 useful methods to remove highlighting or shading quickly in your Word document.
Now and then, do you get confused by highlighting and shading in Word documents? They look so much alike that it’s hard for us to tell them apart from one to another. Therefore, we make a comparison of them:
Similarity | Difference | ||
Shading | Highlighting | Shading | Highlighting |
Both can highlight contents to make them attractive. |
1. Shading can be applied to both table and text.
2. Shading can be a part of style.
3. More color options for shading
4. You can’t find shading by using “Find” feature.
|
1. Highlighting can be applied to text only.
2. Highlighting is not a part of style.
3. Less color choices
4. You can find highlighting by using “Find” feature.
|
2 Methods to Remove Text Highlighting
Now let’s take a look at how to clear them respectively.
If you know the texts are in highlighting, you can deploy the following methods.
Method 1: Choose No Color for Highlighting
- Firstly, select the texts in highlight.
- Then click “Text Highlight Color” in “Font” group under “Home” tab.
- On the drop-down menu, choose “No Color”.
Method 2: Use “Find and Replace” Feature
- Firstly, click “Home”, then “Replace” to open “Find and Replace” dialog box.
- Then ensure “Replace” tab is on. Place cursor at the “Find what” text box and click “More”.
- Next, click “Format”.
- Then click “Highlight”.
- Now place cursor at “Replace with” text box.
- Next repeat step 3 and 4 twice.
- Lastly, click “Replace All”.
2 Methods to Remove Shading
If you ae sure the Words are in shading, here are ways to clear.
Method 1: Choose No Color for Shading
- To start with, select text in shading.
- Then click “Shading” in “Paragraph” group under “Home” tab.
- Next choose “No Color”. Then all shading is gone.
Method 2: Use Shortcut
Earlier, we just mentioned that shading can be a part of a style. So you can remove it by pressing “Ctrl+ Q”. Certainly, you have to select them first. By the way, it can strip other formatting, such as converting auto numbered list to plain text.
2 Methods to Remove Both Highlighting and Shading
Method 1: Paste as Unformatted Text
- To begin with, select the target text and press “Ctrl+ X” to cut them of the document.
- Then click “Paste Special” on the drop-down menu of “Paste” option to open the same name dialog box where you should choose “Unformatted Text”.
- Next simply click “OK” will be enough.
Method 2: The VBA Codes
- Firstly press the “Alt+ F11” to open VBA editor.
- Next paste the following codes and click “Run” to remove both highlighting and shading:
Note: Before you hit the “Run” button, you have to select the target text first. You can press “Ctrl+ A” to select the whole document.
In case you want to determine whether you have a text in highlighting or shading, you are welcome to use the codes to check it out.
The codes to remove highlighting are:
While the codes to remove shading are:
If either of the 2 set of codes works, you can know what it is.
Extract from Corrupted Word Files
Honestly, Word can collapse, and our files can be compromised. But you should know these irreplaceable data has a great possibility to be retrieved. Therefore, you should choose a proficient and technologically advanced docx data fix tool.
Author Introduction:
Vera Chen is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including corrupt xls data repair tool and pdf repair software products. For more information visit www.datanumen.com
Cell shading continually darkens when you hold down Ctrl and repeatedly select the cell in Excel. 11/4/2019. 2 minutes to read. Applies to: Excel 2016, Excel 2013In this article SymptomsAssume that you select multiple cells in a Microsoft Excel 2013 or Microsoft Excel 2016 worksheet. You mistakenly select some cells that you do not want to include in the selection.
When you hold down Ctrl and then click those cells in order to remove them from the selection, the cell shading becomes darker, and the cells are not unselected. Additionally, the cell shading continues to darken if you repeatedly click the cells. CauseThis behavior is by design because of a change in the Excel 2013 or Excel 2016 graphics engine.
This change enables you to highlight overlapping selections. If you repeatedly select the same cells, the cell shading eventually becomes too dark, and you cannot see the text in the cell. WorkaroundTo work around the issue, cancel the selection of cells, and start the selection process again.
Related Articles.