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.

編集中のExcelファイルを開いたままリネームする機能を追加「RelaxTools Addin」v4.6.0 250以上もの機能を体系化し、リボンから簡単に呼び出せるように ...

Do note that this action will remove the dashes in the entire Excel sheet. If you want to remove dashes from some particular cells, select those cells first and then use the Find and Replace feature.

To unlock grayed-out menus for an Excel file created in a previous version, convert the file format to Excel 2007.

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