Formula changing

  • Thread starter Thread starter hookahbrain
  • Start date Start date
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,
 
If you use Edit | Insert | Rows [or Columns] or Edit | Insert | Cells, Excel
should take care of this for you automatically.
 
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.
 
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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top