Hide blank rows in Excel with a button

An easy way to hide unused rows in Excel with minimal use of macros. Using this method you can set up a helper column which, using normal Excel functions, determines which rows should be hidden or not, and then the simple VBA macro hides or unhides with one click. ------------------------------------------------------------------------------------------------------------------------------------------------------ ✅- Free check of your Excel Skill Level- https://excel-skills-assessment.com/skills-assessment/ 🏅- Test employee Excel skill levels- https://excel-skills-assessment.com/excel-skills-test-for-employment/ 🏆- Improve you Excel Skill Levels- https://online-excel-training.auditexcel.co.za/course-category/skill-based-beg-int-adv/ 🇿🇦- Our main website- https://www.auditexcel.co.za/blogs/ ------------------------------------------------------------------------------------------------------------------------------------------------------ ⏲Time Stamps 00:00 Needing to hide unused rows in Excel 00:32 Create a helper column 01:24 Add a filter 01:55 Specify which rows MUST always be shown 02:35 Show subtotals even if they are zero 04:15 Record the hide macro 04:45 Record the unhide macro 05:16 Hide the helper column 05:39 Create the buttons and attach them 06:46 Error checks to avoid having hidden information