Repeating the Row Headers on each page

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!!
 
G

Gord Dibben

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 1
Repeating Rows - Exception 1
Row 1 HEADERS on EVERY printed page 2
Print Titles - Columns to Repeat at Left 1
creating repeating headers in a worksheet 3
Excel sheet with numbers as column & row headers - How? 3
Header Insanity 2
Copy several row headers to rows (blank) below for each header 1

Top