Click the Formulas tab. Click the Names Manager button.
![Click the Formulas tab. Click the Names Manager button.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Change_Name___Click_Formulas_Tab_Click_Names_Mana.PNG)
Click the name you want to change. Click Edit.
![Click the name you want to change. Click Edit.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Change_Name___Click_Name_You_Want_To_Change_Click.PNG)
Type a new name in the Name box.
![Type a new name for the reference in the Name box. Change the reference. Click OK.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Change_Name___Type_New_Name_For_Reference_In_Name.PNG)
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.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Change_Name___In_Refers_To_Area_Make_Changes_To_C.PNG)
To cancel changes, click the Cancel button or press Esc
![To cancel unwanted changes, click the Cancel button or press Esc](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Change_Name___To_Cancel_Unwanted_Changes_Click_Ca.PNG)
Or to save changes, click the OK button.
![Or to save changes, click the Commit button or press Enter.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Change_Name___Or_To_Save_Changes_Click_Commit_But.PNG)