• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Using AutoFormat

An excellent way to quickly add formatting to a spreadsheet is AutoFormat. It allows you to emphasize certain areas of the spreadsheet and dress them up with color and shading without having to determine your own overall formatting strategy for the spreadsheet.

To Use AutoFormat

Select the cell range (typically your whole spreadsheet) that you wish to format.

Select the Format menu, and then select AutoFormat. The AutoFormat dialog box appears (see Figure 3.16).

Figure 3.16. Autoformatting can be used to quickly assign different formatting options to your spreadsheets.

A number of different autoformats is available in the Format scroll box. To view a preview of a particular autoformat in the Preview box, select the particular autoformat.

Click the More button in the AutoFormat dialog box if you want to only use parts of the formatting that a particular autoformat provides. For example, you can use the number format and the borders of the autoformat, but choose not to use the font or alignment provided.

A Format box will appear on the bottom of the dialog box (see Figure 3.17) to provide checkboxes for the various attributes (such as number format or border) that are part of the autoformat.

Figure 3.17. You can decide which formatting attributes are used when the autoformat is assigned to your spreadsheet.

Deselect any of the formatting checkboxes if you do not wish to assign that particular attribute when you assign the autoformat to your spreadsheet.

Click the OK button in the AutoFormat dialog box, once you have selected a particular autoformat and deselected any attributes that you do not wish to use as part of the autoformat. The autoformat will be assigned to your selected range of cells.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint