Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Miklaurie
 
Posts: n/a
Default How do I delete blank rows at the bottom of a spreadsheet to get .

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!
  #2   Report Post  
Paul B
 
Posts: n/a
Default

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
listing data without blank rows Shooter Excel Worksheet Functions 17 April 24th 06 01:11 AM
Blank rows Mark Excel Discussion (Misc queries) 2 December 26th 04 10:10 PM
Blank Rows Acesmith Excel Discussion (Misc queries) 1 November 30th 04 09:23 PM
How do I delete 100 account numbers from a spreadsheet colume wer. Ndubuisi Azuogu Excel Worksheet Functions 2 November 11th 04 04:11 PM
Inserting Blank Rows Macro? Michael Saffer Excel Worksheet Functions 2 November 9th 04 06:23 PM


All times are GMT +1. The time now is 04:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"