How to delete hidden cells from a worksheet

[ASDeshaiesR]

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

[#2]

@ASDeshaiesR 

See How to Delete All Hidden Rows and Columns in Excel for several ways to do this.

[#3]

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

[#4]

@ASDeshaiesR 

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

[#5]

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

[#6]

@Elipum 

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

[#7]

@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.