In most cases when you start to work at a new company you take over the existing Excel workbooks of your predecessor and continue to update and expand on the workbook.
Normally these Excel files are quite large and contain many tabs and it’s not always clear if there is hidden information such as comments, personal information, hidden rows etc in the file.
Some hidden information can be deliberate whereas some might be unintentional.
To find all this out manually can be time consuming.
That’s where you can use the Inspect document feature.
I find it a great tool to use before distributing workbooks.
Watch the steps in this video: