ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   printing cells (https://www.excelbanter.com/excel-worksheet-functions/33389-printing-cells.html)

andrewm

printing cells
 

Hi
When I print a sheet there are a few cells which I would like not to
print.
When I highlight the print area without the cells I don't want to
print, it prints out several pages.
How can I print a whole sheet all in one and not print (show blank)
certain cells


andrewm


--
andrewm
------------------------------------------------------------------------
andrewm's Profile: http://www.excelforum.com/member.php...o&userid=23130
View this thread: http://www.excelforum.com/showthread...hreadid=383763


Debra Dalgleish

You can use conditional formatting to hide the content of some cells
when printing. There's an example he

http://www.contextures.com/xlCondFormat03.html

andrewm wrote:
Hi
When I print a sheet there are a few cells which I would like not to
print.
When I highlight the print area without the cells I don't want to
print, it prints out several pages.
How can I print a whole sheet all in one and not print (show blank)
certain cells


andrewm




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 07:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com