Shaded cells won't print shaded

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
 
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
macro to disallow shading in certain columns 2
Excel 2003 bank ledger spreadsheet background fill shading 4
Shading Cells 1
Cell Shading 2
SUMIF based on cell shading 1
Shading 2
shade cells based on conditions - i have more than 3 conditions 3

Back
Top