Print headings or titles on every page

If you want to print a ark that will have many printed pages, you can set options to print the sheet's headings or titles on every page.

Excel automatically provides headings for columns (A, B, C) and rows (1, 2, 3). You type titles in your sheet that describe the content in rows and columns. In the following illustration, for example, Projected is a row title and 2nd QTR is a column title.

Ark med overskrifter og etiketter

Boble 1  Row headings

Billedtekst 2 Column headings

Billedtekst 3  Column titles

Boble 4  Row titles

Do any of the following:

Print row and column headings

  1. Click the sheet.

  2. On the Layout tab, under Print, select the Headings check box.

    Fanen Layout, gruppen Udskriv

  3. On the File menu, click Print.

    You can see how your sheet will print before you print it by clicking Preview.

Print row titles on every page

  1. Click the sheet.

  2. On the Layout tab, under Print, click Repeat Titles.

    Fanen Layout, gruppen Udskriv

  3. Click in the Columns to repeat at left box, and then on the sheet, select the column that contains the row titles.

    Tip: To minimize and expand the Page Setup dialog box so that you can see more of your sheet, click Minimer indstillinger for sideopsætning or Udvid indstillinger for sideopsætning next to the box that you clicked in.

  4. Click OK.

  5. On the File menu, click Print.

    You can see how your sheet will print before you print it by clicking Preview.

Print column titles on every page

  1. Click the sheet.

  2. On the Layout tab, under Print, click Repeat Titles.

    Fanen Layout, gruppen Udskriv

  3. Under Print titles, click in the Rows to repeat at top box, and then on the sheet, select the row that contains the column titles.

    Tip: To minimize and expand the Page Setup dialog box so that you can see more of your sheet, click Minimer indstillinger for sideopsætning or Udvid indstillinger for sideopsætning next to the box that you clicked in.

  4. Click OK.

  5. On the File menu, click Print.

    You can see how your sheet will print before you print it by clicking Preview.

See also

Print part of a sheet

Print with landscape orientation

Scale the sheet size for printing

Preview pages before you print

Del Facebook Facebook Twitter Twitter Mail Mail

Var disse oplysninger nyttige?

Fantastisk! Har du mere feedback?

Hvordan kan vi forbedre det?

Tak for din feedback!

×