Jazzing Up Spreadsheets With AutoFormat

The program comes with a set of predefined table formats that can help jazz up a spreadsheet for printing. You can apply those, or create your own and apply one.

Applying an AutoFormat

To apply one of these AutoFormats to a spreadsheet:

1. Select the area to which you want to apply an AutoFormat.

2. Choose Format > AutoFormat.

3. In the AutoFormat window, select the format and options you want. Use Figure 19-9 for guidance.

   Figure 19-9. Applying an AutoFormat to a spreadsheet

   

4. Click OK.

If you don't like the results of the AutoFormat, click the Undo icon in the function bar until your spreadsheet is back to where it was before you applied the AutoFormat. If you don't have enough undos to get back to your starting format, reformat the spreadsheet manually.

A more automated way to get back to a previous format is if you add the previous format as an AutoFormat that you can select in the AutoFormat list ( next procedure).

Adding an AutoFormat

You can add your own spreadsheet formats to the list of the program's AutoFormats.

1. Format the spreadsheet the way you want it.

   You don't have to include data in the spreadsheet; just column, row, and cell formatting.

2. Select the formatted area, and choose Format > AutoFormat.

3. In the AutoFormat window, click the Add button.

4. In the Add AutoFormat window, type a name for the new format, and click OK.

   Your format is added to the list.

5. Click OK in the AutoFormat window.

You can delete or rename AutoFormats by selecting them in the AutoFormat window and clicking the Delete or Rename buttons .