It only works on one cell formula at a time.These notes are based on my observations while I was looking into this for one of my own projects.Highlight the specific values with your mouse or keyboard ( Shift and arrow keys) and then hit F4 as needed.If the formula has more than one cell reference and you only want to edit specific ones.Hit Ctrl + Shift + Home keys to highlight the entire formula.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.
