By Marlo Anderson – The Tech Ranch
Need to tweak a formula? Don’t double-click it or retype it. Press F2 and the cursor jumps to the end of what’s in the cell.
The Shortcut
- F2: edit the current cell
- Press Enter when done
- Works in Excel and Google Sheets
- Some laptops: Fn + F2
Bonus Tip: F4 Locks a Reference
While typing a formula, put the cursor on a cell reference and press F4. Excel adds $ signs ($E$2) so the reference stays put when you copy the formula. Press F4 again to cycle the options.
More Keyboard Shortcuts, Explained
This is part of my Keyboard Shortcuts Explained series: quick, plain-English tips that make everyday computer work faster. Watch the whole series on YouTube and subscribe to The Tech Ranch so you don’t miss the next one. Short on time? Here’s the quick Short version.
Found this helpful? Give the video a thumbs up on YouTube. Got a shortcut you can’t live without? Tell me in the YouTube comments and it might show up in a future video.
