LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default Whole sheet colour changed?? How to fix

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 ViewPageBreak Preview

Gord


On Fri, 12 Sep 2008 04:57:01 -0700, MikeR-Oz
wrote:

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

"Gord Dibben" wrote:

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

On Wed, 10 Sep 2008 19:38:01 -0700, MikeR-Oz
wrote:

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

"Gord Dibben" wrote:

Maybe you hid all rows or columns?

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


Gord Dibben MS Excel MVP

On Wed, 10 Sep 2008 18:06:01 -0700, MikeR-Oz
wrote:

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





 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change colour of cells when content is altered/changed BUT NOT TO INSERTED OR DELETED ROWS Martin ©¿©¬ @nohere.net Excel Discussion (Misc queries) 3 April 12th 08 05:13 PM
do some code after the sheet name is changed ARHangel Excel Discussion (Misc queries) 1 January 18th 08 10:39 AM
Change colour of cells when content is altered/changed Martin ©¿©¬ [email protected] Excel Discussion (Misc queries) 8 December 8th 06 05:37 PM
Change Colour on a Cell after another cell has been changed David Hardy Excel Discussion (Misc queries) 1 August 30th 06 04:15 PM
Change colour of data when changed Martin ©¿©¬ @REMOVETHIS.plus.com Excel Discussion (Misc queries) 3 May 13th 06 10:37 AM


All times are GMT +1. The time now is 08:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"