Borderline Command in Excel 2010 part 3

Select a column of cells and you’ll see this (Figure 4–25)

Note the word “Text” appears here twice vertically, representing the columnar selection. Select a row of cells and you’ll see  this (Figure 4–26)

You’re getting the idea. By then clicking the various line options surrounding the Text image you can border the selected cells;  and while this option doesn’t offer much more than what you’re getting in the other border-drawing options, you do  have those diagonals. If I click a diagonal, I’ll see, by way of preview (Figure 4–27):

Click OK and you get this effect (Figure 4–28):

Odd but interesting, and you may be able to conjure a use for it.

The final two Font Group buttons, Fill and Font Color, respectively, are popular ones (Figure 4–29):

When clicked, the Fill button colors any cells you’ve selected from a set of options presented in this drop-down menu (Figure  4–30)

It’s very easy. Note you can remove any fill color by selecting the cells in question and clicking No Fill. You can also fill-color  empty cells, that is, cells currently containing no data. Clicking More Colors yields a beehive of additional hues (Figure 4–31):

Click the Custom Color tab and you can enter various numeric color values and add nuanced shadings to your tints. I’m still  having trouble with ROYGBIV, though.

And befitting its name, Font Color serves up a nearly identical drop-down color menu, this time enabling you to change the  color of the data you’ve entered in selected cells—not the color of the cells themselves (Figure 4–32):

Note, however, that the above menu also offers an Automatic color option; click it and you return the data to the default black  font color. A More Colors option is likewise provided here, as well as a Custom color option.