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?
 
B

Bob Phillips

File>Page Setup>Sheet and set the Rows to repeat box, like $1:$2 will use
the first tow rows as a repeating header.
 

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 4
Access Sorting and grouping using multiple tables 0
Header rows 4
Export Data from another source to use in an excel template 0
Transferspreadsheet - insert rows with no header 1
repeating subreport header on report 0
Column to Header 3
convert columns to rows 6

Top