Thread: dollar mark
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
CM CM is offline
external usenet poster
 
Posts: 136
Default dollar mark

the dollar signs indicate an 'absolute' cell reference. - one $ for the
column and one $ for the row. If this cell is referenced elsewhere in the
spreadsheet as A1 and the formula is copied, the cell reference will change.
If it is absolute, ($A$1), the formula referening it can be copied anywhere
and the reference to A1 stays the same.
--
hope to help,
cm


"zafer ozer" wrote:

What is the difference between A1 and $A$1