![where is the document inspector in excel 2016 where is the document inspector in excel 2016](https://www.officetooltips.com/images/tips/449_2016/3.png)
![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_protect_final.png)
We might want to find out those employees working in the Sales department with a B+ blood group. Let’s assume a scenario where we have a more complex filter to perform on our employee information. Delete Hidden Filtered Rows Using the Inspect Document Feature
WHERE IS THE DOCUMENT INSPECTOR IN EXCEL 2016 CODE
After that enter the following code into the Module.Click Developer → Visual Basic, a new Microsoft Visual Basic for Applications window will be displayed.At first, select all the rows you need to filter ( including the column headers).Then you can also use the VBA to get the above task done more quickly. If you are familiar with VBA code or feel comfortable working with VBA. You can simply click on the Filter button from the Data Tab, to see the rest of the data.But don’t worry!! It will not affect the other rows that are currently hidden. It will delete the current rows containing the information about the employees working in the Sales department that we have filtered.A warning pop-up box will appear and will ask if you want to delete the entire row.Click on Delete Row from the pop-up menu.Select all the filtered rows in view and right-click with your mouse.Upon clicking OK, you will now see the information of those employees working in the Sales.You can just untick the Select All box to uncheck every type of department quickly and then select or check only the box next to the Sales.Uncheck all the boxes next to every type of Department except for the Sales.A window will pop up that will let you filter the Department column according to your choice. For this example, we want to only filter out those rows containing the information about the employees working in the Sales. So, select the drop-down arrow in the down-right corner of the Department Header.Click on an arrow to apply Filter on that respective column. These small arrows will let you apply Filter on the respective column.
![where is the document inspector in excel 2016 where is the document inspector in excel 2016](https://developerpublish.com/wp-content/uploads/2016/10/SNAGHTMLa11f621_thumb.png)
You will see a small downward arrow in the down-right corner of each header column.Click on the Filter button under the ‘ Sort and Filter ’ section under the Data tab.First, we will select the whole data range of our worksheet.Now, we will filter the data and delete both the visible and hidden rows using 5 different methods. We have the name of the employees, the department they are working in, their blood group, and their joining date. Let’s assume a scenario where we have information about employees of a company. Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.5 Suitable Methods to Delete Filtered Rows in Excel 'Obtain the Word.Document for the Inspector Set myItem = Application.CreateItem(olMailItem) 'You must add a reference to the Microsoft Word Object Library Since this example accesses the Word object model, you must first add a reference to the Microsoft Word Object Library to compile the example successfully. Using the Word.Document object, the function accesses the Word.Range object and inserts text into the body of the item. The function uses the item's GetInspector property to get the existing Inspector object, and then uses the Inspector.WordEditor property to obtain a Word.Document object for the item.
![where is the document inspector in excel 2016 where is the document inspector in excel 2016](https://apprize.best/microsoft/excel_11/excel_11.files/image077.jpg)
To insert text in a Word editor as the body of the mail item, the function uses the Document object and Range object in the Word object model. It then calls the Display method to open the mail item in an inspector. The function sets the Subject property to assign the title "Testing.". This Visual Basic for Applications (VBA) example shows a function InsertBodyTextInWordEditor that creates a mail item, assigns it a title and adds text for the body. If an Inspector object already exists for the item, the GetInspector property will return that Inspector object instead of creating a new one. This property is useful for returning an Inspector object in which to display the item, as opposed to using the Application.ActiveInspector method and setting the Inspector.CurrentItem property. SyntaxĮxpression A variable that represents a MailItem object. Returns an Inspector object that represents an inspector initialized to contain the specified item.