Switch between relative, absolute, and mixed references

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???
 
N

Niek Otten

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.
 
S

Shane Devenshire

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

Changing relative references 1
Absolute References 3
Copy formatting, Help 9
Absolute and Relative Cell References 1
cell references 1
Range of cells: Convert relative reference into absolute 5
relative defined name references? 1
Wide Selection of Absolute Reference Toggle 3

Top