i want to Fill Color in a cell but dont want the colour to print?

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

Guest

well i'm making a form on excel, and i want ppl to know where they need to
enter the amounts, but when it prints i dont want the background to have a
shade! i just want the shade to be there on the screen! what i did was put a
yellow color shade in the cells that i want ppl to enter the amounts, but
when i print it i get a yellow shade in the background of the amount, and i
just dont want the shade to be there. thx for ur help aman
 
Akashee,

File / Page SetUp... Sheet tab, check "Black and White"

HTH,
Bernie
MS Excel MVP
 
If you select Print Preview, then Setup and choose the Sheet tab on the Page
Setup dialog, there is an option to Print - Black and White. That should do
it.
 
You must log in or register to reply here.

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

Excel 2007: cell shading (not conditional formatting) 1
show fill color of a shaded row 3
If using =MOD(ROW(),2)=0 conditional formatting and want diff fill 1
Printing Comments- just the corner 4
Is there a non-printing shading? 1
How do I use different colours in drop down menus in Excel 2003? 4
cell shading 1
Can you shade one cell 2 different colors? 1

Back
Top