How to Delete Hidden Rows or Columns in Excel ?

Do you want to delete all the hidden rows in excel or even remove hidden columns in Excel ?. This post will explain in simple steps how you can do that. So, without wasting much time , lets get started.

How to Delete Hidden Rows or Columns in Excel ?

Follow the below steps to remove hidden rows or columns in your excel worksheet.

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

How to Delete Hidden Rows or Columns in Excel ?

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

How to Delete Hidden Rows or Columns in Excel ?

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

How to Delete Hidden Rows or Columns in Excel ?

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.

How to Delete Hidden Rows or Columns in Excel ?

This should remove all the hidden rows and columns from the excel sheet in your Excel workbook.

    6 Comments

  1. Gavin
    November 13, 2017
    Reply

    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. jonathan warne
    November 28, 2019
    Reply

    Brilliant thanks!

  3. G
    August 7, 2019
    Reply

    Excel crashes every time I try this

  4. Husker
    August 27, 2019
    Reply

    Is there a quick way to delete 160K hidden lines?

  5. laxman M
    January 20, 2020
    Reply

    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.

  6. User Avatar
    Sandhya
    April 15, 2023
    Reply

    Learning How to Delete Hidden Rows or Columns in Excel is Simple Even for Beginners

Leave A Reply

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

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021