In many cases, it is important to remove metadata from Microsoft Excel spreadsheets, and that’s because it includes identifying information that may include such things as your full name, initials, ...
Protecting cells in your Microsoft Office Excel 2010 spreadsheet is a good idea because it enables other people to view the spreadsheet but prevents them from modifying your data and formulas.
Click on the heading of the column you want to evaluate for duplicates. Click and drag from one heading to the next to select more than one column. Hold down the "Ctrl" key and click to select columns ...