Remove subtotals and turn off outlining before you apply Remove Duplicates. If you're new to Microsoft Excel 2007, take time to study the Remove Duplicates feature, as it did not appear in Excel 2003.

Microsoft Excel: How to Remove a Drop-Down List. Excel's drop-down menus are useful for creating order forms and navigation for larger files like records of sales.

The 2007 versions of Word, Excel, PowerPoint, and Publisher list an option to remove personal information from file properties on save (this may be grayed out), as well as a Document Inspector ...