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



"barlep" 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.

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.

"George Gee" wrote:

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" 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.

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

CTRL + a(twice in 2003) and FormatRowUnhide


Gord Dibben MS Excel MVP


On Thu, 24 May 2007 09:15:02 -0700, barlep
wrote:

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.

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"

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.

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

"Jim Cone" wrote:


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"

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

On Thursday, May 24, 2007 12:15 PM barle wrote:

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.


On Thursday, May 24, 2007 12:29 PM George Gee wrote:

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


On Thursday, May 24, 2007 12:38 PM barle wrote:

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.

"George Gee" wrote:


On Thursday, May 24, 2007 1:11 PM Gord Dibben wrote:

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

CTRL + a(twice in 2003) and FormatRowUnhide


Gord Dibben MS Excel MVP


wrote:


On Thursday, May 24, 2007 1:14 PM Jim Cone wrote:

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"

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.


On Thursday, May 24, 2007 1:20 PM barle wrote:

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

"Jim Cone" wrote:


Submitted via EggHeadCafe
Obsessive Defragmentation Disorder (ODD) and You
http://www.eggheadcafe.com/tutorials...d-and-you.aspx