Whole sheet colour changed?? How to fix

  • Thread starter Thread starter MikeR-Oz
  • Start date Start date
M

MikeR-Oz

Hi, Must have clicked on a function key - do not know - but the whole sheet
is now a grey colour. I have tried highlighting the whole page and format/
cell/ patterns and changing to 'no colour' but cannot get it to go back.

Help

Mike
 
Maybe you hid all rows or columns?

CTRL + a(twice in 2003) to select all cells the Format>Row(or
column)>Unhide.


Gord Dibben MS Excel MVP
 
Gord, It is actually 1 worksheet out of the series of 6 in the workbook that
has the problem. The others are OK and it goes beyond the celss its the whole
excel screen?

Mike
 
Can you select any cell at all on the screen and see a value in the formula
bar?

Have you tried the unhide trick?


Gord
 
Gord, Problem was resolved by a work colleague clicking around - also not
knowing what theywere really doing but seemed to think I had set print area
to a whole screen of the sheet?? Any how it is back to normal. Hope not to
have wasted your time. Really do not understand what exactly happened. Cheesr
MIke
 
No waste of time.

Glad to hear you're sorted but I don't think setting the print area would
cause the gray colour unless perhaps you were in View>PageBreak Preview

Gord
 
Back
Top