Is there any way that when I delete or add a row the formulas automatically updated.
migrated from stackoverflow.com Apr 19 '11 at 11:13
This question came from our site for professional and enthusiast programmers.
|
Take a look at lists (XL 2003) or tables (XL 2007 & 2010). These add the type of functionality you're talking about and may work for you. Also, you could add a named range to your worksheet with a relative reference that refers to the cell directly above. You could modify the example on this page under the heading "Using relative references." | |||
|
feedback
|
2*A2in cell A1 and insert a row in between then cell A1 will read2*A3, i.e. formulas are updated automatically. What else do you want? – Howard Apr 19 '11 at 5:45