Fixing a cell in a formula

To fix a cell in a formula, click on the cell (you want to fix) in the formula bar, and hit the F4 key.

• Hit the F4 key once to fix the cell (dragging a formula down or across will keep the row and column of the reference cell constant)



• Hit the F4 key twice to fix the row (dragging a formula down will keep the row of the reference cell constant)
  


• Hit the F4 key three times to fix the column (dragging a formula across will keep the column of the reference cell constant)