Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Printing / July 2004

Tip: Looking for answers? Try searching our database.

Omit cells from Printing

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rory - 08 Jul 2004 11:34 GMT
Is there any way to omit certain cells from printing. I
have a sheet that contains some cells for inputs that I
don't want to print. I've tried to select the desired
cells and add them to the print range, but Excel gives
each selection a new page. Any ideas?
Paul B - 08 Jul 2004 11:48 GMT
Rory, if the cells are all in one row or column you could hide them before
you print, or you could change the font color in the cells to white, or to
the background color if it is not white, print the sheet and change it back,
if this is something you do often you could record a macro when you do it
and then you will only have to run it next time

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **

> Is there any way to omit certain cells from printing. I
> have a sheet that contains some cells for inputs that I
> don't want to print. I've tried to select the desired
> cells and add them to the print range, but Excel gives
> each selection a new page. Any ideas?
Bill Sharpe - 12 Jul 2004 17:16 GMT
Depending on where the cells to omit are located, this may work:
 1.. On the View menu, click Page Break Preview.
 2.. Select the area you want to print.
 3.. On the File menu, point to Print Area, and then click Set Print
Area.
Bill

Is there any way to omit certain cells from printing. I
have a sheet that contains some cells for inputs that I
don't want to print. I've tried to select the desired
cells and add them to the print range, but Excel gives
each selection a new page. Any ideas?
Paul Cundle - 12 Jul 2004 18:44 GMT
Step 1 can be omitted, though - there is no need to go to the Pagebreak
Preview to set a print area.

Paul C,
Signature


> Depending on where the cells to omit are located, this may work:
>   1.. On the View menu, click Page Break Preview.
[quoted text clipped - 8 lines]
> cells and add them to the print range, but Excel gives
> each selection a new page. Any ideas?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.