Microsoft Office Tips, Tricks and Shortcuts

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