Using the Page Setup Dialog

Using the Page Setup Dialog to Add Headers & Footers, Determine Size, Orientation & Margins, and Print Specific Portions of Your Worksheet

Excel lets you add headers and footers, determine size, orientation and margins, print specific portions of your worksheet, etc. through the Page Setup dialog. To access the Page Setup dialog, follow the instructions below.

Click on the word File in the Menu bar.
Select the option Page Setup.
The Page Setup dialog will appear.

The table below illustrates some of the different setup commands that you can choose.

Function

Description and Comment

Portrait or Landscape On the Page tab, choose the page orientation.

Paper Size On the Page tab, choose the page size (legal, letter, etc.)

Scaling On the Page tab, reduces, enlarges, or fits the worksheet to a specific number of pages when you print. (If you choose to fit your worksheet on one page, it will probably not be centered in the middle of the printed page. To do that, you will need to modify the percentage value in the Adjust field.)

Margins On the Margins tab, change the different margins of the page.

Center on Page On the Margins tab, choose whether the information should be centered horizontally, vertically or both.

Header/Footer On the Header/Footer tab, enter text for the page header or footer by clicking on the Custom Header or Custom Footer button.

Print Area On the Sheet tab, select the area of the spreadsheet that you want to print.

Rows to Repeat/
Columns to Repeat On the Sheet tab, set the header for a row, a column, or both if you want the headers repeated on all of the workbook’s pages.

Gridlines On the Sheet tab, enable the Gridlines option if you want to print the worksheet's gridlines..

Row and Column Headings On the Sheet tab, choose the Row and Column Headings option if you want the printout to have the row and column references. This can help you identify the cell references on a hard copy of the printout.

Click HERE to return to the Table of Contents.

Function	Description and Comment
Portrait or Landscape	On the Page tab, choose the page orientation.
Paper Size	On the Page tab, choose the page size (legal, letter, etc.)
Scaling	On the Page tab, reduces, enlarges, or fits the worksheet to a specific number of pages when you print. (If you choose to fit your worksheet on one page, it will probably not be centered in the middle of the printed page. To do that, you will need to modify the percentage value in the Adjust field.)
Margins	On the Margins tab, change the different margins of the page.
Center on Page	On the Margins tab, choose whether the information should be centered horizontally, vertically or both.
Header/Footer	On the Header/Footer tab, enter text for the page header or footer by clicking on the Custom Header or Custom Footer button.
Print Area	On the Sheet tab, select the area of the spreadsheet that you want to print.
Rows to Repeat/ Columns to Repeat	On the Sheet tab, set the header for a row, a column, or both if you want the headers repeated on all of the workbook’s pages.
Gridlines	On the Sheet tab, enable the Gridlines option if you want to print the worksheet's gridlines..
Row and Column Headings	On the Sheet tab, choose the Row and Column Headings option if you want the printout to have the row and column references. This can help you identify the cell references on a hard copy of the printout.