How do I delete blank rows at the bottom of a spreadsheet to get .

Discussion in 'Microsoft Excel Misc' started by Guest, Jan 26, 2005.

  1. Guest

    Guest Guest

    I have a spreadsheet that has been edited, expanded, edited. etc...

    Now, it' is down to about 1500 rows, yet the slider bar on the right is very
    tiny. When I hit Control+End to get to the end of the worksheet, it takes me
    to Column AA, Row 7569.

    I have selected all the rows betwee 1600 and 8000 and deleted them, but the
    vertical scroll bar and Control+End still takes me to 7569.

    What can I do to fix this?

    Thanks!
     
    Guest, Jan 26, 2005
    #1
    1. Advertisements

  2. Guest

    Paul B Guest

    Have a look here on how to reset the used range

    http://www.contextures.com/xlfaqApp.html#Unused

    --
    Paul B
    Always backup your data before trying something new
    Please post any response to the newsgroups so others can benefit from it
    Feedback on answers is always appreciated!
    Using Excel 2002 & 2003

    "Miklaurie" <> wrote in message
    news:...
    >I have a spreadsheet that has been edited, expanded, edited. etc...
    >
    > Now, it' is down to about 1500 rows, yet the slider bar on the right is
    > very
    > tiny. When I hit Control+End to get to the end of the worksheet, it takes
    > me
    > to Column AA, Row 7569.
    >
    > I have selected all the rows betwee 1600 and 8000 and deleted them, but
    > the
    > vertical scroll bar and Control+End still takes me to 7569.
    >
    > What can I do to fix this?
    >
    > Thanks!
     
    Paul B, Jan 26, 2005
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Pat Tiller

    Extra rows at bottom of spreadsheet

    Pat Tiller, Jan 7, 2004, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    675
    Guest
    Jan 7, 2004
  2. Guest
    Replies:
    1
    Views:
    203
    Tom Ogilvy
    Jul 5, 2005
  3. Guest
    Replies:
    5
    Views:
    263
    robert111
    Aug 22, 2006
  4. Guest
    Replies:
    2
    Views:
    812
    Guest
    Sep 2, 2006
  5. Guest
    Replies:
    2
    Views:
    311
    Gord Dibben
    May 3, 2007
  6. Guest
    Replies:
    2
    Views:
    573
    Guest
    Jun 27, 2007
  7. Guest
    Replies:
    1
    Views:
    256
    Gord Dibben
    Aug 7, 2007
  8. Kathy
    Replies:
    1
    Views:
    376
    Sheeloo
    Apr 23, 2009
Loading...