I have a whole bunch of cells that are like:
A1 = sum(B1:Z1)
A2 = sum (B2:Z2)
...
A100 = sum (B100:Z100)
I can figure out how to change just one cell (like A1) from relative to absolute (highlighting whole formula, then going to the Formulas toolbar and switching references button - so I can get it to change to sum($B$1:$Z$1) as desired), but I can't figure out how to change all of the cells from A1 to A100 at once.
Thanks!
Using Excel for Mac 2011
A1 = sum(B1:Z1)
A2 = sum (B2:Z2)
...
A100 = sum (B100:Z100)
I can figure out how to change just one cell (like A1) from relative to absolute (highlighting whole formula, then going to the Formulas toolbar and switching references button - so I can get it to change to sum($B$1:$Z$1) as desired), but I can't figure out how to change all of the cells from A1 to A100 at once.
Thanks!
Using Excel for Mac 2011