Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

In Excel

When you want to edit the highlighted cell, and you don't want to move back to the previous cell when pressing the <- key, you press F2.

Pressing F2 ensures that when you're editing the cell, the cursor will move back to the previous character and not the previous cell.

In Google Docs Spreadsheets?

In Google Docs spreadsheets, the only way to achieve similar functionality to F2 in Excel is by double-clicking the cell with the mouse.

Pressing enter on the selected cell in Google Docs re-instantiates the behavior where pressing the <- key moves you to the previous cell.

Question

Is there a keyboard shortcut in Google Docs Spreadsheets that creates the same behavior as the Excel F2 key?

share|improve this question
add comment

2 Answers

up vote 3 down vote accepted

Per the official list of keyboard shortcuts, F2 is the only key responsible for editing a cell. I've just tried it in 3 browsers (Chrome 16, Firefox 9, and IE 9) and it doesn't function the same way as it does in Excel.

Your solutions are 1) pressing F2 before entering any data, 2) pressing Backspace to remove the characters you've typed after the error, or 3) using the mouse to navigate.

share|improve this answer
    
Pressing <kbd>F2</kdb> before pressing <kbd>Enter</kbd> seems to do the trick. Thanks! –  leeand00 Jan 4 '12 at 4:39
add comment

This has been fixed in the Google Docs Spreadsheets. You may now use the F2 key to begin editing without clicking in the cell.

share|improve this answer
add comment

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.