course bg
EduPristine>Blog>Let’s Play Hide and Seek with Financial Modeling and Excel!

Let’s Play Hide and Seek with Financial Modeling and Excel!

December 3, 2013

Hey everyone! As we all know, use of Excel in Financial Modeling is crucial. Similarly, learning to ‘Hide’ or ‘Unhide’ sheets in Excel is equally crucial. So, this blog is dedicated to make things simpler for you! Below you will find a fun and colorful step-by-step process about how to ‘Hide’ and ‘Unhide’ sheets.

Okay, so let’s begin!

Let’s get to the very basics by first understanding how to hide and unhide single worksheets. Then we will see how to hide and unhide multiple sheets together.

There are multiple ways to hide worksheets in excel. Let’s discuss them one by one:

#Financial Modeling using Excel

#Financial Modeling using Excel

 

#Financial Modeling using Excel

#Financial Modeling using Excel

 

#Financial Modeling using Excel

After clicking ‘Unhide Sheet’, the following window will pop up:

#Financial Modeling using Excel

Now, this window shows all the sheets which are hidden. You can select the sheet which you want to unhide and then just click ‘OK’ and now you can see the hidden sheet which you selected.

There is, however, an alternative and easier method! Shall we see how it goes?

screenshot.431

 

#Financial Modeling using Excel

#Financial Modeling using Excel

 

#Financial Modeling using Excel

 

#Financial Modeling using Excel

#Financial Modeling using Excel

After clicking on the ‘Unhide’ button, you will get the following window:

#Financial Modeling using Excel

Now, this window shows all the sheets which are hidden. You can select the sheet which you want to unhide and then just click ‘OK’ and now you can see the hidden sheet which you selected.

In this way you can go for ‘Hide’ and ‘Unhide’ for a single sheet.

This leads us to the next question:

What do we do when we have more sheets to hide or unhide?

For hiding it is simple:

#Financial Modeling using Excel

 

#Financial Modeling using Excel

And voila! The selected sheets are hidden!

There will be subsequent posts to this blog. So stay tuned for more!

If you have any comments or queries, feel free to start a discussion thread below!

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 = 41645