How to Delete Hidden Rows that are not Filtered in Excel

Before applying the technique, ensure to duplicate your unique document in the event of ill-advised working.

Step 1: Navigate to the File Tab and Select Info

Click File in the ribbon, and select Info.

Step 2: Select Inspect Document

Click the arrow button in Check for Issues, and select Inspect Document.

Step 3: Put a Tick Mark on Hidden Rows and Columns Choice

Check that the Document Inspector window shows. Drag the parchment bar to the base, and confirm that the Hidden Rows and Columns choice is checked as a matter of course.

Step 4: Click the Inspect Button on the Base

Check that the Remove All button shows up in Hidden Rows and Columns and that the ‘Number of stowed away lines found’ shows.

Step 5: Click Remove All

Confirm that every single secret line and segment containing the information was Go To Specialeliminated.

Step 6: Click the Close Button

Click the Close button to stop the Document Inspector window. Return to the worksheet, check that secret lines are taken out appropriately, and just show columns in the channel are kept.

Assume we have a considerable rundown in the worksheet (1000 columns or more), and we truly do channel to show just a few cells of the rundown by certain rules. To keep the noticeable cells and eliminate the secret lines to lessen repetitive information and the size of the record, what might we do? On the opposite side, if we need to eliminate the apparent cells in the channel and keep the secret columns, how might we do it? In this article, we will acquaint you with a few strategies to eliminate covered or noticeable columns in the channel.