How to delete hidden cells from a worksheet

New Contributor

Hi,

 

I want to delete hidden rows and columns from a huge data base (so it would be way too time consuming to delete them one by one). Is there a way to delete all hidden rows and columns in a worksheet?

 

I have Excel on Mac (the latest version I guess)

 

Thank you

 

AS

6 Replies

@Hans Vogelaar  Thanks but I dont have the Inspection option on Excel for Mac... and the VBA stuff is a complicated for me

@ASDeshaiesR 

I hope that someone with a Mac will have a suggestion for you.

@Hans Vogelaar , it seems that option is no longer available in Excel.. I am a microsoft user, not Mac.

 

Elipum_0-1637684267716.png

 

@Elipum 

I have Office 2021 for Windows; it does have the Hidden Rows and Columns option:

S0925.png

@ASDeshaiesR I'm a mac user and found a workaround. I don't know how big your database is but I was able to copy and paste the table into word then copy and paste it back into excel and it dropped the hidden cells. There was a little bit of reformatting I had to do but it did the trick for me.

 

Hope that helps in the future.