S Stan Apr 17, 2010 #1 I used to be able to merely use F4 in a formula to keep a cell constant. Now it seems it doesn't work. What did they change it to?
I used to be able to merely use F4 in a formula to keep a cell constant. Now it seems it doesn't work. What did they change it to?
Z Ziggy Apr 18, 2010 #2 Still the same, including in Excel 2007. If you are in edit mode in a formula, F4 will toggle between =A2 =$A$2 =A$2 and =$A2 -- David Biddulph - Show quoted text - Click to expand... Your Keyboard may have an "F Lock" button that needs to be toggled if F4 doesn't work.
Still the same, including in Excel 2007. If you are in edit mode in a formula, F4 will toggle between =A2 =$A$2 =A$2 and =$A2 -- David Biddulph - Show quoted text - Click to expand... Your Keyboard may have an "F Lock" button that needs to be toggled if F4 doesn't work.
