course bg
EduPristine>Blog>Making things invisible in Excel

Making things invisible in Excel

March 20, 2015

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.

About Author

avatar EduPristine

Trusted by Fortune 500 Companies and 10,000 Students from 40+ countries across the globe, it is one of the leading International Training providers for Finance Certifications like FRM®, CFA®, PRM®, Business Analytics, HR Analytics, Financial Modeling, and Operational Risk Modeling. EduPristine has conducted more than 500,000 man-hours of quality training in finance.

Comments

Interested in this topic?

Our counsellors will get in touch with you with more information about this topic.

* Mandatory Field

`````````````````````````````````````````````````` Post ID = 72861