![where is the document inspector in excel 2016 where is the document inspector in excel 2016](https://media.gcflearnfree.org/content/5644bbafca7fae0d9c67697d_11_12_2015/inspecting_inspector_warning.png)
The Document Inspector in Word, Excel, and PowerPoint includes the following enhancements. We recommend that you run the Document Inspector before you sign a document or invoke IRM on a document.Īs a developer, you can use the Document Inspector framework to extend the built-in modules and integrate your extensions into the standard user interface. With just a little data cleansing work to you can avoid having additional unwanted objects in your document, resulting in faster performance and smaller file size.Microsoft does not support the automatic removal of hidden information for signed or protected documents, or for documents that use Information Rights Management (IRM). You can also choose to be more selective about the objects you delete if you have other objects already on your sheet you wish to keep, ctrl+clicking the objects in either the selection pane or on the sheet will remove them from the current selection prior to hitting delete. You can see that in addition to the previously visible objects I now also have selected some textboxes previously hidden on my sheet.Īt this point you can simply hit the Delete key and remove all of these objects from the sheet. The objects will then be selected and their selection handles are visible on the sheet. To select all objects in the sheet: Ctrl+G to open the Go To dialog > select the Special button > select Object > click OK. You now are ready to select objects using the Go To Special dialog. (Note: If you do not have the Developer Tab visible in the Ribbon you can enable it with the following steps: Office Button > Excel Options > check the âShow Developer tab in the Ribbonâ checkbox on the default Popular tab). If this button is disabled in the Ribbon then your sheet does not contain the types of controls that require this step. To enter Design Mode select the Design Mode button in the Controls Chunk on the Developer Tab. Turning on Design Mode will allow you to select all controls, not just the basic shapes and form controls. Design Mode will only be enabled in Excel if your sheet contains certain types of controls.
![where is the document inspector in excel 2016 where is the document inspector in excel 2016](https://4.bp.blogspot.com/_bI8PMlszME0/TOqMO4i2-GI/AAAAAAAACAU/VBULN_Ijyxw/s1600/document+inspector2.png)
Once you have the selection pane open and verified that you have objects on the sheet, the next step is to put your spreadsheet in Design Mode if it is supported on your current workbook. I have seen customer files with thousands of hidden objects. Notice that 100 objects were pasted into my document. The top of the Selection and Visibility Pane for my sheet. If the selection pane is blank then you do not have extra objects on the sheet. Looking at the selection pane you will see a list of all objects on the current sheet and an indication if the objects are visible or hidden. The easiest way to view a sheetâs objects is to turn on the on the Selection Pane (on the Home Tab go to the Editing Chunk > click the Find and Select Dropdown > select the Selection Pane option making the pane visible). The first thing you want to do is verify that you have additional objects on your spreadsheet.
![where is the document inspector in excel 2016 where is the document inspector in excel 2016](https://cdn.ablebits.com/_img-blog/excel-document-properties/display-excel-options.png)
The following steps will help you find and delete all of the additional objects in your Excel 2007 worksheet.
![where is the document inspector in excel 2016 where is the document inspector in excel 2016](https://www.maketecheasier.com/assets/uploads/2018/02/differences-microsoft-office-mac-windows-hero.jpg)
I could select these visible objects and delete them, however, I would end up missing some of the objects that have been pasted into my sheet. Looking at this image it is evident that some additional shapes were copied into Excel an icon is shown in cell A1 and there are checkboxes in many of the rows in column B. The data set had 35 rows of data, but only the first few are shown.Īfter pasting my data (and extra objects) into Excel. One step customers can take to avoid unwanted, hidden, and invisible objects in their document is to find and remove the objects after the paste operation as part of their data cleansing process.īelow is an image of part of a data set I copied and pasted into Excel 2007 from a website. These objects (shapes, text boxes, controls, etc.) are often not noticeable to the user after the paste, but can result in slower performance and larger file sizes. Customers often copy and paste this data into Excel from the original source, but unfortunately this can also unintentionally paste many additional objects into the spreadsheet besides the data. When gathering data in Excel it is common to start with information found in a variety of sources, frequently lists or tables located on the Internet. Recently I have noticed a common problem in some of these files that impacts the fileâs performance and size: hidden and invisible objects. I often receive files demonstrating issues customers are experiencing with Excel. Todayâs author, Ben Rampson, a Program Manager on the Excel team, talks about cleaning up spreadsheets.