Shaded cells won't print shaded

L

Linda C

On screen cells are shaded, but on print preview and printing, they are not.
Somone else created this spreadsheet, so I dont' know what she did to it.
Without having to recreate in a new spreadsheet, how can I fix this?
 
K

Ken Wright

Does it have macros? Maybe a Before_Print routine that gets rid of formatting
before printing, and then puts them back? If you open the file and disable any
macros, does this still happen?
 
D

Debra Dalgleish

If the worksheet is set to print in black and white, the shading won't
print. To change the setting:

Choose File>Page Setup
Select the Sheet tab
Remove the check mark from 'Black and White', click OK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Shading in cells is not printing....HELP! 1
How do I convert shading to highlighting for specific colors 8
table shading prints differently on different pages 0
Shade a Cell 7
Images are pixelated when saving to PDF 0
macro to disallow shading in certain columns 2
Shaded cells shift to the right when printing 1
AutoCAD 3D to Microsoft Word 1

Top