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 Spreadsheets?

In Google 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 Spreadsheets re-instantiates the behavior where pressing the <- key moves you to the previous cell.

Question

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

share|improve this question

2 Answers 2

up vote 4 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

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

share|improve this answer

protected by jonsca Jul 31 at 16:04

Thank you for your interest in this question. Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.

Would you like to answer one of these unanswered questions instead?

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