The $ signs lock the row/column depending on where they're placed. Have a look here for more info https://www.ablebits.com/office-addi...ference-excel/