Header Rows

S

Sactrain3

I am still a novice when it comess to Excel, but I'm learning more about it.
I had to edit a table in Excel today and could not figure out how to create a
header row to print on each page. Any suggestions?
 
T

TGS

Page Setup, Sheet, field "rows to repeat at top" then the tricky thing is
enter a range, eg "A1:A5". If you have more than one row, I'm lost.
 
G

Gord Dibben

A1:A5 will give you 5 rows repeated

For more than one row the general syntax is................

$1:$x where x is row number


Gord Dibben MS 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 a row other than the 1st row as the header row in a table from next page 1
Header Rows 1
Skipping the first row in a repeated header 0
Space at end of multi page list to accommodate new entries 1
Office 365 documents default header 1
Append Crosstab Query to Existing Table 0
Style Header Reformatted 3
I need help with removing the header & footers on the last page in word 2010 7

Top