Switch between relative, absolute, and mixed references

  • Thread starter Thread starter Connie
  • Start date Start date
C

Connie

In Excel 2003 I used F4 to Switch between relative, absolute, and mixed
references. Is there another shortcut to do this in 2007???
 
Hi Connie,

It is still F4.

Maybe you got the new version of Excel with a new PC, with a keyboard with
multifunction function keys?
If so, press F Lock to enable the "normal" behavior of function keys.
 
Hi,

Of course you need to be in the formula, not just on the cell. And you need
to select a complete cell reference part in the formula, so selecting cell A1
and pressing F4 will not do Absolutes. with the cursor blinking between the
S and U in the formula =SUM(A1:A1000) and pressing F4 will not work,
selecting A1:A10, (including the comma) in the following formula will not
work SUM(A1:A10,B22:B32).

remember F4 does 3 different things in Excel so where you are makes all the
difference.

If this helps, please click the Yes button

Cheers,
Shane Devenshire
 

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

Absolute and Relative Cell References 1
cell references 1
Is there an absolute reference shortcut? 2
Cell Reference Keyboard Shortcut unavailable 1
Relative, absolute & mixed references in many cells 11
Absolute References 3
Wide Selection of Absolute Reference Toggle 3
Copy formatting, Help 9

Back
Top