Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

2 Answers 2

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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