1. Home
  2. MS Office

Excel 2010: Find & Remove All Hidden Rows/Columns, Remove Meta Info And More

To thoroughly inspect the Excel 2010 workbook for hidden content, XML data, hidden rows/column, hidden worksheets and personnel information, click File on ribbon. It will bring up default Info backstage view. Under Check for Issues options, click Inspect Document.

891d1277290164-document-inspector-find-all-hidden-rows-columns-worksheets-other-content-

This will open Document Inspector, enable all provided options and click Inspect.

892d1277290165-document-inspector-find-all-hidden-rows-columns-worksheets-other-content-

Once done, it will provide you with all the details about any hidden content, personnel info, etc. You can also remove the content it found out, by clicking Remove All for specific information.

893d1277290167-document-inspector-find-all-hidden-rows-columns-worksheets-other-content-

Leave a comment