Printing

Printing in Excel can sometimes be complicated. Learn about Excel printing, including setting the right print area, in this lesson.

To use print titles:

Imagine how difficult it would be to read a worksheet if the column and row headings only appeared on the first page. The Print Titles command allows you to select specific rows and columns to appear on each page.

  1. Click the Page Layout tab.
  2. Select the Print Titles command.
    Selecting the Print Titles command Selecting the Print Titles command
  3. The Page Setup dialog box appears. Click the icon at the end of the Rows to repeat at top field.
    Clicking on icon Clicking on icon
  4. Your mouse becomes the small selection arrow . Click the rows you want to appear on each printed page. The Rows to repeat at top dialog box will record your selection.
    Clicking on row 1 Clicking on row 1
  5. Click the icon at the end of the Rows to repeat at top field.
    Clicking on icon Clicking on icon
  6. Repeat for Columns to repeat at left, if necessary.
  7. Click OK. You can go to Print Preview to see how each page will look when printed.

To insert a break:

  1. Click the Page Layout tab.
  2. Determine the placement of the break by clicking the row below, cell below, or column to the right of where you want the break to appear. For example, select column C, and a break will appear after column B.
    Selecting the column to the right of where the break will appear Selecting the column to the right of where the break will appear
  3. Select the Insert Page Break command from the Breaks drop-down menu.
    Selecting the Insert Page Break command Selecting the Insert Page Break command
  4. The break is inserted. You can go to Print Preview to confirm that it appears in the correct place on the page.