In the previous article, we saw “How to Freeze Panes to Lock Rows and Columns in Excel?“, now we will see How to Hide and Unhide Rows and Columns in Excel? So let’s start…
How to Hide Column?
To hide the column in excel select the column right-click on it and select the option “Hide” or press “H”. Let’s see…
How to Hide Column Via Shortcut Key?
To hide the column via shortcut key press the “CTRL”+ SPACE” key to select the column and press the “CTRL + )/0” key. Let’s see…
How to Unhide Column?
To unhide the column, the double line denotes the hidden column select the columns and right click select the option “Unhide” or press “U”. Lets see..
How to Hide Row?
To hide row select row right click on it and click on the option “Hide” or “H”.
How to Hide Row Via Shortcut Key?
To hide row via shortcut key press “SHIFT + SPACE” to select the row and press “CTRL + ( / 9” key. Let’s see..
Select the appropriate shortcut key then only shortcut key will work.
How to Unhide Row?
To unhide row select the double line that denotes hidden row, right click on that and select the option “Unhide” or “U”. Lets see…
How to Unhide Row via Shortcut Key?
In excel if you want to unhide row via shortcut key first, select the row and hide it and then press “CTRL + SHIFT + (/9”. let’s see…
In this way, you can hide/unhide rows and columns in excel. If you are working on large data then you can use the shortcut key to hide or unhide rows and columns.
For Latest Updates & Learning Join Our YouTube Channel: Join Now
If you have any query please do write your query below in the comment box!
