Delete Hidden Rows and Columns in Excel (Quick and Easy)

In this video, I'll show you how to quickly remove hidden rows and columns in Excel.

I covered the following topics in this video:
00:00 Quick Intro
00:23 Document inspector to delete hidden rows and columns from the entire workbook
02:42 VBA code to delete hidden rows and columns from used ranges in a worksheet
07:40 VBA code to delete hidden rows and columns from a specific range in the worksheet

#Excel #ExcelTips #ExcelTutorial

[trumpexcel]

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what topics you want me to cover in future videos.

[sustomusickillsyoutube]

You are literally the only person I've found in over an hour of searching who actually addresses this issue. Everyone else I've found, over dozens of forums / articles, simply tell you to use the "Right Click + Delete" option, and afterwards the Deleted columns are simply replaced by more columns. Fucking infuriating. Thanks so much for your video!!!

[sekhar]

Thank you for the tip on how to delete hidden rows and columns using document inspect which gave an info about worksheet as well.

[rupacFan]

Thank you! The VBA code works perfectly!

[mjvasnar]

I watched a lot of videos on this and you presented the easiest formate. Thank You.

[deepaknagar]

Always come with excel magic tricks, awesome.

[fayazmuhammad]

Finally you are comeback! Please sir regularlly upload 1 or 2 videos per week because your excel videos are very helpful we get some new knowledge.

[wayneedmondson]

Hi Sumit. Great tips. Thanks for the video. Thumbs up!!

[ramkumarb]

God bless u within 2 mins I sent my report also
Yes I subscribed also, 😁👍🏼

[atkearns]

Thank you for the detailed explanation!

[massofexcel]

Yes, its definitely new one. Suggest for an alternate way of doing it with 'Select visible cells' function too, to ease more for Users...

[timbabitelor]

Thank you, neat little trick with that Document Inspector.

[jesseharriethbatingal]

Hi Sumit, very productive and useful info

[asantos]

Can you Tell How to use named tablet on protected Excel sheets and use a Button to reset ALL filters with Just a simples click

[mhammad]

Can you assist in how to make a vendor data base

[shahjayesh]

Hi. Is there any way that converts basic formulas in into equation? eg. Say A1 is 5 n A2 is 3 and formula is A1+A2 which gives 8, I want to convert it into equation which gives actual numbers for that cell i.e 5+3

[brightjovanny]

But... 🤔 why would I want to delete hidden rows and columns?