In this short video, I cover a few ways to quickly unhide columns in Excel.
There are multiple ways to unhide columns in Excel:
— Using a keyboard shortcut
— Using the format options
— Using the name box and format options
— Using the mouse (by dragging and increasing the width)
You can read more about it here –
Subscribe to this YouTube channel to get updates on Excel Tips and Excel Tutorials videos –
This YouTube channel is managed by Sumit Bansal (who also runs the TrumpExcel website). This channel is meant for people who want to learn Excel. It covers a lot of Excel basics and advanced Excel topics such as Excel Formulas, Functions, Pivot Table, Shortcuts, Excel VBA, Macros, Excel Dashboards, Excel Charts, Conditional Formatting, Power Query, etc. Please subscribe to this channel to be the first to know when new Excel tutorials come out.
You can find a lot of useful Excel resources on the following site:
#Excel #ExcelTips #ExcelTutorial
Xem thêm bài viết: https://marishka-moi.com/category/cong-nghe
4 Replies to “How to Unhide Columns and Rows in Excel”
Bhayya Create More Videos, you have Number of followers, Keep continued the journey. Existing videous Awesome.
Hi Sumit.. thanks for the video.. very informative. For quick hiding of columns using the keyboard, I use CTRL+0. To unhide columns, I use CTRL+SHIFT+0. For quick hiding of rows using the keyboard, I use CTRL+9. To unhide rows, I use CTRL+SHIFT+9. As you pointed out in your video, for the unhiding procedure, the pointer must be positioned in the hidden row or column or selected across the hidden row or column, as the unhide process is executed against whatever is the position or range of the pointer at the time. I love keyboard shortcuts, so those are my goto methods. Thanks for your tips. I always enjoy how thoroughly you cover the topic. Thumbs up!
Very helpful.. can we use Cnt A and use short cut Alt OCA for unhide