98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » ms excel training london - Absolute cell references
ms excel training london - Absolute cell references
Resolved · Low Priority · Version Standard
Absolute cell references
Hi, I have a column full of figures that are the result of a sum.
I can link these cells to a new worksheet etc but then if I want those figures to remain constant, how do I change the cell to reflect this?
Thanks,
Kate
RE: 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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Switching Between SpreadsheetsAs the Alt+Tab key switches between loaded applications or files, Ctrl+Tab switches between loaded or open Excel files. Hold down the Ctrl key until you have tabbed to the correct spreadsheet. |