| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Go to Last edited cell
I have a huge worksheet and i frequently go up and down the worksheet
it becomes painful to go to the last edited cell Is there a command to go to the last edited cell? please help thanks in advance |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Go to Last edited cell
"Manju" wrote in message oups.com... I have a huge worksheet and i frequently go up and down the worksheet it becomes painful to go to the last edited cell Is there a command to go to the last edited cell? please help thanks in advance Hmmm..you mean without a macro? Unless someone comes up with a better idea I can think of an unelegant solution: Ctrl+Z , followed by Ctrl+Y (Ctrl+Z jumps to the last edited cell and undoes the last edit, Ctrl+Y redoes the edit.) Cheers, Joerg |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Go to Last edited cell
Hey that works fine for me. Thanks
Joerg wrote: "Manju" wrote in message oups.com... I have a huge worksheet and i frequently go up and down the worksheet it becomes painful to go to the last edited cell Is there a command to go to the last edited cell? please help thanks in advance Hmmm..you mean without a macro? Unless someone comes up with a better idea I can think of an unelegant solution: Ctrl+Z , followed by Ctrl+Y (Ctrl+Z jumps to the last edited cell and undoes the last edit, Ctrl+Y redoes the edit.) Cheers, Joerg |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Go to Last edited cell
But make sure you didn't saved your file before you UNDO or REDO your
task Manju wrote: Hey that works fine for me. Thanks Joerg wrote: "Manju" wrote in message oups.com... I have a huge worksheet and i frequently go up and down the worksheet it becomes painful to go to the last edited cell Is there a command to go to the last edited cell? please help thanks in advance Hmmm..you mean without a macro? Unless someone comes up with a better idea I can think of an unelegant solution: Ctrl+Z , followed by Ctrl+Y (Ctrl+Z jumps to the last edited cell and undoes the last edit, Ctrl+Y redoes the edit.) Cheers, Joerg |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert date | Excel Worksheet Functions | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Protect Cell from being edited | Excel Discussion (Misc queries) | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
Linear Mode
