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 ?