98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · Low Priority · Version 2003
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.
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.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Filtering Data in an Excel 2010 WorksheetWhen you have an Excel Worksheet with masses of data, it's not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter. |
