Greyed out area on the spreadhseet

Z

zen

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 ?
 
M

Marcelo

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:
 
G

Gord Dibben

Maybe the grey area is just colored grey.

Uncolor them.

Maybe that area is just Hidden.

CTRL + a to select all then Format>Column>Unhide


Gord Dibben MS Excel MVP
 
G

Gord Dibben

Tell us what you tried.

You had several suggestions.

What does nothing "really" worked mean?

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


Gord
 
Top