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

Your 2020 Plan. Learn 20 minutes a day for 20 days. Online courses from €9.99.

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.

5 thoughts on “How to delete all hidden rows or columns in Microsoft Excel 2016 ?

  1. I found a workaround on the Mac (2017).
    1. Edit > Select All (or just the row range you are concerned about).
    2. Edit > Find > Go To… > Special
    3. [Tick] Visible Cells Only
    4. OK
    5. Edit > Copy
    6. Paste into a new Excel document

    The hidden cells will not be in the new document.

    Clunky but it works.

  2. Hi,
    Can we handile using in c#, I want to add hidden column in c#, when downloading excel sheet only copy the visible cells.
    How can I do the formula are logic in c#.

    Please help me out.

Leave a Reply to Gavin Cancel reply

Your email address will not be published. Required fields are marked *