What does a $ in a cell do?

Example ($A1)

Go to help and type in absolute

then look for cell references


--
Regards,

Peo Sjoblom



"cj" wrote in message
...
What does a $ in a cell do?

Example ($A1)

http://www.cpearson.com/excel/relative.htm

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"cj" wrote in message
...
What does a $ in a cell do?

Example ($A1)

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)

Hi,

$ in a cell refers to Absolute reference and not relative reference. The
pointer to the cell value remains constant.

For example: It is like Pointer to an address in arrays in C programming. In
relative refernce the value will change based on the changing reference.

Note: You can use also use named definition as pointer to address. The named
definition will be store the absolute address of the cell or range of cells
as reference.

Challa Prabhu

"cj" wrote:

What does a $ in a cell do?

Example ($A1)