Maria has attended:
Excel Introduction course
Access Intermediate course
References
How do you make a reference absolute?
RE: 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