Subscribe for access to this FREE e-learning mini-course!


Your First Name:


Your Surname:


Your Email Address:



Subscribe
Close


Small logo
Hamburger menu
Menu
bookings:   0333 6000 111
service:       0333 6000 555
    or           
Free Video Tutorials : Excel Navigation
Free Video Tutorials : Excel Navigation
Search

EXCEL NAVIGATION: HOW TO HIDE SHEETS

Learn how to hide worksheets when working with Microsoft Excel

Background information and resources for Excel courses that we hope you find useful

THE SIMPLEST WAY OF HIDING A SHEET

We don't always want people poking through all the hard work we've put into our spreadsheets and in Excel, there are often good reasons why you may want to hide the data on particular sheets.

There are a few different ways to hide sheets and secure the workbook, but there are also usually ways and means of getting around hidden objects, so even if you have followed some of these tips, don't put all your company secrets on a spreadsheet if you are sending it out to a customer!

The standard method of hiding a sheet in Excel, is to right-click on the sheet tab and select Hide...

Excel Navigation: How to hide sheets

PROTECTING THE WORKBOOK WITH A PASSWORD

Of course this method is easily circumvented by someone just right clicking and Un-Hiding the sheet again. We can get around this by protecting the Workbook, which then stops people from un-hiding hidden sheets.

To achieve this, you can select Protect Workbook on the Review tab, and then set a password in order to protect the structure of the file (and to stop people from un-hiding sheets).

The trouble is, protecting the whole Workbook also stops them from doing lots of other things too, like maybe inserting and deleting sheets and copying or re-naming sheets.

USINING SIMPLE VBA TO HIDE A SHEET

Another solution then is to hide a sheet so no one knows it's there at all. For this we use VBA. Visual Basic for Applications (VBA) is the programming language behind Excel. Don't worry, no programming is needed for this trick: we just need to tweak a setting in there.

Press Alt+F11, this will open the VBA window.

Usining Simple VBA to Hide a Sheet

The VBA window will have the Explorer and Properties windows open on the left side. The Explorer window will list your Workbook and its sheets, so select the Worksheet you wish to hide. The properties window will now list the properties for the selected sheet. Find the Visible property and set it to: xlSheetVeryHidden

Excel Navigation: How to hide sheets

Now close down VBA and try and unhide your Worksheet.

As far as Excel is concerned (and other people of course) there is no hidden sheet. Other sheets can be hidden/un-hidden as before. Of course to make it perfectly secure you need to password protect the VBA project ... but that's another lesson!

WE HOPE YOU FOUND THIS USEFUL

Want to see how we can really help you?

LINKS TO MORE ...

Main Excel Resources Page

Excel Resources

Video tutorials & articles, and templates to help you work better in Excel

      Click to view

 

Video Tutorials - Navigating Excel

Video Tutorials - Navigating Excel

Navigate and control the layout of your spreadsheets to make working with Excel much easier

Click to view

Excel Navigation: Why selecting multiple cells?

Excel Navigation: Why selecting multiple cells?

See how to fix accidental selection of multiple cells and how to use multiple selection in your work with Excel

      Click to read more

 

Excel Navigation: How to remove blank rows

Excel Navigation: How to remove blank rows

Useful tricks to help you remove blank rows in Microsoft Excel

      Click to read more

Excel Navigation: How to lock cells

Excel Navigation: How to lock cells

Learn how to lock cells in Microsoft Excel

      Click to read more

 

Excel Navigation: How to hide the ribbon

Excel Navigation: How to hide the ribbon

Learn how to hide the ribbon in Microsoft Excel

      Click to read more

GET IN TOUCH

Call us on:
0333 6000 111

   You can Email us direct (You'll usually get a response within 2-3 working hours)
   Or fill out the details below and we'll be in touch very soon:
SEND MESSAGE

HOW TO HIDE SHEETS IN MICROSOFT EXCEL

We can enhance your skills with courses for Microsoft Excel spreadsheets at any of our twelve training centres UK wide, or we can come to your offices: if you have groups of three or more staff who need training, this is a very convenient, flexible and cost effective option. Moreover, most of our excel courses are 1 day, which keeps "out of office" periods for attendees to a minimum.

We have been delivering Microsoft Excel course all over the UK since 1995 and have continually developed our philosophy of high quality, flexible and results-driven provision of courses for Excel to ensure constantly improving standards of quality.   So you can be confident that we have the expertise, and the experience, to give you a great return on your investment in Free Video Tutorials : Excel Navigation.

Why not contact us today to see how we can help with providing your MS Excel classes ?


Stay in touch

Stay In Touch!

Google+
LinkedIn
Twitter
FaceBook
YouTube

Contact Details

Activia Training

Locations Address: Head Office, Regus House,
268 Bath Road
Slough, Berkshire SL1 4DX

Phone Sales:           0333 6000 111

Service:       0333 6000 555

Accounts:   0333 6000 777



Back to top