#1   Report Post  
Posted to microsoft.public.excel.misc
danhattan
 
Posts: n/a
Default Why is this printing

I have a situation where I've set both the shading and font color of a group
of cells to the same shade of light grey. This is because I know that these
cells will link to other cells with 0 values, and I don't want the 0's to
print. (They don't affect any formulas and to remove the links would require
redefining dozens of blocks referenced in macros.)

On the screen, these cells appear to be empty with nothing in them. However,
when I print, I see all the 0's on the printed page. If anyone could explain
to me why this is happening it would be much appreciated. Thank you.
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
Printing in Excel overlaps previous text Nash Excel Discussion (Misc queries) 2 November 8th 05 03:42 PM
Printing Recto/Verso Sam Vanderstraeten Excel Discussion (Misc queries) 2 July 7th 05 12:44 PM
Cell borders printing black instead of grey julie@mwfc Excel Discussion (Misc queries) 1 February 23rd 05 12:19 AM
problem printing to PDF mark kubicki Excel Discussion (Misc queries) 1 January 21st 05 06:19 PM
Enable Double sided printing contiuously when printing multiple s. Lee Excel Discussion (Misc queries) 1 November 27th 04 01:58 AM


All times are GMT +1. The time now is 10:16 PM.

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"