Create and Delete List Range (Dropdown-LOV) in Microsoft Excel Sheet

Create and Delete List Range (Dropdown) or (List Of Values) in Microsoft Excel Sheet

Microsoft Excel :: if you want to Create/Delete named range, it is a simple to use. 

First, We will create a Name Range & then will try to remove the same.

Add a Name Range:

1. Type Fruits from Cell A1 to A4

2. Select all the Fruits / data

3. In the Name Box type Fruits

4. This will give the name “Fruits” to this Range

We need to follow the below steps to Create/Delete name range:

Use the Name Manager dialog box to work with all the defined names and table names in a workbook. For example, you may want to find names with errors, confirm the value and reference of a name, view or edit descriptive comments, or determine the scope. You can also sort and filter the list of names, and easily add, change, or delete names from one location.

To open the Name Manager dialog box, on the Formulas tab, in the Defined Names group, click Name Manager.

1. Click on the Formulas Tab

2. Click on Name Manager.

3. The shortcut Key is CTRL+F3 on your keyboard.

4. Select the Name Range which you want to Create/Delete

5. Here we have already created the Named Range as “Fruits”

6. Select the Name Range “Fruits”

7. Click Edit/Delete

8. Click on Close to close the Name Manager dialogue box

This will Edit/Delete the Named Range in Excel Workbook.