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


--
John K
------------------------------------------------------------------------
John K's Profile: http://www.excelforum.com/member.php...o&userid=34726
View this thread: http://www.excelforum.com/showthread...hreadid=544910

"John K" wrote in
message ...

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?

Copy your row 1 formula, & paste it down the other rows.
--
David Biddulph

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.
--
Ken Hudson


"John K" wrote:


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


--
John K
------------------------------------------------------------------------
John K's Profile: http://www.excelforum.com/member.php...o&userid=34726
View this thread: http://www.excelforum.com/showthread...hreadid=544910

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


--
John K
------------------------------------------------------------------------
John K's Profile: http://www.excelforum.com/member.php...o&userid=34726
View this thread: http://www.excelforum.com/showthread...hreadid=544910

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


--
John K
------------------------------------------------------------------------
John K's Profile: http://www.excelforum.com/member.php...o&userid=34726
View this thread: http://www.excelforum.com/showthread...hreadid=544910