Repeating the Row Headers on each page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet with several pages on it. I want to repeat the rows
headers that came on the first page on each page. How to do that?
Please help!!
 
TS

Assuming "pages" means printed pages.........

File>Page Setup>Sheet>Print Titles.

Rows to repeat at top and Columns to repeat at left.

Assuming "pages" means worksheets............

Select first sheet then right-click and "select all sheets"

Enter your headers/titles in row 1 on active sheet.

These will be replicated on each sheet.

DO NOT FORGET to "ungroup" the sheets when done.


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repeating Rows - Exception 1
Insert automatic page numbering into a cell, not a header or foote 1
Repeating Rows 1
Repeating only a portion of both row and column on multiple pages 1
Header rows 4
Repeat Rows at Top - Except Final Page 2
Header Insanity 2
Change print titles (rows to repeat at top) on subsequent pages 2

Back
Top