HIDE,UNHIDE ROW AND COLUMN

HIDE , UNHINDE ROW AND COLUMN IN EXCEL.

We can HIDE and UNHIDE any ROW and COLUMN using HIDE and UNHIDE OPTION.

1. HIDE

2 . UNHIDE

HIDE

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.

HIDE,UNHIDE ROW AND COLUMN

STEP -1  #   First we will SELECT E COLUMN.

HIDE,UNHIDE ROW AND 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.

UNHIDE

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.

HIDE,UNHIDE ROW AND 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.

For more information see VIDEO -

Leave a Reply

© 2020 NtOffice.in         ।     All Rights Reserved.

ABOUT US    ।    CONTACT   US   ।    TERMS  OF  USES   ।  DISCLAIMER   ।  PRIVACY  POLICY

WhatsApp
Google+
Facebook
Telegram