Spreadsheet Layouts - Overview

A spreadsheet layout is a convenient way to combine sets of formatting options into one collection. This feature is 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

Note: The spreadsheet layout applied to the spreadsheet above changed the font of the data (italics, Comic Sans MS, and 12 point), the font of the case and variable headers (centered, bold, italics, 12 point, and background color), and the gridlines (thicker).

Ribbon bar. Select the Format tab. In the Spreadsheet group, click Layouts to display the Spreadsheet Layouts dialog box.

Classic menus. From the Format menu, select Spreadsheet to display the Spreadsheet Layouts dialog box.

There are several predefined spreadsheet layouts divided into two groups: General and System spreadsheet layouts. The General spreadsheet layout affects the data, header, case and variable headers, and info box of spreadsheets. The System spreadsheet layouts include: Active Cell Header, Marked Cells, Print Filter, Printed Marked Cells, Reporting Tables Default, Selected Cells Header, and Selection Conditions. These spreadsheet layouts only affect very specific characteristics associated with spreadsheet interactions.

Option Description
System Default Use this spreadsheet layout to edit the default formats of your spreadsheet. Whatever formats you specify for the System Default spreadsheet layout applies to all new spreadsheets that are created.
Active Cell Header Select this spreadsheet layout and click the Edit button to display the Edit Spreadsheet Layout: Active Cell Header dialog box, where you can edit the formats for the case name and variable name of the currently selected cell.
Marked Cells Select this spreadsheet layout and click the Edit button to display the Edit Spreadsheet Layout: Marked Cells dialog box, where you can edit the formats for the marked cells in spreadsheets. Note that you can control to which cells the Marked Cells spreadsheet layout applies by the Marking Cells commands found on the Tools menu. Marked cells are used in results spreadsheets. For example, you can specify the p-value to use when determining significant results. The Marked Cells spreadsheet layout applies to all results less than this p-value in the result spreadsheets. Options for controlling which results are marked are typically included in the analysis dialog box.
Print Filter Select this spreadsheet layout and click the Edit button to display the Edit Spreadsheet Layout: Print Filter dialog box, where you can edit the formats for spreadsheets when they are printed. If you choose to apply any format or spreadsheet layout to your spreadsheet, it is reflected when you print a spreadsheet, with the exception of the formats or spreadsheet layouts applied to the Case Header, Variable Header, and Gridlines (unless these check boxes are cleared in the Edit Spreadsheet Layout: Print Filter dialog box). If you choose to apply any spreadsheet layout to your spreadsheet, it is reflected when you print your spreadsheet, with the exception of the Active Cell Header and Selected Cells Header spreadsheet layouts.
Printed Marked Cells Select this spreadsheet layout and click the Edit button to display the Edit Spreadsheet Layout: Printed Marked Cells dialog box, where you can edit the formats for the marked cells when the spreadsheet is printed. Note that this layout takes the place of the Marked Cells layout when printing the spreadsheet.
Reporting Tables Default Select this spreadsheet layout and click the Edit button to display the Edit Spreadsheet Layout: Reporting Tables Default dialog box, where you can edit the formats for Reporting Tables.
Selected Cells Header Select this spreadsheet layout and click the Edit button to display the Edit Spreadsheet Layout: Selected Cells Header dialog box, where you can edit the formats for the case names and variable names of the selected cells. Note that this layout applies to the formats of the case names and variable names of the block of selected cells. The Active Cell Header applies only to the one case name and one variable name of the first selected cell.
Selection Conditions Select this spreadsheet layout and click the Edit button to display the Edit Spreadsheet Layout: Selection Conditions dialog box, where you can edit the formats for the cells selected in your spreadsheet by case selection conditions. Note that you control the selection of cells to which the Selection Conditions spreadsheet layout applies when you enter selection conditions by the Case Selection Conditions dialog box.

You can also create a new spreadsheet layout with customized format choices. See Create a New Spreadsheet Layout, Apply a Spreadsheet Layout, Edit a Spreadsheet Layout, Delete a Spreadsheet Layout, and Rename a Spreadsheet Layout.