How to Hide Sheets in Excel

How to Hide Sheets in Excel

In this tutorial, you’ll get familiar with how to hide sheets in Excel. This can be quite useful if you need to make one or more of the sheets invisible to you or anyone else accessing the workbook.

You’ll see, it’s quite easy!

See the video tutorial and transcription below: 

See this video on YouTube:
https://www.youtube.com/watch?v=GZdvMARxwkc 

You can see that we have two sheets we’re working with – ‘Questionnaire’ and ‘Months’.

How to Hide Sheets in Excel - more sheets

Now, we want the first sheet, ‘Questionnaire’ to show for everyone, because it contains the questions we want to ask and the drop-down list we created during one of our previous tutorials.

How to Hide Sheets in Excel - sheet visible for everyone

The other spreadsheet is called ‘Months’. This one doesn’t have to be visible for other people, because we created it to store our source data – the list of months for the drop-down menu.

How to Hide Sheets in Excel - sheet not visible for people

To make the workbook look neat and professional, we’ll hide the ‘Months’ sheet.

We’ll select the sheet by clicking on it, then right-click and choose the option ‘Hide’.

How to Hide Sheets in Excel - hide option

Perfect!

The sheet with the list of months has been hidden. Only the first sheet, ‘Questionnaire’, is still visible.

How to Hide Sheets in Excel - sheet has been hidden

There is one more thing to remember, though.

A Little Tip that Is Good to Know

Data from the sheet ‘Months’ are still available and you can still work with them, even though the spreadsheet has been hidden. So, what does it mean for you?

Practically, the drop-down list still works, despite the fact that the source data for this list are on the hidden spreadsheet.

How to Hide Sheets in Excel - data are available

If you’re curious to see more on how to work with spreadsheets, like how to unhide, rename or completely delete a spreadsheet, watch our upcoming EasyClick video tutorials!

If you found this tutorial helpful, watch other video tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button on our YouTube channel and join the EasyClickers!

See you in the next tutorial!

Comments

Add comment

Your email address will not be published.

Your personal information will only be used for the purpose of processing this comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.