F4 key as an "absolute" function key in excel

Try: fn + cmd then F4

command+T

⌘+T

Is the mac equivalent of F4 in excel 2011 and will toggle the formula reference style between absolute, relative, and mixed

In Excel for Windows, when you're in edit mode within a cell, the F4 key toggles your cell references between Absolute and Relative mode. In Excel for Mac in Edit mode, the F4 key does nothing. The OP wants to know how to access that Abs/Rel toggle functionv (as did I).

Fortunately maxtopdog provides the answer below, on Aug 9 2011 (command+T).

If you're looking for a keyboard shortcut to toggle between absolute and relative references in Numbers 3, you can click the range token in a formula and hit command-k and shift-command-k.

In Excel on the Mac, as maxtopdog posted, the equivalent is command-t.

SG

To add to SGs comment:

the repeatedly type the key combination <command> + <shift> + k to cycle through:

- Absolute column

- Absolute row

- absolute row and column

- relative

(I think it's quicker just to type the "$" myself)

(I think it's quicker just to type the "$" myself)

Me too. Or, if the formula editor defeats my intent as I type, click the triangle and check the Preserve Row and/or Preserve Column boxes.

SG

You can also select the reference, then use the key combination

<command> + <shift> + k

to cycle through the combinations of absolute and relative references

<command> + t opens the font dialog.

Do exactly what you would in PC Excel using F4 which is to:

1) first highlight the target cell

2) instead of F4 use command+T (which will toggle through all options: abs colume only, abs row only, abs col & row)

It's quite simple and it works for Excel 2011