#Where is the document inspector in excel how to#
Heres how to do it: Open the Excel file and press Alt F11 to open VBA Editor Go to Insert Module.
Excel Delete Entry Without Deleting The Formula How To Do It Using VBA Code This is a very convenient method if you only need to remove hidden rows and columns from one sheet instead of a whole workbook. Theres not a difference to the feature itself, so this will make sure that there are no hidden rows and columns regardless of your version of Excel. If youre using Excel 2007, you can find this option by clicking on the Office button, then going to Prepare Inspect Document. This feature can be found in the same place in Excel 20. Heres what you have to do: Open the workbook, and go to File Info. This is useful when you have to share documents with other people and want to make sure there are no surprises in the document. Its the best way to uncover and delete any hidden data that might be present in a document. Using a Third-Party Software The Final Word The Document Inspector feature is available in Excel, Word, PowerPoint, and Visio. When the module window pops up, paste the following code in it: Press F5 to run the code. Excel Delete Entry Without Deleting The Formula Code In It Using VBA Code Open the Excel file and press Alt F11 to open VBA Editor Go to Insert Module. Within the Document Inspector dialog box, make sure that Hidden Rows and Columns is selected.Ĭlick the Inspect The Document Inspector will show you a report which shows you whether there are any hidden rows and columns. Using the Inspect Document Function Quick Links Using the Inspect Document Function Open the workbook, and go to File Info.Ĭlick on the Check for Issues button, then select Inspect Document. Thankfully, Microsoft decided to add it to versions 2007 and newer.
Excel Delete Entry Without Deleting The Formula Code In It.