How can a formula in a cell automatically update when inserting a.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to format a cell so that the formula connected to that cell
automatically adjusts to a line insertion?
 
No, you can put a reference within indirect and it always will point to that
particular cell

=INDIRECT("A2")

as opposed to =A2

Don't know if that's your problem though

Regards,

Peo Sjoblom
 
You must log in or register to reply here.

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

Similar Threads

Insert Row - Stop Automatic Formula Update 1
insert blank row and formulas 1
Repeating formulas when inserting new row 3
Configuration of WordPress for enabling updates eg plugins and WordPress itself.. 1
Cell =Now() << Can I get this to auto-update? 2
Automatically insert rows/copy formula 1
Formula Help 2
Excel 2007: Insert Row into Defined Area & Inherit Above Formulas 4

Back
Top