top of page

Hot key for absolute reference

Just a very simple tip tonight, because Litigation Support Tip of the Night is exhausted and stressed out.

In Excel, if you want to automatically convert a cell reference to an absolute reference (a fixed reference that will remain the same when it's pulled down or across to other cells) press F4. Dollar signs will be added to the column letter and row number to make the reference absolute.

bottom of page