View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Learner101b Learner101b is offline
external usenet poster
 
Posts: 16
Default Printing labels at the top of multiple pages

That does it. Thanks for your help.
Learner101b

"Jim Cone" wrote:


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