excel training uk - References

Hi Maria

You can turn a cell reference absolute by prefixing the column letter and row number with the dollar symbol $. This then acts as an anchor. When you drag a formula that contains a reference which has been locked with $ symbols the column and/or row reference remain unchanged.

I hope this is helpful.

Kind regards,

Andrew