How to Unhide Columns and Rows in Excel



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 –

Free Excel Course –
Paid Online Training –
Best Excel Books:

⚙️ Gear I Recommend:
Camera –
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic –
Wireless Mic:
Lighting –

Subscribe to get awesome Excel Tips every week:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

Watch more new videos about Excel Office | Synthesized by Mindovermetal English

Rate this post

Bài viết liên quan

Theo dõi
Thông báo của
guest
17 Comments
Cũ nhất
Mới nhất Được bỏ phiếu nhiều nhất
Phản hồi nội tuyến
Xem tất cả bình luận
Rida Naeem

no shortkey to unhide ?

SARVESH RAJWANI

I need a help
I by mistake pressed CTRL + 0 which hid all the columns in the Excel sheet

Now there is no column appearing…
How to bring all the columns back?

Roy Bayona

thank you boss this video helps to some people

Lucel Salvan

thank you

Noemi Perez

THANK YOU!

Archana Vm

Thank you so much it really helped to me😍

Kamruzzaman Shaikh Konok

Thank you.

Mani Kandan

Thank you

Piyush Gadekar

thank you !

Ravi Arora

excellent Demonstration

George Carter

Much appreciated. Thank you.

Beryl EKIKO YEBERLA

Thanks so.much

Prasad Londhe

Very Helpful, thank you so much. keep the good work going

Roshan Panhalkar

Thanks 🙂

Settipalli Vbr

Bhayya Create More Videos, you have Number of followers, Keep continued the journey. Existing videous Awesome.

Wayne Edmondson

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!

Piar Chand Dogra

Very helpful.. can we use Cnt A and use short cut Alt OCA for unhide