Greyed out

  • Thread starter Thread starter Andrew Davis
  • Start date Start date
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.
 
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.
 
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.
 
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!
 
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
 
Thank you. I have just checked the fill although it was
a protect type action that I did.
 
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.
 
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.
 
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.
 
Back
Top