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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know that it is referencing cell B6, but I don't know what the $ is for.
 
$ 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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproduct not working 5
Need fucntion to reference cell on worksheet referenced by known n 3
Return value from specific column if not in new column previously 1
Getting rid of '0' in a cell 3
function 1
Creating external references to spreadsheets with changing names 1
With F1 value, look at A, if match or partial match return B 5
Show in a Cell the Value for another Cell 2

Back
Top