How do I print column headings on every page in Excel?

Posted on by Muna Meyer

How do I print column headings on every page in Excel?

How to Repeat Excel Spreadsheet Column Headings at Top of Page

  1. Click the [Page Layout] tab > In the “Page Setup” group, click [Print Titles].
  2. Under the [Sheet] tab, in the “Rows to repeat at top” field, click the spreadsheet icon.
  3. Click and select the row you wish to appear at the top of every page.

How do I repeat column headings on each page?

Repeat table header on subsequent pages

  1. In the table, right-click in the row that you want to repeat, and then click Table Properties.
  2. In the Table Properties dialog box, on the Row tab, select the Repeat as header row at the top of each page check box.
  3. Select OK.

How do you keep headings in Excel?

To freeze horizontal and vertical headings simultaneously:

  1. Select the cell in the upper-left corner of the range you want to remain scrollable.
  2. Select View tab, Windows Group, click Freeze Panes from the menu bar.
  3. Excel inserts two lines to indicate where the frozen panes begin.

How do I keep column headers when scrolling in Excel?

Freeze columns and rows

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

How do I repeat headings in Excel when printing?

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.

How do I print the header row in Excel?

On the Ribbon, click the Page Layout tab. In the Sheet Options group, under Headings, select the Print check box. , and then under Print, select the Row and column headings check box . To print the worksheet, press CTRL+P to open the Print dialog box, and then click OK.

How do I fix column headings in Excel?

Select the column that’s immediately to the right of the last column you want frozen. Select the View tab, Windows Group, click the Freeze Panes drop down and select Freeze Panes. Excel inserts a thin line to show you where the frozen pane begins.

How do I keep column headings visible in Excel when scrolling?

How do I make headings always show in Excel?

To keep the column headers viewing means to freeze the top row of the worksheet.

  1. Enable the worksheet you need to keep column header viewing, and click View > Freeze Panes > Freeze Top Row.
  2. If you want to unfreeze the column headers, just click View > Freeze Panes > Unfreeze Panes.

How do I repeat column headings at the bottom of the page in Excel?

MS Excel does not have a direct way of repeating rows at bottom or repeating columns at right while printing. It has options to only repeat rows or columns at top or left. One of the ways to repeat rows at the bottom of a page is to use a footer on every page.