Luxembourgguidelines.org – How To Delete A Defined Name In Excel. Microsoft Excel is data processing software that is popularly used by various groups. Starting from students, college students, office workers and so on. This is because it is effective for completing various jobs or tasks related to data and numbers. Apart from that, Microsoft Excel is also equipped with various formulas that make it easier for users to process data. That way, users can solve various problems, starting from financial reports, data analysis, creating various kinds of graphs, and so on. Then, when entering letters into a column there is a name assigned to a cell, cell spacing, formula, table, and so on. This is used to increase convenience when these elements are defined as data in a worksheet in Excel. Then, how do you delete the name assigned to Excel? Come on, see the explanation in the article below.
How To Delete A Defined Name In Excel
The following are several ways you can delete names in Excel tables, including:
1. Method 1: Use the Formula Tab to Remove Names
The steps are as follows:
- First, open the workbook you want to delete, namely Defined Names. Go to Formula Ribbon >> Name Manager (defined section). Then, delete the name specified using the formula tab. Then, in the name manager window you can see the defined names.
- Second, select the artificial name you want to delete. Then, delete Allowance , Job_Id & Name by pressing CTRL. Then, click on several defined names that you want to delete. After that, click on the Delete button.
- Third, wait until the warning window appears and click the “Ok” button. You should definitely take a look name manager window. After that, you can see other defined names.
- Fourth, The specified name will be deleted by the Formula tab. After that, the result is that the deleted name is no longer available.
2. Method 2: Use Keyboard Shortcut to Delete Assigned Name
The steps are as follows:
- First, you can press CTRL + F3 simultaneously to open the name manager window in Excel.
- Second, press CTRL + F3 and wait until the name manager window will appear.
- Third, choose one or more artificial names. Then, Click delete the name assigned using the keyboard shortcut
- Fourth, wait for the warning dialog box to appear. Then, click ok on the warning window.
3. Method 3: Use VBA Macro to Delete All Names In Range
The steps are as follows:
- First, press ALT+F11 in Excel and wait until the Microsoft Visual Basic window opens. Then, open the menu bar and select insert >> module.
- Second, in the module, paste the VBA code to delete all the specified names. Then, press F5 to run the code.
- Third, Open the Excel worksheet, and check the name specified in the left part of the Formula Box. Next, you will see defined name being deleted.
That is the interesting explanation above that can be conveyed regarding how to delete a defined name in Excel. Hopefully after reading the discussion in this article, you can understand it well, use it as an additional reference, increase your knowledge and insight. And in the future, it can be useful and can apply this knowledge in everyday life.