Printing labels at the top of multiple pages

L

Learner101b

I would like my top row that has my 'labels' in the cells to print at the top
of each page that prints. Similar to the screen 'freeze pane' command except
on a printed copy. I know I could use the 'header' function, but that does
not allow me to format the cells the way that I want to. Any ideas? And if
I can do this for rows, does the same ability exist for columns?

Thanks for any help,
Learner101b
 
J

Jim Cone

File (menu) | Page Setup | Sheet (tab)...
"Rows to repeat at top" and "Columns to repeat at left"
(click in the box and then select the rows/columns)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins - download the free trial of "Rows to Repeat at Bottom")


"Learner101b"
wrote in message
I would like my top row that has my 'labels' in the cells to print at the top
of each page that prints. Similar to the screen 'freeze pane' command except
on a printed copy. I know I could use the 'header' function, but that does
not allow me to format the cells the way that I want to. Any ideas? And if
I can do this for rows, does the same ability exist for columns?

Thanks for any help,
Learner101b
 
F

FSt1

hi
have you tried.....
on the menu bar
file>page setup>sheet tab>row to repeat at top:

Regards
FSt1
 
L

Learner101b

That does it. Thanks for your help.
Learner101b

FSt1 said:
hi
have you tried.....
on the menu bar
file>page setup>sheet tab>row to repeat at top:

Regards
FSt1
Click to expand...
 

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

Keep Headers at top of page 5
Print Titles: Repeating both left column and top rows 2
How do I freeze a row on the bottom of my screen? 4
Excel: Repeating Row 1 Content at top of all printed pages 2
Freeze multiple rows/columns in Excel 2007 11
printing a header in Excel 2
Printing - different rows at top for each page 1
Printing very large spreadsheet 1

Top