You've built a perfect Excel table, but the moment you try to use its headers in a drop-down menu, everything breaks. Excel's Data Validation is notoriously picky with tables, but there's a clever ...

Microsoft Excel 2010 can convert a worksheet to a data table to help you quickly analyze your related data in formatted rows and columns. When you need to expand the table layout, apply the Home tab ...