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?
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)
