How to change absolute addressing to relative addressing
JBeaucaire
Mar 5, 2010, 11:14 AM
You use the $ symbols to make portions of a reference absolute.
A1 - column relative, row relative
$A1 - column absolute, row relative
A$1 - column relative, row absolute
$A$1 - column absolute, row absolute