Microsoft Office Tutorials and References
In Depth Information
Advanced Worksheet Formatting
Advanced Worksheet Formatting
A few chapters back, we went through the most useful of Excel’s formatting options (for a
refresher, see “Formatting Cells and Ranges” on page 376). In this section, we dig into some
lesser-known but useful formatting tools and techniques. You’re most likely to find them in
one of two places: on the Home tab or in the Format Cells dialog box. (It’s worth
mentioning again that you can summon this dialog box with the keyboard shortcut Ctrl+1, which
every Excel user should memorize.)
On the Home tab, the Borders button is almost lost (and perhaps just a little out of place)
among the more familiar options in the Fonts group. Click it to open the menu shown in
Figure 14-2.
Figure 14-2 You can apply the simplest borders using the choices on the Borders menu. For
more intricate projects, try drawing the borders instead.
Whatever option you click on the Borders menu applies to the current selection. Click All
Borders, for example, to add black gridlines around and between all cells. This effect works
best on small ranges. The Top And Double Bottom Border option is traditionally used to set
off the Grand Totals row on a financial worksheet. Click No Border to remove all borders
from the current range.
If you want to vary the thickness or color of the borders, use the options under Draw
Borders to point and click your way through the process. The Line Color menu lets you choose
Search JabSto ::




Custom Search