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”. 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.
