Header Rows

  • Thread starter Thread starter Sactrain3
  • Start date Start date
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?
 
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.
 
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
 
Back
Top