HIDE , UNHINDE ROW AND COLUMN IN EXCEL.
We can HIDE and UNHIDE any ROW and COLUMN using HIDE and UNHIDE OPTION.
2 . UNHIDE
We can HIDE any ROW and COLUMN in EXCEL SHEET using HIDE OPTION.
By just a few STEPS, we can easily HIDE any ROW and COLUMN.
For example, we will HIDE the E COLUMN given in the photo below.
STEP -1 # First we will SELECT E COLUMN.
STEP -2 # Then go to column E and CLICK RIGHT and we see the OPTION below HIDE will CLICK on it.
STEP -3 # After CLICK on HIDE, our SELECT column (E) becomes HIDE.
So in this way we can easily HIDE COLUMN.
And if we want to HIDE any ROW, we will use the same method.
Now we will UNHIDE the COLUMN E HIDE done here again.
STEP -1 # For this, first of all we have to select the COLUMN on either side of the COLUMN. For example here we have to UNHIDE E COLUMN, then we will select both D and F COLUMN.
STEP -2 # Then going to SELECT column will RIGHT CLICK and we see OPTION of UNHIDE below and CLICK on it.
STEP -3 # After CLICK on UNHIDE, our HIDE column (E) becomes UNHIDE.
So in this way we can HIDE and UNHIDE any ROW and COLUMN.