Use range names to create meaningful Excel formulas
July 19, 2012 • Liz Todd
Understanding what formulas actually show can be a challenge particularly if you are working with an Excel workbook that someone else has created. Formulas that use range names rather that cell references are much easier to understand. For example, =Income–Expenses is much more meaningful than =D9 D25. Creating range names is really easy! Simply select the cell or cells that you want to name, click the Name Box at the left of the Formula bar, type the name (eg Sales) and tap Enter. A few pointers: you’ll find the Name Box above column A; range names can’t include spaces or...