$ in Excel
Posted by Dee on February 10, 2002 3:49 PM
I am very new to Excel so this may sound like a stupid question, but what does the $ in front of cells mean in a formula?
Like $C9+$D6
Posted by Aladin Akyurek on February 10, 2002 3:59 PM
In this particular case column C and D are *frozen*. When you drag it across, the formula will stay same. When you drag it down, it will change to: $C10+$D7, $C11+$D8, etc in the consecutive cells.
Posted by Mark W. on February 11, 2002 7:07 AM
Think of $ as a funny looking boat anchor. The
reference =$C9 is "anchored" on column C:C
regardless of which column it is copied to.
