Page Setup Dialog Box - Sheet Tab

Use this tab to specify how to print tables and crosstabs that span multiple pages.  This tab does not apply to graphs, because a logical page of a graph is always printed on a single physical page.

Tab components

Print -- Specifies whether to repeat headers across the top of the page

Repeat row, column, and page item headers on every page -- Specifies whether to repeat these headers across the top of every physical page.

Page Order -- Specifies how to print multiple pages that span across and down pages.

Down, then Across -- Prints all the rows for each set of columns that fit on a sheet, and then print the rows for the next set of columns, as shown.

Printing order: down, then across example

Across, then Down --  Prints all the columns for each set of rows that fit on a sheet, and then print the columns for the next set of rows, as shown.

Printing order: across, then down example

Print Preview button -- Displays the page as it will appear when it is printed.