5 Excel Keyboard Shortcuts for Font or Fill Colors. Jon Acampora; April 24, 2014. Let's say you just used the Fill Color menu to change a cell to have a blue background. When you select another cell and press the F4 key, the cell's fill color will be changed to blue. A large part of my consideration has to do with Mac being compatible.
You can apply shading to selected table cells via the Borders and Shadingdialog box which you can open via Format Borders and Shading (see Figure 1 below). In case of Word 2007 or later version, you can open the dialog box as follows: Home tab Paragraph group, click the arrow next to the bottom-right icon in the group and select Borders and Shading. You may also find Borders and Shading in the right-click menu.
On the Shading tab, you must select the color to apply. In addition, you must always remember to make the appropriate selection in the Apply to field. In relation to tables, you can apply the shading to. Figure 6. Cell shading – examples. Note that the text in the upper-left cell consists of one paragraph which has been applied the listed settings. As mentioned above, the cell shading white space issues only seem to occur in Word 2003 and earlier versions. What happens if you apply mixed shading to a cell?
Not only can you apply different types of shading to table cells. You can also apply different types of shading to the same cell at the same time. This may make it more difficult to find out what causes white space in cells. Imagine you have applied shading to the paragraphs in a table cell. The cell has white space so you find out that you should have applied the shading to the cell, not the paragraphs.
Therefore, you select the cell, open the Borders and Shading dialog box, select the same color as applied to the paragraphs, select Cell in the Apply to field and click OK. You may then find that your table cell still has white space because the shading of the paragraphs is still in effect. In Figure 7 below, this is illustrated by applying different colors. The upper-left cell is shaded yellow. The pink text is in a separate paragraph that has been applied text shading. The green and blue texts are individual paragraphs that have been applied paragraph shading.
Since space has been added above/below those paragraphs, white space occurs even if shading has been applied to the entire cell. NOTE: The white space issues illustrated below seem to apply only to Word 2010 and earlier versions. In Word 2013 and later versions, table cells seem to be filled correctly.
Figure 8. The same example as in Figure 7 with the difference that only one color is used. In this case, it is difficult to find out what causes the white space. Cell shading and paragraph styles with border(s) White space in shaded table cells may also appear if you apply a paragraph style with one or more borders and space before/after.
If that problem occurs, you need to remove the border(s) in order to solve the problem. For details about how and when the white space appears when a bordered paragraph style is used, study the examples illustrated in Figure 9 below. NOTE: The white space issues illustrated below seem to apply only to Word 2010 and earlier versions.
In Word 2013 and later versions, table cells seem to be filled correctly. Each example shows only a single table cell wth a black table border.
The text in each table cell has been applied a paragraph style with one or more borders. The paragraph borders are red and blue. See the text in each example for further details. Figure 9. Using a paragraph style with border(s) may cause white space in table cells. As mentioned above, the cell shading white space issues in relation to borders only seem to occur in Word 2010 and earlier versions. Tips on how to repair the shading if white space occurs As illustrated above, you may find confusing results if you have a mixture of shading types applied to the same table cell. Therefore, if you have problems with shading that does not fill one or more cells as expected, it would be an idea to.