As kids everybody loved going to the magic show and see the things disappearing like the hats, sticks and sometimes people. Well, we can’t help you in making people disappear but we would definitely love to show you some tricks that will help you to hide certain things in Excel.

Hiding cells

Steps to hide cells in Excel

1.  Select the cells that needs to be hidden. In our example it is B2:B5

2.  Right click and open the format cell dailog box or you can use the shortcut key Ctrl + 1

How to hide cells in Excel

3.  On the number tab, select the custom option that is available at extreme bottom.

4.  Type the formatting code as “;;;”(3 semicolons) without the quotes and press OK.

Format cells dialog box in excel

5.  The data in your cells shall be hidden(Magic).

hiding cells in Excel

Hiding rows and columns

Steps for hiding columns

1.  Select the column from which you want to hide all the columns. In our example we shall select column G.

hiding columns in Excel

2.  Press CTRL + Shift + Right arrow key and you will see that all the columns till XFD are selected.

3.  Press Right click and select the option of hide

4.  All the columns G onwards shall be hidden.

hiding columns in Excel

Steps for hiding rows

1.  Select the row from which you want to hide all the rows. In our example, we select row 10.

How to hide rows in EXcel

2.  Press CTRL + Shift + Down arrow key and you will see that all the rows till 1048576 are selected.

3.  Press Right click and select the option of hide

4.  All the rows from 10 onwards shall be hidden.

hiding rows in Excel

Hiding sheets

Steps for hiding a sheet in Excel

1.  Select the sheet which you would like to hide by clicking at the tab on the bottom. In our case we are hiding sheet 2.

2.  Right click and select the option of Hide.

hiding sheet in Excel

3.  You will see that your sheet is hidden

hiding sheet in excel

We know that these tricks won’t make you feel like a magician but they definitely will make your life a little easier. In case of any queries, mention it in the comment box and we shall get back to you at the earliest.