Formula in Excel 365 2013 2010 2007 2003

Shortcut key to switch between relative, absolute and mixed references

You can enter nonrelative references (absolute or mixed) manually by inserting dollar signs in the appropriate positions, or you can use a handy shortcut - F4 key.

How to see formulas on the spreadsheet

Sometimes it is handy to view (and print) the formulas in all the cells in a spreadsheet without having to manually enter each cell.