-1

When I move the cursor in Excel 2007 from cell A1 to cell A2, so that cell A2 is highlighted instead of A1, sometimes I press the tab key too quickly, so I try to go back and highlight A1 again.

I tried ctrl+z, however this doesn't work, is it true it won't work in 2007? I thought every move in Excel can be cancelled by using ctrl+z?

  • possible duplicate of Excel shortcut to go back to previous cell (last position) - See my answer on this post, I think it's exactly what you want. – Dave Sep 25 '14 at 8:12
  • try using the Enter key – Firee Sep 25 '14 at 11:05
  • @Dave in fact i am not talking about quotes and dependants, i just talk about any cell in general, when i go from one to another, may it be empty or not. – hui wang Sep 28 '14 at 9:32
  • @Firee that won't work...that only go to one cell down. – hui wang Sep 28 '14 at 9:33
  • @huiwang, did you try my answer in the other post and you're saying it doesn't work? – Dave Sep 28 '14 at 10:09
0

Undo (Ctrl+z) only applies to changes. Individual navigation keystrokes (up, down, left, right, tab etc) are not considered changes so aren't tracked by Excel (in any version AFAIK).

However, there are a couple of things you can do to speed up your keyboard navigation beyond the basic up, down, left, right, PageUp, PageDown, etc. Here are some suggestions:

  1. The Home key you will jump to column 1 in the current row (assuming no columns are hidden), or if you have freeze panes in operation, it will jump to the left most column in the current pane.

  2. Ctrl+Home will take you to cell A1, or if you have panes frozen to the upper-left most cell in the active pane.

  3. Ctrl+End will take you to the lowest-right cell used on the worksheet.

  4. Ctrl+Left (or up, down, right) will take you to the edge cell in the currently selected range. eg if you have data in cells B2:D4 and you're in cell C4, hitting Ctrl+Up will take you to C2.

  5. You're aware that using Tab will move you one cell to the right. However, if you press Shift+Tab you will move one cell to the left.

  6. Ctrl+G brings up the Go To dialog box. Type in whatever cell reference you want to jump back to and hit Enter.

  7. Alt+PageUp is equivalent to "Page Left", Alt+PageDown works as "Page Right".

If none of these are any use, you'd have to write some VBA to log your navigation keystrokes and assign a keyboard shortcut that returns you to the most recently used "significant" keystroke. That's overkill though frankly, the keyboard you used to overshoot your destination can take you back pretty quickly.

See also: A complete list of Excel keyboard shortcuts for Excel 2007.

| improve this answer | |
  • you are the first one that got my meaning, thank god. Here you confirmed my suspicion as to whether the excel will 'ctrl+z) position moves, such as tab, arrow and mouse click. By the way if i use mouse click to set focus on another cell, excel can also not 'ctrl+z' it right? – hui wang Oct 11 '14 at 9:03
  • Ctrl+z will ignore all position moves, including tab, arrow, page up, page down etc. Even if you click another cell with your mouse, Excel will pay that no attention. Ctrl+z only allows you to undo changes to the worksheet (eg changing a value, format or formula). Even turning freeze panes on and off gets ignored by undo, because it's not a change to the worksheet itself. – Andi Mohr Oct 13 '14 at 8:53
  • that's very helpful thank you! Just to confirm, ctrl+z won't do the cancel work, will there be any other shortcut to do the position or other non sheet changes? – hui wang Oct 15 '14 at 2:42
  • Unfortunately no, Excel can't do this. – Andi Mohr Oct 15 '14 at 8:16
  • If this has answered your question would you mind ticking this to accept the answer? – Andi Mohr Oct 15 '14 at 8:17
0

If you accidentally overwrite the contents of a cell, pressing ESC will restore the original contents of the cell.

| improve this answer | |
  • it's not overwriting, just shifting the focus ... – hui wang Sep 25 '14 at 7:54
  • @dave I tried the answer in the other post and it won't work...coz it's not relevant to my question. – hui wang Oct 8 '14 at 10:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.