Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

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

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

up vote 2 down vote accepted

You can use F2 to edit a cell.

share|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

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.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .