Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2003

Daren has attended:
Excel Intermediate course

Excel

Copying formulas,

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

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.

Excel tip:

Change the Value of a Constant

When using a named constant in a worksheet, you may wish to change the value of that constant.

From the 'Insert' menu, select 'Name', then select 'Define'.

In the 'Define Name' dialog box, select the constant that you want to change.
Change the value in the 'Refers To' box.
Click OK.

Wherever that named constant has been used it will now use its new value.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.