Gray area at spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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.
 
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
 
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.
 
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.
Click to expand...
 
Back
Top