Enter a Named Cell or Range Using Formula AutoComplete : Cells Name « Formula « Microsoft Office Excel 2007 Tutorial






Name A1 cell to MyCell
Name A1 cell to MyCell
Type =My in A16 to display the Formula AutoComplete drop-down list.
Type =My in A2 to display the Formula AutoComplete drop-down list.








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