Results 1 to 6 of 6
  1. #1

    Member Since
    Feb 15, 2007
    Macbook 13" - IMAC 20"
    Crazy Mac Excel Question
    So maybe i'm just really anal but I thought I would ask anyway because it is bugging me that much.

    In my Excel spreadsheet, after I horizontally or vertically scroll to the end of my data, there appears a large gray area with nothing in it. I have searched everywhere on how to remove it with no luck. I have had good luck on this forum so far (which is why I will continue to buy macs) so I thought I would try. How do I get rid of this large gray area (which is now officially my nemesis) so that scrolling stops at my last column or row with data, and not clear down to the end of the gray area?

    If there is no way, I will humbly accept my defeat....

    Thanks for the help, and I faithfully use the reputation system.

  2. #2

    Member Since
    Apr 22, 2005
    Not happening for me. I can scroll forever and Excel just keeps adding rows or columns as I scroll. Must be some setting I'm not aware of.

  3. #3

    eric's Avatar
    Member Since
    Nov 04, 2006
    twin cities, mn, usa
    well, it should only scroll a certain amount to the side (i want to say 255 columns, but i might be wrong), but it could go on forever (theoretically) going down.

    also, are you using the arrows or the scroll bar to scroll, or are you doing it with a pointer trick? scroll bars should stop, the arrow and pointer tricks will go well past your data as you've noticed.

    edit: just checked, sideways my excel stops at column IV, which if you write a 1 in either the first or last column and then incrementally copy it to the other side ends up with 256 columns.
    Please participate in our Member of the Month polls. Every vote counts! And remember to use the user reputation system!
    ["Dear Homer, I. O. U. one emergency donut. Signed, Homer." - Note by Homer Simpson]

  4. #4

    traded's Avatar
    Member Since
    Nov 15, 2006
    Los Angeles
    MacBook Pro C2D 2.16
    What version of Office are you using?

  5. #5

    Member Since
    May 20, 2004
    iMac 21" 8GB, MBP 15" 2.5 Penryn, 4 GB/180 GB
    Howdy. It probably means that somehow you (or someone else) has hidden columns and rows.

    You should see 256 columns (Column IV is the last), and 65,536 rows. This is true for XL 98, 2001, X, and 2004 as well as corresponding Windows versions XL 97, 2000, 2002, 2003.

    If/when you upgrade to XL 2008, then you will have 16,000+ columns and 1,000,000+ rows.

  6. #6

    Member Since
    May 20, 2004
    iMac 21" 8GB, MBP 15" 2.5 Penryn, 4 GB/180 GB
    If the columns or rows are hidden, to unhide all of them, click on the small square above and to the left of cell A1, which selects the entire worksheet. Then go to

    Format > Row > Unhide


    Format > Column > Unhide

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Question about Excel 2004 for Mac
    By schwine1 in forum OS X - Apps and Games
    Replies: 0
    Last Post: 11-08-2012, 11:23 AM
  2. Excel 2008 for mac question
    By springville pop in forum OS X - Apps and Games
    Replies: 8
    Last Post: 08-18-2010, 08:49 PM
  3. excel for mac 2004 question
    By Terry1121 in forum Other Hardware and Peripherals
    Replies: 12
    Last Post: 12-01-2009, 09:47 AM
  4. Stupid Excel Question on Mac
    By Itchy in forum Switcher Hangout
    Replies: 2
    Last Post: 06-25-2008, 11:50 AM
  5. Ms Excel problem driving me crazy, help!!!
    By fleurya in forum OS X - Apps and Games
    Replies: 2
    Last Post: 01-14-2007, 02:19 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts