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.
