Spreadsheet Tips

Toggle Absolute References in Excel with F4

May 31, 2018
Demo of pressing F4 to cycle through variations of absolute references

To quickly toggle absolute references in Excel, ensure your cursor is standing in a reference, and hit F4 on your keyboard (you may need to hold the fn key, if you're using a Mac keyboard).

By hitting F4 repeatedly, you can cycle through variations of absolute references (for example: references ones that only lock the column or the row value).