Relative/absolute cell references

  • Thread starter Thread starter Jan Kronsell
  • Start date Start date
J

Jan Kronsell

I have a formula, like for instance = A1*A3

I like to copy this, relatively, that is updating it to =A2*A4 and so on.

The data is supposed to be in A1, A3 or A2, A4, but if the user moves the
data from A1 to B1 the fomula is updated to =B1*A3.

Is there someway I can prevent that? So no matter where the user moves the
data, the formula will remain unchanged?

Jan
 
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

Data Validation and drop-down list using IF, AND and what else? 8
Not so simpel copying of a simple formula 5
Very strange behaviour of VLOOKUP in Excel 2010 4
if the numbers in sequence 11
Blank Cells 3
Data tables ? Circular references ? 1
sum working hours each month (sum hours in the last row for a monthin a table with dates) 3
Excel =SUM(A1=A1+B1) 0

Back
Top