How do I create table headers in an Excel shreadsheet? 1

[Sherman6789]

How do I create table headers for the top rows in an Excel spreadsheet?
We have a multiple page document with 12 columns. We need to see the header on each page. We've tried to temporary fixes.

1. Make a normal header/footer and attempt to place row headers in the same location as the columns in the table so that it will showup on each page.

2. Cut and paste the heading at the top of each page after making space for the heading. Problem: When items are moved or added to pages, the headings shift.

Any assistance that you can give will be appreciated. I know how to do this in WordPerfect and MS Word Tables but I can not find it in Excel. I don't believe that it can not be done.

 

[AnotherHiggins]

File > Page Setup > Sheet > Rows to repeat at top

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[Sherman6789]

Thanks Anotherhiggins. Several of us tried and tried to find this with no luck. I would have expected this to be in either "format" or "options". Thank you, Thank you, Thank you.

WRS

 

[AnotherHiggins]

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.