Formula changing

H

hookahbrain

is there anyway to change formulas when my cells change

we use an excell sheet to pull our products and basically we tally
items in one set of cells (i.e B2, C2) and then use baisc formulas
(=C2)to these display these number on a seperate part of the page we
print to pull inventory from

i need to add things to the sheet (changing b2 down to b5, only rows
added), is there any way to change formulas easily without rewriting
them all (i.e. adding 3 to the =b2 fromula instead of going through and
changing it to =b5) There are a few hundred formulas to change and i
don't wnat to go back & change them 1 by 1.

THanks for any help,
 
B

BekkiM

If you use Edit | Insert | Rows [or Columns] or Edit | Insert | Cells, Excel
should take care of this for you automatically.
 
H

hookahbrain

this only changes the location of the rows/cells, it does not help
formulas

If you use Edit | Insert | Rows [or Columns] or Edit | Insert | Cells,
Excel
should take care of this for you automatically.
 
B

BekkiM

Maybe you can give a more detailed example? When I tried this in my
spreadsheet, Excel automatically updated the reference from B2 to B5 when I
inserted 3 rows above B2. So if my formula (e.g., =B2+C2) was in D17 (or
even on another worksheet), when I inserted 3 rows above B2, Excel
automatically made D17 (now D20) look like =B5+C5.

So I guess I'm not understanding your question.

hookahbrain said:
this only changes the location of the rows/cells, it does not help
formulas

If you use Edit | Insert | Rows [or Columns] or Edit | Insert | Cells,
Excel
should take care of this for you automatically.

hookahbrain said:
is there anyway to change formulas when my cells change

we use an excell sheet to pull our products and basically we tally
items in one set of cells (i.e B2, C2) and then use baisc formulas
(=C2)to these display these number on a seperate part of the page we
print to pull inventory from

i need to add things to the sheet (changing b2 down to b5, only rows
added), is there any way to change formulas easily without rewriting
them all (i.e. adding 3 to the =b2 fromula instead of going through and
changing it to =b5) There are a few hundred formulas to change and i
don't wnat to go back & change them 1 by 1.

THanks for any help,
Click to expand...
Click to expand...
 
Top