Choose the Advanced button to view or edit the Advanced Excel Export Properties dialog box.

Choose whether to use variable names or the more friendly descriptions for the variable texts in the tables.

Choose whether to use category names or the more friendly descriptions for the row and column headings in the tables.

Select this option if you want the tables to have borders in Excel.

Select this option if you want to export the headers and footers that have been defined for the table. When this option is selected, all of the headers and footers are displayed left aligned, regardless of the positions defined in the Header and Footer dialog box. This has the advantage that they are easily visible in a wide table.

Select this option if you want headers and footers to be copied 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.

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.

See also Chart options.

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.

Select this option if you want to use styles to control the formatting. By default, the exported tables will look the same whether you use styles or not. However, styles make it easy to alter the look of your 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 may prefer to export without using styles. See Formatting the tables in Microsoft Excel for more information.

This option controls the print option that will be selected in the Excel file. Note this does not affect how the tables appear in Excel. It affects how large tables appear when they are printed. The options are:

This option 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 check this box, significance letters are shown in the same Excel cell as the first cell item. Note that charts are not produced for tables with column proportion results shown with the first cell item.

Select this option if you want each type of cell contents to appear 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.

Select this option if you want to wrap long descriptions onto the next line.

Select this option if you want to automatically change the width of the table columns to accommodate the width of the text. By default, this option is not enabled.