|
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. |
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. |
| All times are GMT +1. The time now is 10:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com