Use Dynamic Range Names in Excel for Flexible Dropdowns

by File in: Office Tips

Excel spreadsheets often include cell dropdowns to simplify and/or standardize data entry.  These dropdowns are created using the data validation feature to specify a list of allowable entries. To set up a simple dropdown list, select the cell where data will be entered, then click Data Validation (on the Data tab), select Data Validation, choose […]

Why You Should Be Using Named Ranges in Excel

by File in: Office Tips

Named ranges are a useful, but often underutilized, feature of Microsoft Excel.  Named ranges can make formulas easier to understand (and debug), simplify the creation of complicated spreadsheets, and simplify your macros. A named range is just a range (either a single cell, or a range of cells) to which you assign a name.  You […]