View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.newusers
Hans Vanmechelen Hans Vanmechelen is offline
external usenet poster
 
Posts: 1
Default You may be in "Page Break Preview".

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