Using the Page Setup Dialog Box

In Excel page setup options can help you make your worksheet look more professional. Learn all about using the page setup feature in Excel here.

Sheet settings

The Page Setup dialog box's Sheet tab allows you to consider other options for your worksheet, such as whether to print gridlines or row and column headings.

Page Setup Dialog Box Sheet Tab

Print area

By default, Excel prints from A1 to the last occupied cell in a worksheet. You can specify a different range of cells to print.

Print titles

This feature prints column and row labels on each page of the printout. Specify these rows or columns in the Rows to Repeat at Top and Columns to Repeat at Left text boxes.

Print or hide gridlines

This determines whether gridlines are printed. However, turning off gridlines does not affect their appearance in Normal view.

Draft quality

Choose draft quality to print a worksheet without gridlines or graphics.

Black and white

If you used colors in your worksheet but don't want to waste the ink in your color printer, use black and white.

Row and column headings

Click this option to include row numbers and column letters in your printed document.

Page order

This determines the order in which worksheets are printed.

Important Point To turn off gridlines, you can also choose ToolsLesson ActionOptions from the menu bar. Click the View tab and uncheck the gridlines option.