Tuesday, 11 September 2012

Change a Name

Click the Formulas tab. Click the Names Manager button.
Click the Formulas tab. Click the Names Manager button.
Click the name you want to change. Click Edit.
Click the name you want to change. Click Edit.
Type a new name in the Name box.
Type a new name for the reference in the Name box. Change the reference. Click OK.
In the Refers to, make changes to the cell,
 formula, or constant represented by the name.
In the Refers to area, make changes to the cell, formula, or constant represented by the name.
To cancel changes, click the Cancel button or press Esc
To cancel unwanted changes, click the Cancel button or press Esc
Or to save changes, click the OK button.
Or to save changes, click the Commit button or press Enter.

No comments:

Post a Comment