Article ID: 214143 - View products that this article applies to.
This article was previously published under Q214143
This step-by-step article shows you how to use the INDIRECT function to continually reference the same cell in a formula in Microsoft Excel 2000.
=INDIRECT("$A$1")To use the INDIRECT worksheet function, follow these steps:
Absolute referencing in Excel references the same cell or cells as long as no cells are added or deleted in the column above the cell or cells that you are referencing. This means that when you insert or delete a row or column so that the cell that you are referencing is moved, the formula references the new cell location.
For example, if you type the value 10 in cell A1 and refer to it in cell B1 with the formula
=$A$1the value 10 appears in cell B1. If you then insert a row over cell A1 so that the value 10 is moved to cell A2, the formula in cell B1 changes to the following:
For more information about the INDIRECT worksheet function, click Microsoft Excel Help on the Help menu, type indirect in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Article ID: 214143 - Last Review: January 24, 2007 - Revision: 4.2