How To Show Or Unhide Multiple Rows And Columns At Once In Excel
In this excel tutorial for beginners, I’ll show you a built-in feature of Microsoft excel that will allow you to unhide or show multiple rows or columns at once. Suppose you have 100 hidden rows in your worksheet and you need top unhide all of them at once. How would you do it? In this tutorial you’ll learn how. Same goes for hidden columns as well. Now follow the procedure below to unhide multiple rows in excel.
Step 1: Select the entire worksheet or select the rows where you have the hidden rows.
Step 2: Click on the Home Tab
Step 3: Click on Format
Step 4: Click on Hide & Unhide
Step 5: Select Unhide Rows
Or you can use the keyboard shortcut for unhide rows Ctrl + Shift + (
Done. This will unhide all rows in excel without using any vba.
Now follow the procedure below to unhide multiple Columns at once in excel.
Step 1: Select the entire worksheet or select the columns where you have the hidden columns.
Step 2: Click on the Home Tab
Step 3: Click on Format
Step 4: Click on Hide & Unhide
Step 5: Select Unhide Columns
Or you can use the keyboard shortcut for unhide columns Ctrl + Shift + )
Done. This will unhide all columns in excel at once.
#UnhideColumn #UnhideRow #Excel
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
Смотрите видео How To Show Or Unhide Multiple Rows And Columns At Once In Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Excel 10 tutorial 27 Март 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 107,599 раз и оно понравилось 561 людям.