Page Setup dialog box
 
 
 

Use this dialog box to specify margins, headers, grid, print order, and centering options.

To set print options

In the Data View: File Page Setup

Margins

Margin dimensions are in centimeters if your Windows system-wide measurement system is set to Metric, in inches if it is set to U.S. To view or set the measurement system, from the Windows Control Panel choose Regional Settings Number tab Measurement System.

Left

Enter the distance from the left edge of the paper to the beginning of each line.

Right

Enter the distance from the right edge of the paper to the end of the printable area.

Top

Enter the distance from the top of the paper to the top of the first line.

Bottom

Enter the distance from the bottom of the paper to the bottom of the last line.

Titles and Grid Lines

Row Headers

Print row headers.

Column Headers

Print column headers.

Print Frame

Print a frame around the table.

Vertical Lines

Print vertical lines between each column.

Horizontal Lines

Print horizontal lines between each row.

Only Black And White

Print using only black and white. Text that has a color assigned to it will be printed using a pattern.

Page Order

If a table extends beyond the limits of a single page, it is divided into page-size tiles. This setting governs the order of printing the tiles.

First Rows, Then Columns

Print tiles from left to right by rows, top row first.

First Columns, Then Rows

Print tiles from top to bottom by columns, left column first.

Center on Page

Vertical

Center the table between the specified top and bottom margins.

Horizontal

Center the table between the specified left and right margins.