excel course london - Formulas

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

Resolved · Low Priority · Version Standard

Formulas

Chris has attended:
Excel Introduction course
Excel Intermediate course

by - delegate Chris [2 posts] (2007 Mar 26 Mon, 09:50) Reply

How do I copy formulas?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	1	book now	£495	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	3	book now	£475	£495
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	4	book now	£475	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	3	book now	£475	£495
2003	2008 Oct 23 Thu + 24 Fri	Southwark	4	book now	£475	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: formulas

by - trainer Tracy platinum contributer [586 posts] (2007 Mar 26 Mon, 11:33) Reply

Hi Chris,

Thanks for the question

There are a few ways to copy a formula.

1) Once in the active cell containing the formula you can go up to the Edit menu and use the copy and paste options there.
2) Again in the active cell containing the formula you can right click and a shortcut menus appears where you can copy and paste formulas.
3) If you only wanted to copy the formula relatively down one or two rows you can use the Autofill option. In this case you click in the cell containing the formula put your cursor in the bottom right corner where you cursor turns into a black plus sign then drag the formula down.

Hope this helps, any problems or other questions let me know

Tracy