View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default What does the $ mean in "=B$6" for example

$ indicates an absolute reference so in this case the row remains as 6 if you
copy/drag the formula into other cells but column would change.

$B6 would keep the column B constant, row will change.

$B$6 would keep both fixed

B6 is total relative so both column and row change.

HTH

"Carmon" wrote:

I know that it is referencing cell B6, but I don't know what the $ is for.