Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
listing data without blank rows | Excel Worksheet Functions | |||
Blank rows | Excel Discussion (Misc queries) | |||
Blank Rows | Excel Discussion (Misc queries) | |||
How do I delete 100 account numbers from a spreadsheet colume wer. | Excel Worksheet Functions | |||
Inserting Blank Rows Macro? | Excel Worksheet Functions |