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

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.

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

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.

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.

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

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 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.

3. You will see that your sheet is hidden

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.
Related links you will like:
Comments