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
 
Top