LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
HMS HMS is offline
external usenet poster
 
Posts: 2
Default How can I set some cells to not print w/o changing print layout?

I have setup a template in Excel 2003 to print onto a pre-printed form. As
the headers are on the pre-printed form I don't want them to print from the
worksheet that I have setup in excel but these headers need to be viewable to
know where to enter the info that does need to print on the form. I have
tried setting the print area to only include the fields that I want to print
but it generates a separate printable page for each field and loses the
formatting. How can I have the entire worksheet viewable but only print the
needed fields and maintain the page layout so that each of these fields print
in the right spot.
 
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
Default Print Layout hstijnen Excel Discussion (Misc queries) 3 April 8th 08 09:39 PM
Print layout capt Excel Discussion (Misc queries) 9 February 5th 08 03:02 PM
First page of Excel sheerepeats in print layout or print preview philfrotonda Excel Discussion (Misc queries) 1 July 12th 07 09:28 PM
Can view file in print preview, but not print layout.... kkaden Excel Discussion (Misc queries) 1 March 22nd 06 05:54 PM
Code for Print Layout Phil Osman Excel Discussion (Misc queries) 1 March 31st 05 06:18 AM


All times are GMT +1. The time now is 07:58 AM.

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

About Us

"It's about Microsoft Excel"