$?

B

Bob Phillips

This is absolute v relative referencing.

If you put =$A1 in B1, and copy across to J1, every cell will contain =$A1.

If you put =A1 in B1, and copy across to J1, each cell will be referencing a
different cell, Excel updates each.

This is very useful when copying formula, to ensure each target cell gets
the correct formula.
 

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

Providing only read/view permission of the email account to the user. (like Senior wants PS to only view his emails and not to respond or do action) 0
Forum Software Upgrade 0
Excel - Wich Function should I use? 1
Summing Values/Outputs of IF formulae 10
Citation 3
physical percentage formula 1
Month Calculation 5
Date Reminder 2

Top