View Single Post
  #3   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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

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

Linda C wrote:
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?



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