You can use your mouse to highlight the entire formula or you can use the following keyboard shortcuts.If the formula has more than one cell reference and you want to change them all.If the forumla has more than one cell reference, hitting F4 (without highlighting anything) will toggle the last cell reference in the formula.Hit F4 as needed and the single cell reference will toggle.(Issue with F2 ? Double check that 'F Lock' is on) You can also perform these next steps directly in theįormula bar. In Excel, select a cell with a formula and hit F2 to enter formulaĮdit mode. Pressing F4 again converts '$A4' back to the original 'A4'.Pressing F4 again converts 'A$4' into '$A4'.Pressing F4 again converts '$A$4' into 'A$4'.Pressing F4 will convert 'A4' into '$A$4'.F2 - With a cell selected, it places the cell in formula edit mode.į4 - Toggles the cell reference lock (the $ signs).In Excel 2013 and resent versions, you can use F2 and F4 to speed things up when you want to toggle the lock.
