up vote 1 down vote favorite
share [g+] share [fb]

I currently have to do some work in an Excel sheet and as we all know Enter jumps to the next row (at the current column) and I can start typing.

Until I have to use the arrows (Ctrl + ←/→), which occurs quite often. Then Excel navigates to another cell and I have to use the mouse an click the editingbar at the top (or doubleclick the cell) so I can use the arrows. Is there any shortcut to jump to the editingbar, so I dont need to use the mouse?

link|improve this question
feedback

migrated from stackoverflow.com Aug 7 '09 at 12:28

This question came from our site for professional and enthusiast programmers.

2 Answers

up vote 2 down vote accepted

You can use F2 to edit a cell.

link|improve this answer
Thanks. Now I can edit these 300 items without getting angry :) – Anonymous Aug 7 '09 at 11:25
The complete list of shortcuts can be found at: office.microsoft.com/en-us/excel/HP052037811033.aspx – WireGuy Aug 7 '09 at 12:48
feedback
up vote 0 down vote

You can also disable the moving of the cursor on enter under Excel Advanced Options.

In Office 2007:

  • Ribbon Button
  • Excel Options
  • Advanced
  • After pressing Enter, move selection: Untick the box

In older versions it is under the Edit tab if I remember correctly.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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