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 that 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...

...where 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.

System Default. Use this spreadsheet layout to edit the default format(s) of your spreadsheet. Whatever format(s) you specify for the System Default spreadsheet layout will apply 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 format(s) 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 format(s) for the marked cells in spreadsheets. Note that you can control to which cells the Marked Cells spreadsheet layout will apply via the Marking Cells commands found on the Tools menu. See Marked Cells for further details. 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 will apply 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 format(s) for spreadsheets when they are printed. If you choose to apply any format or spreadsheet layout to your spreadsheet, it will always be 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 will always be 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 format(s) for the marked cells when the spreadsheet is printed. Note that this layout will take 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 format(s) 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 format(s) for the case names and variable names of the selected cells. Note that this layout applies to the format(s) of the case names and variable names of the block of selected cells. The Active Cell Header (described above) 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 format(s) for the cells selected in your spreadsheet via case selection conditions. Note that you control to which cells the Selection Conditions spreadsheet layout will apply when you enter selection conditions via the Case Selection Conditions dialog box. See Selection Conditions for further details.

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.