Microsoft Excel

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

Resolved · Low Priority · Version Standard

Microsoft Excel

Gemma has attended:
Excel Introduction course

by - delegate Gemma [1 post] (2008 Feb 19 Tue, 16:06) Reply

How do I copy the same formula for more than one cell?

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: Microsoft Excel

by - trainer Mark gold contributer [180 posts] (2008 Feb 21 Thu, 10:02) Reply

Hello Gemma

there are a few ways to copy over formula to other cells you can simply use copy and paste in various ways either through the edit menu, the toolbar buttons or keyboard shortcuts these would be control and X to cut, control and C to copy or control and V to paste

the easiest way to copy the formulas is to use the fill handle and how to do this is as follows

using the cell you want to copy there is a black square at the bottom righthand corner of the cell when you move your cursur there it will become a small black cross, you then click and drag it either over or down

Hope this will help you

Mark East

· Take the Anxiety out of Domestic Finances with Microsoft Excel
· Identifying Suitable Candidates For VBA For Excel Training
· Microsoft Office and the Small Business: Part 1 Excel
· Microsoft Excel Training Course
· Advanced level training: Microsoft Excel and the Web

Please browse our web site to find out more about
excel computer course london and other Microsoft training courses.

Excel tip:

New Normal Worksheet

Do you want all your worksheets to confirm to a certain look? Then change the Defaults!!!
1. Press Shift+F11 to create a new worksheet
2. Press Ctrl+A to select (higlight) all cells, Press Ctrl+1, make any formatting changes then click OK.
3. Press F12 (Function 12 key) click in the Save As Type, drop down, then select Template (*.xlt)
4. Click in the Save in drop-down, then find the folder; c:_program files_microsoft office_office_start. (For the underscores shown use backslash)
Name your templete sheet.xlt, then press Enter.
Sheet.xlt is used when you insert a new worksheet (Shift+F11)

Note: These changes are permanent changes on your PC.

View all Excel hints and tips