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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Pat Tiller

    Extra rows at bottom of spreadsheet

    Pat Tiller, Jan 7, 2004, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    467
    Guest
    Jan 7, 2004
  2. Guest
    Replies:
    2
    Views:
    182
    Gord Dibben
    May 3, 2007
  3. Guest
    Replies:
    2
    Views:
    371
    Guest
    Jun 27, 2007
  4. Guest
    Replies:
    1
    Views:
    169
    Gord Dibben
    Aug 7, 2007
  5. Kathy
    Replies:
    1
    Views:
    288
    Sheeloo
    Apr 23, 2009
Loading...

Share This Page