MrExcel Publishing
Your One Stop for Excel Tips & Solutions

$ 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.