lkpmai.blogg.se - Openoffice calc print column headers each page

The process is exactly the same, where, in Step 5, instead of choosing the row, you can select the column that you want to repeat.Īnd of course, you can also set the top row and the top column to repeat on every printed page. You can also set the left-most column (or multiple left-most columns) to repeat on every page when printed. Note that you need to select contiguous rows (i.e., you can set row number 1, 2, and 3 to be printed on every page, but you cannot set row number 1 and 3 to be repeated on every printed page) To do this, in Step 5 of the above steps, instead of selecting the top row, select multiple top rows that you want to repeat on every printed page. Just like we have configured the settings to print the top row on every page, you can also set it to print multiple header rows on every page. This will open the Print Preview pane.Ĭlick on the arrow icons at the bottom of the Print preview pane, and you should see the headers repeat on each of the pages. You can check this by Clicking on the ‘File’ tab and then clicking on the ‘Print’ option. Now, when you print this data, you will notice that the top row header repeats on every page that is printed.

Select the top row (you will notice that $1:$1 is automatically inserted in the “Rows to repeat at the top” field.

Click on the field next to the ‘Rows to repeat at top’ option.

In the ‘Page Setup’ dialog box, click on the ‘Sheet’ tab.

In the ‘Page Setup’ group, click on the dialog box launcher (the small tilted arrow as shown below).

If you print this data, it would take up multiple pages, but the heading will only appear on the first page.īelow are the steps to make sure that the header row repeats on every page that is printed: Suppose you have a dataset as shown below.

How to Print the Top Row on Every Page in Excel

How to Repeat Header Rows on Every Page Except the Last Few Pages?.Print the Rows on Every Page Using the NameBox Trick.How to Print the Top Row on Every Page in Excel.