Deleting

Deleting Rows

Deleting Columns

Can you get a #REF when you delete cells referenced in formulas or do the references change automatically ??

Important

It is possible to delete just a range of cells instead of a whole column or row. For more details please refer to the Deleting Data page in the Cells & Ranges section.