How To Hide-Unhide Columns Or Rows With Plus-Minus Sign or Group-ungroup feature In Excel
In this excel tutorial for beginners, you’ll learn a tremendous trick to hide/unhide rows and columns in excel. If you follow the instructions, you’ll be able to show or hide rows using Plus + and Minus – sign. You can to the same thing for the columns also. Not only that, you’ll be able to do this using Excel’s built-in feature.
In this tutorial I’ll use the group feature in excel to hide/unhide rows and columns. To do it select several adjacent rows. Click on Group under the data tab and done. Your selected rows are now grouped and you’ll be able to hide them by clicking on the minus sign and you can unhide them by clicking Plus sign. Same goes for the columns.
There is another feature called auto outline under the group menu. If you click on that, your worksheet will be grouped based on the data set you have on the worksheet.
If you need to ungroup, select all the grouped column or rows and click on the ungroup button under the data tab. Done.
You can also remove all the grouping at once by clicking on the ungroup dropdown and then click on clear outline. This will remove all the groups from your worksheet.
#Excel #Show #Hide
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
/ excel10tutorial
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ
Here goes the most recent video of the channel:
https://bit.ly/2UngIwS
Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
All About Comments in Excel: https://bit.ly/excelcomments
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
Quora: https://bit.ly/3bxB8JG Become a member and enjoy exclusive perks while supporting the channel you love!
/ @excel10tutorial
Смотрите видео How To Hide-Unhide Columns Or Rows With Plus-Minus Sign or Group-ungroup feature In Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Excel 10 tutorial 31 Март 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 86,192 раз и оно понравилось 764 людям.