Excel edit problem, (of my own making!!)

J

John K

Hi I am new to this forum.
Can you help me with a problem.
I was given an inventory in a spreadsheet. My experience with Excel is
limited, but I am a quick learner.
Here is my problem.
I have a column that should have formulas as follows:
=SUM(A1:F1)
the two cells are always supposed to be on the same row.
Somehow in the middle of the column I find this happenning:
=SUM(A234:f236)
the rest of the column formulas are offset by two row values.
Is there any easy way to edit this enite spreadsheet without having to
actually edit each individual cell?
Thank You,
John
 
D

David Biddulph

John K said:
Hi I am new to this forum.
Can you help me with a problem.
I was given an inventory in a spreadsheet. My experience with Excel is
limited, but I am a quick learner.
Here is my problem.
I have a column that should have formulas as follows:
=SUM(A1:F1)
the two cells are always supposed to be on the same row.
Somehow in the middle of the column I find this happenning:
=SUM(A234:f236)
the rest of the column formulas are offset by two row values.
Is there any easy way to edit this enite spreadsheet without having to
actually edit each individual cell?
Click to expand...

Copy your row 1 formula, & paste it down the other rows.
 
K

Ken Hudson

Hi John,
If your formula needs to be in column G, insert a new column G.
In G1 enter your formula, =SUM(A1:F1)
Highlight cell G1.
Place the cursor in the lower right corner of the cell. When it changes to a
plus (+), double click the left mouse buttton and the formula will copy down
automatically.
 
J

John K

By doing that will it correct the values and make the row numbers the
same value?
John
 
J

John K

Thanks Ken, It worked like a charm. I thought i was going to have t
edit cell by cell, over 1500 of them. This short cut sure was easy!!
Joh
 
Top