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. There are additional syntax rules about what’s valid and not when defining names. The rest of the name can consist of letters, numbers, periods, and underscores. You can only begin a name with a letter, an underscore (_), or a backslash (\). There are syntax rules you must abide by when choosing a name. For example, we called the selected cells on our “Product Database” worksheet “Products”. Type a name for the range of cells in the box and press “Enter”.
#Edit named ranges in excel for mac how to
You can also learn how to use the “IF” function and other useful functions.Ĭlick the mouse in the “Name Box” above the cell grid. 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 kommentar(er)
