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

Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

I have a work sheet, it has 10,000 rows.<BR><BR>2,000 of those are for the state of New York.<BR><BR>So I add a filter, then drop down on the state column and select New York.<BR><BR>I then have 2,000 ...