Delete a name range : Cells Name « Formula « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Formula
  3. Cells Name
Click the Formulas tab. 
           Click the Name Manager button.
Click the Formulas tab. Click the Name Manager button.
Select the names you want to delete. 
           Click Delete or press Delete.
Select the names you want to delete. Click Delete or press Delete.
Click OK to confirm, and then click Close.
Click OK to confirm, and then click Close.

If you change the name of a reference label, Excel automatically makes the same change to every formula in which the name is used.









6.4.Cells Name
6.4.1.Name a Cell or Range Using the Name BoxName a Cell or Range Using the Name Box
6.4.2.Let Excel Name a Cell or RangeLet Excel Name a Cell or Range
6.4.3.Name a Cell or Range Using the New Name Dialog BoxName a Cell or Range Using the New Name Dialog Box
6.4.4.Enter a Named Cell or Range Using the Name BoxEnter a Named Cell or Range Using the Name Box
6.4.5.Enter a Named Cell or Range Using Formula AutoCompleteEnter a Named Cell or Range Using Formula AutoComplete
6.4.6.Enter a Named Cell or Range from the Use in Formula CommandEnter a Named Cell or Range from the Use in Formula Command
6.4.7.Apply a Name to a Cell or Range AddressApply a Name to a Cell or Range Address
6.4.8.Organize and View Names: Edit, DeleteOrganize and View Names: Edit, Delete
6.4.9.Name Manager Filter OptionsName Manager Filter Options
6.4.10.Change a NameChange a Name
6.4.11.Delete a name rangeDelete a name range