Locking a cell in a formula

[Marriners]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I am a recent convert to Mac so I am getting used to the way Excel works in Mac. In the old (PC) days if I wanted to lock a cell, say for example A2 I would put the $ sign in from of both the column and row number as follows $A$2. This still works in the Mac world as I can see but the shortcut in the PC world for doing this was to higlight A2 in the formula bar and then press F4 which would put the $ signs in for you, far less tedious than typing them each time and moving the mouse to precisely the right location.

Question: Is there a similar shortcut in Excel for Mac?

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I am a recent convert to Mac so I am getting used to the way Excel works in
Mac. In the old (PC) days if I wanted to lock a cell, say for example A2 I
would put the $ sign in from of both the column and row number as follows
$A$2. This still works in the Mac world as I can see but the shortcut in the
PC world for doing this was to higlight A2 in the formula bar and then press
F4 which would put the $ signs in for you, far less tedious than typing them
each time and moving the mouse to precisely the right location.

Question: Is there a similar shortcut in Excel for Mac?

Apple T

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I am a recent convert to Mac so I am getting used to the way Excel works in
Mac. In the old (PC) days if I wanted to lock a cell, say for example A2 I
would put the $ sign in from of both the column and row number as follows
$A$2. This still works in the Mac world as I can see but the shortcut in the
PC world for doing this was to higlight A2 in the formula bar and then press
F4 which would put the $ signs in for you, far less tedious than typing them
each time and moving the mouse to precisely the right location.

Question: Is there a similar shortcut in Excel for Mac?

From XL Help ("Excel keyboard shortcuts"):

Toggle the formula reference style between CMD+T
absolute, relative, and mixed

 

[Marriners]

Fantastic. Thanks guys.