Greyed out area on the spreadhseet
 

On various occasions, I receive an xl file where I can only view very few
columns & rows, all other are blocked ( solid grey area ). My question how I
can make all columns & rows visible, secondly how it was done in the first
place ?

Greyed out area on the spreadhseet
 

hello,

- check if the ws is protected.

- check if the column and rows are hide

- check on view if page break preview are checked


hth

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"zen" escreveu:

On various occasions, I receive an xl file where I can only view very few
columns & rows, all other are blocked ( solid grey area ). My question how I
can make all columns & rows visible, secondly how it was done in the first
place ?

Greyed out area on the spreadhseet
 

Maybe the grey area is just colored grey.

Uncolor them.

Maybe that area is just Hidden.

CTRL + a to select all then FormatColumnUnhide


Gord Dibben MS Excel MVP

On Wed, 18 Jun 2008 10:46:00 -0700, zen wrote:

On various occasions, I receive an xl file where I can only view very few
columns & rows, all other are blocked ( solid grey area ). My question how I
can make all columns & rows visible, secondly how it was done in the first
place ?

Greyed out area on the spreadhseet
 

You know i tried evrything but nothing really worked. The worksheet i have
has the first row and the first column completely grey, i cannot see the
gridlines or anything.

Anymore suggestions ?

"zen" wrote:

On various occasions, I receive an xl file where I can only view very few
columns & rows, all other are blocked ( solid grey area ). My question how I
can make all columns & rows visible, secondly how it was done in the first
place ?

Greyed out area on the spreadhseet
 

Tell us what you tried.

You had several suggestions.

What does nothing "really" worked mean?

Did anything "partly" or "sort of" work?


Gord

On Thu, 19 Jun 2008 10:56:02 -0700, zen wrote:


You know i tried evrything but nothing really worked. The worksheet i have
has the first row and the first column completely grey, i cannot see the
gridlines or anything.

Anymore suggestions ?

"zen" wrote:

On various occasions, I receive an xl file where I can only view very few
columns & rows, all other are blocked ( solid grey area ). My question how I
can make all columns & rows visible, secondly how it was done in the first
place ?