| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copy an Drag cell Formula Problem
I am suddenly experiencing a problem when I try to copy and drag a formula
across a number of cells. For example, I have two different data series in columns A and B and I want the product of the two in column C. Thus, in cell C1 I put =A1*B1. I then highlight C1 and drag the formula down the C column. My expected result would be =A2*B2 in C2, =A3*B3 in C3, etc. But what is happening is that the results for A1*B1 is appearing in every cell of column C. However, when I highlight C4, for example, the formula appears as =A4*B4 but the product is the same as that found in C1 (=A1*B1). I have reinstalled MSOffice and rebooted, but the problem persists. I have tested to see whether other Excel files encounter the same problem they do. Any suggestions would be greatly appreciated. I have MSOffice 2003. Thank you. |
|
#2
|
|||
|
|||
|
Tools/Options/Calculation, select Automatic.
In article , Nat wrote: I am suddenly experiencing a problem when I try to copy and drag a formula across a number of cells. For example, I have two different data series in columns A and B and I want the product of the two in column C. Thus, in cell C1 I put =A1*B1. I then highlight C1 and drag the formula down the C column. My expected result would be =A2*B2 in C2, =A3*B3 in C3, etc. But what is happening is that the results for A1*B1 is appearing in every cell of column C. However, when I highlight C4, for example, the formula appears as =A4*B4 but the product is the same as that found in C1 (=A1*B1). I have reinstalled MSOffice and rebooted, but the problem persists. I have tested to see whether other Excel files encounter the same problem they do. Any suggestions would be greatly appreciated. I have MSOffice 2003. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Copy cell formula help | Excel Discussion (Misc queries) | |||
| When I copy down into the next cell the formula changes correctly. | Excel Discussion (Misc queries) | |||
| Copy Formula But Keep 1 Common Cell | Excel Discussion (Misc queries) | |||
| Copy formula to every 12th cell | Excel Worksheet Functions | |||
Linear Mode
