ms excel training london - Absolute cell references

Hi Kate,

There's two ways to interpret your question.

1) You can reference a cell on another sheet, which means if you update the value on Sheet 1, it is also updated automatically on Sheet 2.

To do this, use the dollar signs to ensure absolute referencing. eg. =Sheet1!$C$5
This will always reference Sheet 1's C5 cell, and if you move Sheet 1's C5 cell to somewhere else, Sheet 2 will again automatically update with the new location of the cell.

Hint: You can press F4 to cycle through the cell referencing options when in Edit Cell mode.

2) Another option you have is to paste the values from Sheet 1 into Sheet 2, meaning if you later update a Sheet 1 value, Sheet 2 will NOT be updated.

To do this, copy the cells from Sheet 1 as normal (select with mouse then Control+C or right click -> copy). Switch to Sheet 2, then RIGHT click where you want to paste and select Paste special... from the pop-up menu. Here you'll find a range of items to paste, the third one down being 'Values'.

I hope this answers your question.

Regards, Rich