How to Create a Button to Show or Hide Multiple Rows in Excel
How to show/hide multiple rows using toggle button in excel?
Hiding multiple rows is tiresome so we are going to create a toggle button and then assign macro to that button so that we can show & hide several rows effortlessly.
This is an advanced excel tutorial and we are going to use macro coding for this tutorial. This excel tutorial is created on excel 2019 but this will work on excel 10, 13, 16 also. Haven't tried on excel 365 but you can try and let me know the result ;-)
Now in our previous videos we have covered some advanced excel tutorial like this and the links are below if you haven't noticed yet.
How To Use Button To Show Hide Columns In Excel: • How To Use Button To Show Or Hide Col...
How to show or hide rows in excel using a button (Only a range of rows like row 5 to 13) : • How to show or hide rows using a butt...
Now lets get straight to the excel tutorial.
Step 1: Click on the developer tab (How to add developer tab in excel: • How to add developer tab in excel )
Step 2: Click on the insert button and then select ActiveX Toggle Button
Design your button according to your choice
Step 3: Now double click on the button and the VBE (Visual Basic Editor) will open.
Step 4: Write the code (Please subscribe and here goes the code: / 30291379 )
Step 5: Close the VBE and click on the design mood again.
Done. Now your toggle button is ready and you can now easily show and hide a lot of rows fast and effortlessly.
Bonus Fact: You'll have to save the file in .Xlsm format. (Here is how you can do that: ) This will allow you use the button every time you open your workbook.
#HideRows #Buttons
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
/ excel10tutorial
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ
Watch the latest video here: http://bit.ly/2oXmqsb
Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Excel VBA Programming Course: http://bit.ly/excelvbacourse
Social media:
Facebook: / excel10tutorial
Twitter: / excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: / excel10tutorial
Instagram: / excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial
Смотрите видео How to Create a Button to Show or Hide Multiple Rows in Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Excel 10 tutorial 27 Сентябрь 2019, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 30,943 раз и оно понравилось 105 людям.