![]() ![]() Step 1: Copy and paste your data to Microsoft Word as usual. The colour will not go even if you shade with white/ try to remove the shading. (Optional) Choose an option from the drop-down menu: Keep Source Formatting maintains the formatting (e.g., font, size, color, etc.) of the pasted text. Otherwise, you can turn off the field shading via File>Options>Advanced>Show document content and set the field shading to Never to turn it off completely. When you copy data from another rich text application involving heavy formatting to Microsoft Excel, you may surprise to notice that the text so copied will be highlighted with light green. Your data will be delinked, background colour/ shading colour will disappear immediately. Use Alt+F9 again to toggle off the display of the field codes If the text is within a field, and you do not want the text to be in a field, you can unlink the field by pressing CTRL+SHIFT+F9 when you have the selection in the text. Text > Style > Gear drop down (grouped with Font) > Text Background > Color none. In the pop up window for confirmation to break the links, click ‘Yes’. To get rid of that background select the text then click. Select the entry listed and then click on ‘Break Link’ button. Step 3: A links window will appear where you can see that the data is linked to a worksheet. Step 2: Right click on the copied text and in the menu select ‘ Linked Worksheet Object’>’Links’. After copying it looks like this, with grey shading. Do the following steps to get rid of the same. In the Font group, click the Text Highlight. ![]() Click the Cancel button to close the Find and Replace dialog box. In the first instance of copying tabled data to Microsoft Word, a grey background colour is added as Microsoft Word pastes links rather than formatted text when copying from Microsoft Excel in several cases. The phrase is highlighted in the document. ![]() This article is about removing this colour highlighting in Microsoft Word. You might have noticed that when text/ tabled data (when the data being copied has inputs from other cells in the workbook) is copied from Microsoft Excel/ other application to Microsoft Word, Word highlights/ shades each character with a grey/ green color. Unfortunately, there is no way to remove more than one border at a time, unless your text boxes are in a row and you can highlight them and select them together. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |