Gray area at spreadsheet

[barlep]

When I open various Excel spreadsheets, the entire area below the data is all
grayed out and I can't make it disappear. I want to copy and paste some
additional information in that area but when I do, it stays gray. I've
checked the fill and pattern buttons, but neither of those rectify the
problem.

 

[George Gee]

The rows below your data may be hidden.
Click the small grey rectangle above the number 1,
and to the left of the letter A.
On the top toolbar click > Format > Row > Unhide.

HTH

George Gee

 

[barlep]

I forgot to mention that I had also tried that. There are three rows hidden;
however, when I unhide them, they are in the grayed area. So, that's not it
either. Thanks for trying.

 

[Gord Dibben]

Sounds like that area has hidden rows to bottom of sheet.

CTRL + a(twice in 2003) and Format>Row>Unhide


Gord Dibben MS Excel MVP

 

[Jim Cone]

You may be in "Page Break Preview".
Go to the View menu and select "Normal"
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"barlep"
<[email protected]>
wrote in message
When I open various Excel spreadsheets, the entire area below the data is all
grayed out and I can't make it disappear. I want to copy and paste some
additional information in that area but when I do, it stays gray. I've
checked the fill and pattern buttons, but neither of those rectify the
problem.

 

[barlep]

Gosh, I knew it had to be something simple like that! Thanks for the help!

 

[Hans Vanmechelen]

TX - that helped me out

When I open various Excel spreadsheets, the entire area below the data is all
grayed out and I can't make it disappear. I want to copy and paste some
additional information in that area but when I do, it stays gray. I've
checked the fill and pattern buttons, but neither of those rectify the
problem.