Microsoft Excel's Data Validation tool lets you add a drop-down list to a cell based on existing data in a column. However, how this works depends on whether the source data is part of a formatted ...

You can use Excel, Microsoft's spreadsheet program, to store, organize, and analyze data in a number of ways.

I've written many times about the many benefits of formatting your data as a structured table in Microsoft Excel. However, despite this, there's one major issue that continues to throw a spanner in ...