Sunday, April 10, 2011

Excel Mac: Cell Reference Lock - F4 Alternative

One of the first major problem that I faced when I first began using Excel on a Mac, was the appropriate shortcut replacement for F4, which adds $ signs to cell references to lock cell/range references from moving if dragged to another cell. After a great deal of frustration, and after trawling a number of excel forums I eventually found the solution which is shown below.

Windows ShortcutF4

Mac Shortcut : Cmd + T