The F2 and F4 keys in Excel

by Daljit Dhadwal

Two big productivity boosters in Excel are the F2 and F4 keys.

F2 will put Excel into the edit mode. If you need to change something you’ve already typed into a cell, just press F2 to edit the cell. If you change your mind, press Esc to get out of edit mode.

F2 Key

If the cursor is in a cell, then pressing F4 will cycle go through all the different possible versions of the address.

F4 Key