The dollar sign

Hi Valerie,

Thank you for the forum question.

You lock a cell reference by using dollar sign.
A1 is a relative cell reference (no dollar sign)

$A1 is a mixed cell reference locked left to right (dollar sign before the column)

A$1 is a mixed cell reference locked up and down (dollar sign before the row)

$A$1 is a absolute cell reference locked left to right and up and down (dollar sign before the column and dollar sign before the row)

Please watch the YouTube videos below.

https://www.youtube.com/watch?v=FRu48zy-Djk

https://www.youtube.com/watch?v=8XXoHeCWzgU

https://www.youtube.com/watch?v=Yx52CYvR5ao



Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector