Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default printing headers on every page

Hi;

I would like to print out rows 1 and 2 on a spreadsheet on every page of a
30+ page report.

Problem is that when I file, print preveiw, setup, sheet
I can not get the print titles area to let me select..

How do I turn this feature on for all future excel worksheets.

Thanks for you time and effort.

Sam

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default printing headers on every page

Use FilePagesetup...Sheet Sam

you can do it there

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Sam Hodo" wrote in message ...
Hi;

I would like to print out rows 1 and 2 on a spreadsheet on every page of a
30+ page report.

Problem is that when I file, print preveiw, setup, sheet
I can not get the print titles area to let me select..

How do I turn this feature on for all future excel worksheets.

Thanks for you time and effort.

Sam



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default printing headers on every page

Ron

Thanks


"Ron de Bruin" wrote:

Use FilePagesetup...Sheet Sam

you can do it there

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Sam Hodo" wrote in message ...
Hi;

I would like to print out rows 1 and 2 on a spreadsheet on every page of a
30+ page report.

Problem is that when I file, print preveiw, setup, sheet
I can not get the print titles area to let me select..

How do I turn this feature on for all future excel worksheets.

Thanks for you time and effort.

Sam




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print correct Page X of Y when printing single worksheet dbarrett44 Excel Discussion (Misc queries) 3 April 14th 06 03:34 AM
Printing two tabs of the same worksheet to one double-sided page Jennifer Excel Discussion (Misc queries) 1 April 13th 06 07:17 PM
First column not printing after 1st page. cridhe1 Excel Discussion (Misc queries) 1 February 10th 06 05:36 PM
page set up on excel to get 100% @ time of printing music icons Setting up and Configuration of Excel 0 January 10th 06 08:40 PM
Page #s and bottom corner dates have disappeared in printing. flowerpot Excel Discussion (Misc queries) 1 October 7th 05 08:07 PM


All times are GMT +1. The time now is 08:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"