absolute reference shortcut mac excel 2013

The second method is to use the F4 hotkey as the shortcut to lock up a cell. The first method is about assigning the Dollar Sign ($) manually before the column and the row number. In this blog post, two methods to lock a cell in an Excel formula have been discussed with examples. Use the F4 hotkey to lock a cell instantly.Assign Dollar Sign ($) before the row and the column number to lock a cell.Read More: Difference Between Absolute and Relative Reference in Excel Things to Remember

Press the F4 key again to lock the column number from the row number.Ĭ.

Toggle from Absolute to Relative Cell Reference

Select the Cell Reference in the Formula Bar.ī.Toggle from Relative to Absolute Cell Referenceįor example, you are working currently with the Relative Cell Reference and want to switch to the Absolute Cell Reference. You can easily toggle in between Relative, Absolute, and Mixed Cell References by pressing the F4 hotkey. Read More: F4 Not Working in Absolute Cell Reference in Excel (3 Solutions) Additional Tips

Absolute reference shortcut mac excel 2013