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

Header Rows 1
Access Sorting and grouping using multiple tables 0
Using header on first page only 2
Sort behaves unexpectedly 1
Header rows 4
Transferspreadsheet - insert rows with no header 1
Insert last saved date into header 9
repeating subreport header on report 0

Top