Forum Discussion
EXCEL: Delete a row without lose references
Hi,
i would like to know how delete a row without loose the references about this row.
I give you an example, if i have a formula with some cell of row 64, and i want delete it, i would like that excel understand to update the reference with the new row below.
Thank you so much
You can use the INDIRECT function for this:
=INDIRECT("E64")
will always refer to cell E64, even if you delete row 64, or insert or delete rows above it.
8 Replies
You can use the INDIRECT function for this:
=INDIRECT("E64")
will always refer to cell E64, even if you delete row 64, or insert or delete rows above it.
- Ok thank you, I've already created the formulas, it's possible to add the function INDIRECT massively?
What do your formulas currently look like? Simply =cell_reference or more complicated?
And which cell references should be changed? Only those that refer to row 64, or all references, or something in between?
