How do you lock cells in Excel so they print on every page?

Article SummaryX

1. Open your project in Excel.
2. Click the Page Layout tab.
3. Click Print Tiles.
4. Enter the rows that you want to print on each page next to "Rows to repeat at top."
5. Enter the columns that you want to print on each page next to "Columns to repeat at left."
6. Click Ok.

Table of Contents Show

Print row and column headings
Print row or column titles on every page
Print row and column headings
Print row titles on every page
Print column titles on every page
How do I print locked cells on every page?
How do I lock cells for printing in Excel?
How do you keep cells on each page in Excel?
How do I lock cells so they don't scroll?

Did this summary help you?YesNo

Thanks to all authors for creating a page that has been read 16,706 times.

Normally, you can apply the Freeze Panes feature to freeze the header row when scrolling the worksheet, but, when printing the pages of this worksheet, the freeze pane is no longer locked. How could you always show up the freeze header row for each printed page in Excel?

Always print frozen panes on every page in Excel

Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari!Save 50% of your time, and reduce thousands of mouse clicks for you every day!

To always show up the frozen pane on each page when printing the worksheet, please do as follows:

1. Go the worksheet that you want to print, and click Page Layout > Page Setup, see screenshot:

2. In the Page Setup dialog box, click Sheet tab, and then select the row or column range that you want to print on each page under the Print titles section, see screenshot:

3. And then click Print Preview button to view the print result, and you can see the frozen header row is always displayed at the top of each printed page, see screenshot:

Note: If you have more than one worksheet selected, the Rows to repeat at top and Columns to repeat at left boxes are not available in the Page Setup dialog box. To cancel a selection of multiple worksheets, click any unselected worksheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu.

If you want to print a sheet 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.

Row headings

Column headings

Column titles

Row titles

Newer versionsOffice 2011



Print row and column headings

Click the sheet.
On the Page Layout tab, in the Sheet Options group, select the Print check box under Headings.
On the File menu, click Print.
You can see how your sheet will print in the preview pane.

Print row or column titles on every page

Click the sheet.
On the Page Layout tab, in the Page Setup group, click Page Setup.
Under Print Titles, click in Rows to repeat at top or Columns to repeat at left and select the column or row that contains the titles you want to repeat.
Click OK.
On the File menu, click Print.
You can see how your sheet will print in the preview pane.

Print row and column headings

Click the sheet.
On the Layout tab, under Print, select the Headings check box.
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

Click the sheet.
On the Layout tab, under Print, click Repeat Titles.
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
or
next to the box that you clicked in.
Click OK.
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

Click the sheet.
On the Layout tab, under Print, click Repeat Titles.
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.

How do I print locked cells on every page?

Always print frozen panes on every page in Excel.

Go the worksheet that you want to print, and click Page Layout > Page Setup, see screenshot:.

In the Page Setup dialog box, click Sheet tab, and then select the row or column range that you want to print on each page under the Print titles section, see screenshot:.

How do I lock cells for printing in Excel?

To lock the print area, first select the cells that you want to protect. Then, click the "Review" tab and click "Protect Sheet." In the "Protect Sheet" dialog box, check the "Locked" option and click "OK."

How do you keep cells on each page in Excel?

Click the [Page Layout] tab > In the "Page Setup" group, click [Print Titles]. Under the [Sheet] tab, in the "Rows to repeat at top" field, click the spreadsheet icon. Click and select the row you wish to appear at the top of every page. Press the [Enter] key, then click [OK].

How do I lock cells so they don't scroll?

Freeze columns and rows Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Select View > Freeze Panes > Freeze Panes.