Spreadsheet Layouts - System tab

Select the System tab of the Spreadsheet Layouts dialog box to view a list of available spreadsheet layouts. Note that when any of these spreadsheet layouts are selected, only the Close and Edit buttons are available in the Spreadsheet Layouts dialog box.
Option Description
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 your spreadsheet. 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.

Note that when you select a System spreadsheet layout and click the Edit button in the Spreadsheet Layouts dialog box to display the Edit Spreadsheet Layout dialog box, only the options that apply to the selected System spreadsheet layout are available in the Edit Spreadsheet Layout dialog box.