What does the $ mean in "=B$6" for example

T

Toppers

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