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! |
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! |
All times are GMT +1. The time now is 05:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com