Forum Discussion
How to delete hidden cells from a worksheet
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 wor...
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.