Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Control End After the Sheet is Modified
Hi,
I use control end a lot to go to the bottom right corner of my big sheets. If you delete rows & columns of data it no longer goes to the right hand of the data. Is there any easy way to navigate to the end of the current data? End and down arrow doesn't work if there are gaps in the data. Thanks for looking. Paul |
#2
|
|||
|
|||
You should use <Home <End
Kassie "Paul" wrote: Hi, I use control end a lot to go to the bottom right corner of my big sheets. If you delete rows & columns of data it no longer goes to the right hand of the data. Is there any easy way to navigate to the end of the current data? End and down arrow doesn't work if there are gaps in the data. Thanks for looking. Paul |
#3
|
|||
|
|||
In '03 what works for me is Ctrl+arrow key. This does require more than one
shot depending on how many empty rows/columns exist between occupied cells, but it is the quickest way I've been able to come up with. Hope this is useful |:) "Paul" wrote: Hi, I use control end a lot to go to the bottom right corner of my big sheets. If you delete rows & columns of data it no longer goes to the right hand of the data. Is there any easy way to navigate to the end of the current data? End and down arrow doesn't work if there are gaps in the data. Thanks for looking. Paul |
#4
|
|||
|
|||
Paul
After deleting......deleting, not clearing..... the excess rows and columns you must save the workbook to reset the used range. In some versions you must save and close then re-open to see changes in used range. Gord Dibben Excel MVP On Fri, 18 Feb 2005 05:05:02 -0800, "Paul" wrote: Hi, I use control end a lot to go to the bottom right corner of my big sheets. If you delete rows & columns of data it no longer goes to the right hand of the data. Is there any easy way to navigate to the end of the current data? End and down arrow doesn't work if there are gaps in the data. Thanks for looking. Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheet Modified date in a cell.. ? | Excel Worksheet Functions | |||
where can i get an excel sheet for stock control | Excel Discussion (Misc queries) | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |