Excel

Resolved · Low Priority · Version 2003

Thu 16 Apr 2009, 11:50 Delegate 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:48 Trainer 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 courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Filtering Data in an Excel 2010 Worksheet

When 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.

You will now see arrows in the top row of all the columns. If you click on an arrow, it will give you some filtering options so you can sort your data into ''Smallest to Largest'' or ''Oldest to Newest'' and so on..

To turn off the filtering, go back to the Home tab and click the Filter button again.

View all Excel hints and tips