![]() ![]() Click “OK” to finish creating the new name. If you didn’t select the cells to which you’re assigning the name, click the “Expand Dialog” button to the right of the “Refers to” edit box to select the cells the same way we did when we edited the name earlier. Then, select the name you want to delete in the list of names and click “Delete”.Įnter more details about the name, if desired, in the “Comment” box. Simply, access the “Name Manager” dialog box as we discussed in the previous section. If you decide you don’t need a name anymore, it’s easy to delete it. How to Delete a Name Using the Name Manager Click “OK” on the “Edit Name dialog box to accept the changes to the name. To accept your selection and return to the full “Edit Name” dialog box, click the “Collapse Dialog” button. The worksheet name and cell range are automatically entered into the “Refers to” edit box. We select the range of cells directly on the “Product Database” worksheet, including the row containing the newly added product. When we click on the “Expand Dialog” button, the “Edit Name” dialog box shrinks down to contain only the “Refers to” edit box. We’ll show you how to do that in a later section.Īs an example, say we added another product to our “Product Database” and we want to include it in the cell range named “Products”. If you want the scope to be a specific worksheet, rather than the entire workbook, you can create a name in a way that allows you to specify the scope initially. ![]() You must choose the scope when you first create the name. When you edit an existing name, you cannot change the “Scope” of that name. NOTE: You’ll see that the “Scope” drop-down list is grayed out. You can also change the range of cells to which this name is assigned by clicking the “Expand Dialog” button on the right side of the “Refers to” edit box. You can change the “Name” itself as well as add a “Comment” to the name, providing more details about what the name represents. For example, we’re going to edit the “Products” name. To edit an existing name, select the name in the list and click “Edit”. In the “Defined Names” section of the “Formulas” tab, click “Name Manager”. To access the Name Manager, click the “Formulas” tab. You can also use the Name Manager to create names, if you want to specify more details about the name. You can choose to limit the scope to a specific worksheet so the worksheet name has to be used when referring to the name, such as in the example at the beginning of this article.Įxcel provides a tool, called “Name Manager”, that makes it easy to find, edit, and delete the names in your workbook. That means that the name is available to be used on any worksheet in the current workbook without referencing a specific worksheet. NOTE: When creating a name using the “Name Box”, the scope of the name defaults to the workbook. Now, that we created the “Products” name to represent the range of cells on our “Products Database” worksheet, we can use that name in the formula, shown in bold below. Remember the formula from the beginning of this article? It contained a reference to the “Products Database” worksheet in the workbook and a range of cells on the that worksheet. You can also learn how to use the “IF” function and other useful functions. NOTE: For more information about the VLOOKUP function used in the formula above, see our article about using VLOOKUP in Excel. However, we could use a name for this range of cells to make the formula shorter and easier to read. In this case, the name of the worksheet gives us a good idea as to what’s contained in the range of cells, “A2:D7”. In the formula below, we reference a range of cells (in bold) from another worksheet, called “Product Database”, in the same workbook. This will make your formulas much easier to understand and maintain. Instead of referencing a cell or range of cells, you can assign a name to that cell or range and use that name in formulas. There’s an easy way to remove the confusion.Įxcel includes a feature, called “Names”, that can make your formulas more readable and less confusing. But if you have a lot of formulas, all those cell references can get confusing. When creating formulas in Excel, you can reference cells from another part of the worksheet in your formulas.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |