Copying

Hi Kerry,

I hope you have enjoyed your training. Thank you for your question.

Formula structures can be copied across to a different worksheet and files. But it is important to ensure the references are still valid on the destination worksheet.

For example, a formula in cell C1 reading =A1+B1 cannot be copied then pasted on cell A1 of a different worksheet. You will not get a valid answer as there are no cells to the left for any calculation.

Hope you find this useful.

Kind regards,

Katie (Microsoft Certified Trainer)