Whining on imperfect technology.

* * * 66 Thank you comments * * *

Google : "Gec Living" to find us via Google

Friday, February 18, 2011

All my Excel cells are greyed out and I can't re-colour them

If everything in Excel is all gray and you can not change any of the colours even after changing the formatting. Then most likely you are viewing the Excel workbook in "Page Break Preview", if all the cells are gray even if you have nothing in it and never used that cell, then my guess is "Page Break Preview!

GO to View > Normal View and well. that should be it.

View > Page Break Preview to make it all gray again.

Solution gathered from:

http://www.mrexcel.com/forum/showthread.php?t=33739

1 comments:

  1. LOL, thanks for this tip! was quite handy today hehehe.

    ReplyDelete