excel
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 2003

replyReply Thu 16 Apr 2009, 11:50Delegate Daren said...

Daren has attended:
Excel Intermediate course

Excel

Copying formulas,

How do you copy formulas to several cells in a work sheet.

For upcoming training course dates see: Pricing & availability

replyReply Thu 16 Apr 2009, 12:48Trainer Carlos said...

Copy Formulas

Hi Daren

When you enter a formula in a cell you can then copy this formula to adjacent cells. To do this:

1. Select the cell which contains the formula
2. Point to the AutoFill handle on the bottom right of the cell
3. The mouse pointer becomes a small black cross
4. Click and hold with the mouse and drag it across or down as required

The formula is copied to the selected cells

Hope this helps

Carlos

Wed 22 Apr 2009: Automatically marked as resolved.

 

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

Excel tip:

Trace Dependents / Precedents without the blue arrows

Rather than using the toolbar you can press CTRL+] which is the equivelent of trace dependants and CTRL+[ for precendants. Both of these ways though will not show the blue arrows but jump to the cell containing the formula.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard