How to show or hide rows using a button in microsoft excel

How to Show/Hide rows in Microsoft excel using a toggle button.

After Pasting the code the re you'll have to save the workbook in this format .xlsm (Excel-Macro-Enabled-Workbook). If you do not save the file in this format this code or any VBA code will not work in excel.

Lastly you will have to click on the design mode again on the developer tab and now you are ready to go. You can now show/hide rows in excel just by clicking a toggle button and a few line of code.

#excel10tutorial #ShowHideRows

P.S: PLEASE SUPPORT THE CHANNEL BY BECOMING A PATREON


Thanks for watching.
-------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------
If you like this tutorial, please subscribe:

-----------------------------------------------------------------------------------------------------------
Please help transcribe and/or translate this video so more people
-----------------------------------------------------------------------------------------------------------

Connect us on social media

[thesimsphosphorus]

Thank you so much I've tried about thousand times and u made it work!!!! Really appreciate

[casper]

Great! But how about using a dropdown list and will select needed criteria and will hide unneeded ones. Please help. ty

[AlKhalifaEgy]

Thanks for your lecture.
I'm facing a problem with using the filter along with using checkboxes, means I don't want my checkbox to be reflected on hidden by filter, could you help please?

Thanks

[Izzydzafic]

Thank you so much!! this is very helpful!! But i have a problem I cannot hide more than 2 rows? Is there anyway to hide 10 rows?

[thblade]

Hello, thank you so much for this! I have a question tho, can we have an "if" function in the xAddress? say, if the xAddress' value is "0", then it would be hidden. I really like the Toggle button rather than the commandbutton. Please help

[sasikarnkhatikarn]

Thank you ao much for your showing, how can I show/hide rows or columns which aren't nearby for example; hide and show row 1 and 4 or column A and D

Many Thanks

[simpleme]

what should i do if i want to hide rows that are not next to each other?
For example: rows 1-10 and then 20:30?
I hope you could help me. thanks

[nirusun]

Hi, Only one Toggle button working fine, i want to create more than one buttons for this hide unhide operation how to do it, when i use more than one button, 1st created button only working others are not working.

[titan]

how do i do the same but with columns instead of rows please???? :D

[anjenettrodriguez]

Is this can apply in google spreadsheet?

[paddysdynamicvideos]

I've had a look at this video and the one you did on columns.
They're both great!
One Question:
Say I want to hide column R:T
However, say I need to add a column to the worksheet. The rows I want hidden are now changed to T:Q.

How do I change the formula to keep hiding these rows, even if their number/letter changes?

Also, do you have a Patreon account or something similar?