Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
When I click Ctrl+End, Excel takes me to row 8000+. The actual end of my
worksheet is AN381. How do I reset the worksheet so that all the 'empty' rows no longer show up as part of the worksheet - so that when I click Ctrl+End, it takes me to the true last cell/row? |
#2
![]() |
|||
|
|||
![]()
Cachod, have a look here
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 "Cachod1" wrote in message ... When I click Ctrl+End, Excel takes me to row 8000+. The actual end of my worksheet is AN381. How do I reset the worksheet so that all the 'empty' rows no longer show up as part of the worksheet - so that when I click Ctrl+End, it takes me to the true last cell/row? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
Reference Data in Moved Worksheet | Setting up and Configuration of Excel | |||
Worksheet name and Backward compatibility | Excel Discussion (Misc queries) |