Forum home » Delegate support and help forum » Microsoft Excel Training and help » ms excel courses - How do i use the dollar sign?

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

ms excel courses - How do i use the dollar sign?

Resolved · Low Priority · Version Standard

Reply Thu 27 Sep 2007, 10:11Delegate Esther said...

Esther has attended:
Excel Intermediate course

How do i use the dollar sign?

How do i use the dollar sign and IF formatting?

For upcoming training course dates see: Pricing & availability

Reply Tue 2 Oct 2007, 15:41Trainer Katie said...

RE: How do i use the dollar sign?

Hi Esther,

Dollar Sign $ is Absolute Reference.

If you need to reuse the same cell in different formula, you will absolute reference a cell address.

e.g. Multiplying a VAT amount onto a list of price
A1:

Excel articles

· Identifying Suitable Candidates For VBA For Excel Training
· How To Take Your Data Out Of The Shade
· Organisation At Your Fingertips - Take Control Of Your Life With Excel
· Create A Basic Timeline In Excel
· Correct In, Garbage Out

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy