| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you reset the position that pressing CTRL-END moves you to?
In Excel, pressing CTRL-END moves the cursor to the furthest
bottom-right-hand used cell in the s/sheet. Suppose this is AZ1000. Delete 500 (bottom) rows and press CTRL-END again. This still takes you to cell AZ1000, and not AZ500 as you might expect. Having deleted rows/columns in a s/sheet, how does one reset the position of the 'END' cell that Excel stores? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you reset the position that pressing CTRL-END moves you to?
Try clicking save first. This should reset your range.
"PeterB" wrote: In Excel, pressing CTRL-END moves the cursor to the furthest bottom-right-hand used cell in the s/sheet. Suppose this is AZ1000. Delete 500 (bottom) rows and press CTRL-END again. This still takes you to cell AZ1000, and not AZ500 as you might expect. Having deleted rows/columns in a s/sheet, how does one reset the position of the 'END' cell that Excel stores? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do you reset the position that pressing CTRL-END moves you to?
Peter
Try saving the workbook and then using Ctrl+End Richard "PeterB" wrote in message ... In Excel, pressing CTRL-END moves the cursor to the furthest bottom-right-hand used cell in the s/sheet. Suppose this is AZ1000. Delete 500 (bottom) rows and press CTRL-END again. This still takes you to cell AZ1000, and not AZ500 as you might expect. Having deleted rows/columns in a s/sheet, how does one reset the position of the 'END' cell that Excel stores? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pressing TAB cursor moves a page to the right and not only 1 cell | Excel Discussion (Misc queries) | |||
| My Ctrl+D doesn't work, how can I reset? | Excel Discussion (Misc queries) | |||
| CTRL + END moves to the blank cell where data used to be | Excel Worksheet Functions | |||
| Pressing ctrl (Excel - selecting cells) causes mouse to freeze..? | Excel Discussion (Misc queries) | |||
| Textbox moves position when Printing? | Excel Discussion (Misc queries) | |||
Linear Mode
