Copying

The UK's most regular instructor-led training courses.
Training information: microsoft-excel-training · Microsoft+excel+training · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

Copying

Kerry has attended:
Excel Introduction course

by - delegate Kerry [2 posts] (2008 May 21 Wed, 15:43) Reply

when you copy a spreadsheet on to a new page does it carry over the formulas

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 3 Wed	Bloomsbury	3	book now	£224	£235
2003	2008 Sep 5 Fri	Bayswater	4	book now	£195	£205
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	6	book now	£214	£230
2003	2008 Sep 17 Wed	Southwark	7	book now	£203	£230
Full Schedule: See all 126 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: copying formula

by - trainer Katie gold contributer [208 posts] (2008 May 21 Wed, 16:07) Reply

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)

· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· Microsoft Excel Training - Numerical excellence for all
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Basic Excel Training
· Compare Different MS Excel Training Methods

Please browse our web site to find out more about
microsoft-excel-training and other Microsoft training courses.

Excel tip:

Use the SUBTOTAL function in Excel

You can create subtotals in your spreadsheet using the SUBTOTAL function, which looks like this:

=SUBTOTAL(9,cell:cell)

9 represents the function being used (SUM), followed by the range of cells the function is operating on.

The neat thing about using the Subtotal function is that if you have used it several times in the same column or row, clicking on the AutoSum button at the end of the column or row will make Excel add only the results of cells containing the Subtotal function in that column or row.

View all Excel hints and tips