Rows and Columns

When you are using cell references (relative or absolute) inserting or deleting rows (or columns) will alter the cell references.
Lets image the following table where a new row needs to be inserted at the top every day.
This is not possible using normal cell references because every time you insert a new row the cell reference will automatically be linked to the cell in the previous row.

microsoft excel docs

Using the INDIRECT Function

By using the INDIRECT function we can always refer to the cell "C5".

microsoft excel docs

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext