|
How to Auto Format the Body of a Worksheet -
Excel 2007 |
 |
|
Select the area to be formatted
by dragging mouse pointer to the lower, right corner cell of the range to format
(blue area in Figure 1).

Figure 1
Click Format as Table on the menu
bar (Figure 1).

Figure 2
Click the format desired
(Figure3).

Figure 3
When the Format as Table dialog
box appears, click OK (Figure 4).

Figure 4
|