Forum home » Delegate support and help forum » Microsoft Excel Training and help » Copying
|
|
|
The UK's most regular 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. |
Copying
Resolved · Low Priority · Version 2003
Reply Wed 21 May 2008, 15:43Delegate Maryann said...
Maryann has attended:
Powerpoint Introduction course
Excel Introduction course
Word Intermediate course
Powerpoint Intermediate Advanced course
Copying
When do you copy a spreadsheet on to a new page does it carry over the formular?
For upcoming training course dates see: Pricing & availability
RE: copying
Hi Maryann,
Thank you for your Excel question.
Generally, everytime when you copy & paste a cell the formula carries over to the destination. However, it is important to make sure the references are still valid on the destination sheet.
For example, if on the original sheet, there is a formula in cell C1 reading =A1+B1.
If you then copy this formula but paste it on a new sheet in cell A1. You will not get a valid answer as there are no data above it for any calculation.
Hope this helps.
Kind regards,
Katie (Microsoft Certified Trainer)
|