Greyed out

A

Andrew Davis

I chose not to to hide a worksheet but to make it grey
instead(so that the sheet is viewable but not the
contents) but I have now forgotten how to ungrey it.
 
A

Andy B

You've already had two answers to your other post. Please don't multipost.
If the answers are no good, tell us, but don't just repost in another NG.
 
A

Andrew Davis

I thought I had used the same process both times but I
seemed to come to a different place. Wherever the other
place is I have come here. If Microsoft routes me to
different places, how do I know that I'll ever find the
original place? I am sure the answer to my problem is
very simple. So the answers, in the other place, are
likely to be correct. However if I cannot see them they
are no use to me.
 
A

Andy B

Well, as you've found this, I'll copy what was posted here!

One suggestion was that maybe you've coloured the cells grey from
Format/Cells/Pattern, and another suggestion was that you've hidden the
cells.
It depends really on what you can see - and what you can't!
 
P

papou

Hi

Maybe you just set the cell pattern to a grey colour? Hit Ctrl A to select
all of the cells, then Format / Cells / Pattern tab, and change the fill to
No colour

--
Andy.

Hi Andrew
May be you mean hiding all rows and all columns ?

HTH
Cordially
Pascal
 
A

Andrew Davis

Thank you. I have just checked the fill although it was
a protect type action that I did.
 
A

Andy B

Can you see the cells? Can you see the values/formulas in the cells? Can you
type on the sheet? If you go to Tools / Protection does it show Protect
sheet/book or Unprotect sheet/book?

--
Andy.


Thank you. I have just checked the fill although it was
a protect type action that I did.
 
A

Andrew Davis

Thank you for that. No I can hide and unhide the sheet.
Hiding is not the problem here. But you have given me
the answer. As you said, it depends on what I can see.
So I went back so that I might accurately describe what I
could see and then I noticed while all the column titles
showed the row titles did not. What had happened was
that the sheet was in print preview|page break review
mode and all the rows I had been using had a hieght of
zero. So the whole sheet looked grey. Thanks again.
 
A

Andrew Davis

Thank you. I had tried all those routes, that is why it
was getting frustrating. But by looking closer to
explain the problem I found the answer. Thanks again.
 
Top