Learn a useful worksheet habit
Edit an Excel cell with F2: Escape vs Undo
Learn when to edit, cancel a draft or undo a committed change, with a small worksheet example.
Three actions, three different moments
Selecting a cell, editing its contents and undoing a change are not the same action. In Windows desktop Excel, F2 edits the selected cell. Enter accepts an edit. Escape cancels an edit that is still in progress. Once you have accepted a change, use Undo rather than expecting Escape to restore the old value.
A small, checkable exercise
Use a disposable practice worksheet. Put 12 in A1. Select A1, press F2, replace the draft with 15, then press Escape. A1 should still contain 12. Repeat the edit and press Enter: now the committed value should be 15. Use Ctrl + Z to undo that committed change, then inspect A1 again.
The important checkpoint is the value after each action, not how quickly you press the keys. If a dialog is open, Escape may close that dialog instead of cancelling a cell edit.
Inspecting a formula without replacing it
A cell can display a result while storing a formula. With a formula cell selected, F2 lets you inspect the expression. Cancel with Escape if you do not intend to change it. Typing directly into a selected cell can replace its contents; enter editing mode first when your goal is to revise what is already there.
Try it in SheetFluency
Open Free Practice below and use a disposable ordinary cell. The simulator supports F2 editing, cancellation and history, but not every Excel editing context. Check the active cell and editor before each step. A laptop may require Fn with F2. If a key never reaches the page, do not assume the exercise succeeded.
Excel reference: Microsoft’s documentation. Examples and explanations on this page are original SheetFluency practice material.