It makes the row, column or the complete cell absolute. This means when you
use the fill handle to duplicate formulas the part or all the cell reference
does not change. ie =$A1 in a cell and fill it down it changes to =$a2, =$A3
etc, but a fill it across the sheet and the 'A' does not change so all you
get is =$A1. To make the cell completly absolute then use $a$1

hope this helps
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"cj" wrote:

What does a $ in a cell do?

Example ($A1)