98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Copying
Copying
Resolved · Low Priority · Version 2003
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?
Wed 21 May 2008, 16:01Trainer Katie said...
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)
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:Create a unique items table from a duplicating table1. Ensure that your list has column headings |
