| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 67091 | 2006-03-16 19:18:00 | Excel help, return to previous location shortcut? | Heather J (815) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 438699 | 2006-03-16 19:18:00 | Excel help please Could you please help? When I am working on a spreadsheet,I finish entering data into one cell e.g A 2, then move to another cell e.g M 25, enter the data, but I then want to return to cell A2 to edit the data, is there a shortcut key to do this? (As in Words there is Shift + F5 to return to a previous editing location). |
Heather J (815) | ||
| 438700 | 2006-03-16 22:05:00 | Hi Heather, I would like to be proved wrong but there doesn't appear to be a shortcut for that unfortunately. If you would like I could write a macro that could do this and you can assign your own shortcut key combo to it. regards, Graham |
Parry (5696) | ||
| 438701 | 2006-03-16 22:22:00 | Keyboard shortcuts are found in Excel help by searching for, oddly enough, "Keyboard shortcuts" There is a shortcut key, but it's not quick: Crtl + G "Special" "Last cell" |
kingdragonfly (309) | ||
| 438702 | 2006-03-17 00:37:00 | Hi, the LastCell is not the last cell that was selected, but rather the last cell in a range. ie if you had data in A2, A5 and A10 then A10 is the last cell with data in the sheet. Heather is asking for the previous cell selected from the current one (or was it the last cell changed?). | Parry (5696) | ||
| 438703 | 2006-03-17 00:40:00 | Yep, you're right. | kingdragonfly (309) | ||
| 438704 | 2006-03-17 19:25:00 | thank you so much for your kindness in taking time to help me. Thank you Graham for offering to write a macro, but you would have seen my eyes glaze over and my brain saying I have heard of those, but no idea how to use etc... Thank you also kingdragonfly for your input. You are dealing with a person who has been dragged screaming and kicking from her beloved Works 97 on her now defunct Windows 95 computer to a new computer with Office 2003. I think the only function that makes sense to me in Excel is AutoSum. Oh well during the winter I will be off to a course to to learn about Office. Thank you so much again. |
Heather J (815) | ||
| 1 | |||||