Valerie has attended:
Taking Minutes course
Excel Introduction course
The dollar sign
Please give me more examples of the dollar sign
RE: 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