Hide Cell Fill Color When Printing

MichaelWayne_71

Board Regular
Joined
Nov 9, 2005
Messages
60
Is there a way to hide the cell fill color when printing?

I have cells that users can edit filled with yellow. I don't want this color to print.

Also, can you protect a column from being unhidden?

Thanks!!!
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Tazguy37

MrExcel MVP
Joined
May 28, 2004
Messages
4,237
MichaelWayne_71 said:
Also, can you protect a column from being unhidden?

Thanks!!!

Hide the column.
Go to Tools, Protection, Protect Sheet. I prefer to make sure only "Select unlocked cells" is checked. Enter a password, click OK and verify the password.

Hope that helps!
 

Watch MrExcel Video

Forum statistics

Threads
1,119,144
Messages
5,576,326
Members
412,716
Latest member
thviid
Top