unlock

How to Unhide Columns and Rows in Excel

0:00
↔️ ↕️

Timecodes:

hello there welcome to the video

Metroplex CENTCOM I am so mad Bunsen and

in this short video I'm going to show

you how to quickly hide and unhide rows

and columns in Excel so let's get

started here I have this worksheet where

I have these columns that are colored

and let me first quickly show you how to

hide columns so to hide a column you can

use a keyboard shortcut ctrl 0 so if I

hold the ctrl key and press 0 it would

instantly hide that column you can also

select this entire column here by

pressing the alphabet here the column

alphabet and right click and go to hide

so if I click on this option it'll again

hide this column and the third way of

doing it is that there is an option in

the ribbon so you select any cell here

you go to the Home tab and here in the

cells group you have the format option


Related queries:


how to unhide columns in excel
how to unlock cells in excel
how to unhide columns in excel shortcut
how to unlock cells in excel when scrolling
how to unlock cells in excel without password
how to unhide columns in excel far left
how to unhide columns in excel mac
how to unhide columns in excel 2010
how to unhide columns in excel at once
how to open columns in excel
how to unhide columns in excel mobile
how to unhide columns in excel google sheet
how to unlock cells in excel mac
how to unhide columns in excel using keyboard
how to unhide columns in excel spreadsheet