Close the result window and check the Document Inspector window to see if there are any Properties activated. If you view thePropertiesdialog box on theSummarytab, you will see that there is no Properties attribute to this file. We hope you understand how to view the Properties box in Excel...
Method 1 – Remove Hidden Sheets by Applying the Inspect Document Function in Excel We’ve hidden some sheets in the workbook. This video cannot be played because of a technical error.(Error Code: 102006) Steps: Click theFiletab. Go toInfo,then toCheck for Issues,and selectInspect Document....
Go to theFiletab on the Excel ribbon. Navigate toInfoand clickCheck for Issues. SelectInspect Documentfrom the drop-down. Choose your preferred option regarding saving the file. In theDocument Inspectorwindow, ensure thatHidden Rows and Columnsare marked. ClickInspectto find the result of hidden ...
This feature can be found in the same place in Excel 2013 and 2016. The interface of the 2010 version looks a bit different, but the pathway to the Document Inspector is the same. If you’re using Excel 2007, you can find this option by clicking on theOfficebutton, then going toPrepar...
METHOD 1 – How to remove personal information using the Document Inspector METHOD 2 – How to remove personal information from comments using a macro (VBA) How to stop Word from changing the author of comments to "Author" Numbering of comments in Word More options for managing the display in...
If you want to learn how to do this with VBA, read a detailed guide on how to run a macro in Excel.Note: To save time, you can save this macro in the Personal Macro Workbook and add it to the quick access toolbar. This will allow you to unhide all columns with a single click....
Use Document Inspector Daten sortieren yes Erweiterte Sortierung in Excel & Google Sheets Zeilen beim Sortieren in Excel und Google Sheets Zusammenhalten Bereiche Alphabetisch Ordnen in Excel und Google Sheets Zufällige Sortierung in Excel und Google Sheets Umkehrung der Reihenfolge von Da...
3. Stick to the Font You Prefer Step 1: Click Project / Project Settings in the menu tab Step 2: Select the Formatting tab. Step 3: Check the box ‘Use different font …’, click on ‘Use Current’ and then OK. Next time you add a new document for this project, it’ll be usi...
3. Click Tools > References to enable References – Project 1 dialog, tick Microsoft Excel 16.0 Object Library and Microsoft Word 16.0 Object Library checkboxes. Click OK. 4. Then place the cursor within the VBA code, press F5 key or click Run button to run the code, now a workbook pops...
The above steps would delete all the hidden rows and columns in the workbook. Note that you need to save this workbook before running the Document Inspector option. In case the workbook is not saved already, Excel would first force you to save it. Also, it will show you a warning prompt...