In October of 2001 , we described in this column how to use the dollar sign ($) to make an Excel formula constant—so when you copy a formula to a different location on a spreadsheet it won’t ...
Build more efficient spreadsheets by using the dollar sign to lock specific rows, columns, or permanent addresses when referencing cells.