How to delete hidden cells from a worksheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2423098%22%20slang%3D%22en-US%22%3EHow%20to%20delete%20hidden%20cells%20from%20a%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2423098%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20delete%20hidden%20rows%20and%20columns%20from%20a%20huge%20data%20base%20(so%20it%20would%20be%20way%20too%20time%20consuming%20to%20delete%20them%20one%20by%20one).%20Is%20there%20a%20way%20to%20delete%20all%20hidden%20rows%20and%20columns%20in%20a%20worksheet%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20Excel%20on%20Mac%20(the%20latest%20version%20I%20guess)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAS%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2423098%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2423174%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20delete%20hidden%20cells%20from%20a%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2423174%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1073119%22%20target%3D%22_blank%22%3E%40ASDeshaiesR%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20%3CA%20href%3D%22https%3A%2F%2Ftrumpexcel.com%2Fdelete-hidden-rows-columns-in-excel%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EHow%20to%20Delete%20All%20Hidden%20Rows%20and%20Columns%20in%20Excel%3C%2FA%3E%20for%20several%20ways%20to%20do%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2427200%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20delete%20hidden%20cells%20from%20a%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2427200%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%20Thanks%20but%20I%20dont%20have%20the%20Inspection%20option%20on%20Excel%20for%20Mac...%20and%20the%20VBA%20stuff%20is%20a%20complicated%20for%20me%3C%2FP%3E%3C%2FLINGO-BODY%3E
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

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