Cloud Training (Online)




How to delete all hidden rows or columns in Microsoft Excel 2016 ?

Do you want to delete all the hidden rows or columns from your workbook in Microsoft Excel 2016?. Here’s how you can do it.

How to delete all hidden rows or columns in Microsoft Excel 2016 ?

1. Open your excel workbook in Microsoft Excel 2016 and then click File –> Info.

image

2. Click the “Check for Issues” drop-down button and select “Inspect Document”.

image

3. Ensure that the “Hidden Rows and Columns” checkbox is selected in the “Document Inspector dialog and clock the “Inspect” button.

SNAGHTMLa11f621

4. The Document Inspector dialog should display the section with the hidden rows and Columns details. Click the “Remove all” button as shown in the screenshot and then click the close button.

SNAGHTMLa139a3c

This should remove all the hidden rows and columns from the excel sheet.

Senthil Kumar B
Senthil Kumar is a former Microsoft MVP (Most Valuable Professional). He is a Co-Author of the book "Windows 10 Development Recipes using JavaScript and CSS" for Apress Publication. He is a technical presenter, blogger, mentor and a Geek.  Senthil is a regular speaker is various local user groups. He has presented at conferences like Great Indian Developer Summit (GIDS) & Microsoft DevCamps. You can reach out to him via his Twitter handle @isenthil.