Question

what are the steps to deletes a range name?​

Answer 1

$\huge\underline\bold\blue{Question}$

what are the steps to deletes a range name?

$\huge\underline\bold\red{AnswER}$

We need to follow the below steps to delete name range:

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 Delete

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

6. Select the Name Range “Months”

7. Click Delete

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

This will delete the Named Range from the Excel Workbook.

_______________________________

Hope it helps you :)

Answer 2

Answer:

Open Microsoft Excel, then click "File" and open the document containing the named range you want to delete.

Click the "Formulas" tab and click "Name Manager" in the Defined Names group. ...

Click the name you want to delete. ...

Click "Delete," then confirm the deletion by clicking "OK."