Adding rows to excel and keep existing formulas

**laddyboy** · 05-22-2008, 02:04 PM

Does anyone know how it insert a new row into a spreadsheet and keep all existing formulas intact/

**shg** · 05-22-2008, 03:20 PM

You can use the INDIRECT function and a literal string; for example, =INDIRECT("A1") always refers to A1, irrespective of row or column insertions or deletions.

If that seems inconvenient, it's because it's not needed that often.

**laddyboy** · 05-22-2008, 03:31 PM

I attempted to use the =INDIRECT("A1) but it did not hold the previous formulas? Perhaps I applied it wrong?

**laddyboy** · 05-23-2008, 12:58 PM

If I have a spreadsheet template in place with algorithm formulas and then insert a new row is it possible to do this and keep all formulas in place in the new row?