What happened to setting up a constant using F4?

S

Stan

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

f4 to make constant 5
Conditional formatting referencing multiple cells. 2
Calculation using IF 6
Calculation using IF 1
Is there a way to set a cell value to be constant in formulas? 4
Can I use an OR function with SEARCH in conditional formatting? 3
Constant in Excel Formula 3
Nested formula using WORKDAY function 5

Top