Automatic Title on each page

G

Guest

I have a worksheet that has 45 pages. I inherited the worksheet from a
coworker. The worksheet has six columns that contain data. The column
headers used to appear at the top of each printed page. The worksheet
recently became corrupted and now I am unable to figure out how to put the
column headers back at the top of each page. Help!
 
P

Peo Sjoblom

File>page setup>sheet and rows to repeat at top, if it is the first row put
$1:$1


--
Regards,

Peo Sjoblom



"Don Murphy, Brev. County Elections" <Don Murphy, Brev. County
(e-mail address removed)> wrote in message
news:[email protected]...
 

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

1st 2 rows of wksht show up @ top of each page of the wksht 2
Display index of column headers in column A 9
Arggh! Each row prints on separate page 2
Insert automatic page numbering into a cell, not a header or foote 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel 2003 headers 2
Repeat printing rows in multiple worksheets 19
Putting a title on each page 1

Top