« Text Formulas: Extracting First & Last Names | Main | Controls : PushButton »
September 20, 2004
Using names for cell ranges
You can define ranges as names from the Insert Menu. This makes subsequent enhancements and maintenance of the worksheet easy.
First, select the range of cells to which you wish to assign a name. Then INsert->Names->Define (below)
A dialog will appear as is shown below..
You can then use the defined names to specify a range in a table as shown in this example.
If you change the Range name, the formulas will adjust automatically.
Posted by Dave at September 20, 2004 04:57 AM