Advanced Excel export properties
Choose the Advanced button to view or edit the Advanced Excel Export Properties dialog.
Display Properties
Variable
Choose whether to use names or descriptions for the variable texts in the tables.
Category
Choose whether to use category names or descriptions for the row and column headings in the tables.
Borders
Adds borders to the tables in Excel.
Headers and footers
Exports the headers and footers that have been defined for the table. The headers and footers are left aligned, regardless of the positions defined in the Header and Footer dialog. This has the advantage that they are easily visible in a wide table.
Formatting for headers and footers
Copies headers and footers to the clipboard as formatted HTML. When this property is set to False, the annotation is copied as plain text, so that all tags (except <br/>) appear in the Excel output. Set this option to False in a server environment.
Base values
This option controls the display of base rows and columns. If you leave this box blank, all rows or columns containing bases are suppressed for all tables, so that they are not displayed in the output file. If you check the box, rows and columns are displayed or hidden according to what is specified in the definition for each table.
Chart options
Display column statistics results
Displays the column IDs for a column proportions or column means test next to the category descriptions, and adds the column proportions test results to the chart above the relevant columns.
Worksheet options
Use Excel styles
Uses styles to control the formatting. By default, the exported tables look the same whether you use styles or not. However, styles make it easy to change the look of the tables and apply standard formatting to multiple tables. If you want to use Excel to manipulate the data in the tables rather than printing them, you might prefer to export without using styles. See
Formatting the tables in Microsoft Excel for more information.
Printing
Controls the print option that will be selected in the Excel file. This does not affect how the tables appear in Excel. It affects how large tables appear when they are printed.
▪Repeat axes. Selects the Excel option to repeat title rows and columns on every page so that when a table is split between more than one printed page, the table row and column headings are repeated on every page.
▪Fit to page. Selects the “adjust to fit on one page” option.
▪None. Does not select any printing options in Excel.
Show column statistics results with first cell item
Controls the display of significance letters for column proportion and column mean tests. If you leave this box blank, the significance letters are shown in cells after the cell items, as in the Results pane. If you select this box, significance letters are shown in the same Excel cell as the first cell item. Charts are not produced for tables with column proportion results shown with the first cell item.
Create a separate table for each cell item
Displays each type of cell contents in a separate table (all of the tables are on the same worksheet). This is useful if you want to perform calculations on the output or set up your own charts in Excel.
Wrap description text
Wraps long descriptions onto the next line.
Auto-fit column widths
Changes the width of the table columns to accommodate the width of the text. By default, this option is not enabled.
See also