The dollar sign

Resolved · Low Priority · Version 365

Tue 11 Jul 2023, 16:00 Delegate Valerie said...

Valerie has attended:
Taking Minutes course

The dollar sign

Please give me more examples of the dollar sign

Tue 11 Jul 2023, 19:53 Trainer Jens said...

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

Tue 18 Jul 2023: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Formst Excel to display leading zeroes

Select the cells that you want to have displaying leading zeroes.

From the 'Format' menu select 'Cells' (Or Right-click on the selected range and and select 'Format Cells').

In the 'Number' tab click on 'Custom' in the 'Category' window.

In the 'Type:' box enter zeroes that correspond to the size of the required number (eg 5 zeroes).

Click OK.

When you enter numbers into these cells, leading zeroes will be displayed.

eg 123 = 00123

View all Excel hints and tips