When you start using data tables in excel many users are frustrated to discover that the normal methods for freezing the row or column references don. Moving the pointer to cells for which the locked check box is selected on the protection tab of the format cells dialog box.
Keyboard shortcut to lock cells in excel mac office while using a macbook for a period of time in 2013 i realised that there are some differences when using mac office and windows office.įinally some excel shortcuts are just plain different on a mac. Locking cells in an excel spreadsheet can prevent any changes from being made to the data or formulas that reside in those particular cells. Press the keyboard combination fnf4 key or just f4 key if youve setup the mac function keys.įor locking the cell reference of a single formula cell the f4 key can help you easily. Then the selected cell reference is locked. Select the tools menu and click customize keyboard.Ĭells that are locked and protected can be unlocked at any time by the. Select the formula cell click on one of the cell reference in the formula bar and press the f4 key. Moving the pointer to cells for which the locked check box is cleared on the protection tab of the format cells dialog box.
