Tag Archives: Name Manager
Excel: How to Create Simple & Dependent Drop-Down Lists
Using tables, named ranges, formulas, data validation, & table styles by JD Sartain | tech journalist | PCWorld | Jun 25, 2018 8:48 pm Drop-down lists in Microsoft Excel (and Word and Access) allow you to create a list of … Continue reading →
Posted in Reviews
|
Tagged choose a style, Data Validation, database, dependent drop-down lists, drop-down lists, Error Alerts, Format As Table, formula =INDIRECT($D$2), INDIRECT function, Input Messages, Microsoft Excel, My Table Has Headers, Name Manager, name your tables, Office 2013, Office 2016, Office 365, range names, source box, spreadsheet, submenus, Validation Criteria, Work-around for two word items, workbook
|
Comments Off