A spreadsheet layout is a convenient way to combine sets of formatting options into one collection. This feature can be used to specify and apply different formats for different components of a spreadsheet. Once you have created a spreadsheet layout, it can be applied to any spreadsheet for a consistently formatted appearance. Follow these instructions to create a new spreadsheet layout:
Select Layout Manager from the Format - Spreadsheet submenu to display the Spreadsheet Layouts dialog.

Click the New button to display the Spreadsheet Layout Name dialog.

Enter a name in the Name box, and then click the OK button to display the Edit Spreadsheet Layout dialog.

In the Formats group box, a default Format 1 will be displayed. Select the area of the spreadsheet to be affected by Format 1 in the Areas of Spreadsheet affected by format group box. In the above illustration, only the Variable Header check box is selected. Note that you can control the range of variable headers to be affected by Format 1 via the options in the Range of variables group box.
Next, click the Edit button in the Format group box to display the Edit Format: Format 1 dialog.

Select any formatting options to be associated with Format 1. Above, Comic Sans MS has been chosen as the Font, 10 for the Size, white for the Text Color, and blue for the Background color. Note that the Preview box is used to view your specified format.
Click the OK button to accept the settings and return to the Edit Spreadsheet Layout dialog.

To define additional formats for other areas of the spreadsheet, click the New button to display the New Format: Format 2 dialog, and select any formatting options to be associated with Format 2. In this manner, you can add additional formats to the spreadsheet layout as necessary. In the illustration above, Format 2 (Font - Comic Sans MS, Size - 10, Text Color - white, and Background color - blue) has been applied to the Case Headers.
When you are satisfied with the appearance of your spreadsheet layout, which is displayed in the Preview box, click the OK button. The spreadsheet layout that you just created is added to the list of formats available in the Spreadsheet Layouts dialog and on the Format - Spreadsheet submenu.

You can now apply this spreadsheet layout to new selections (see the next section).