Hide Excel Sheets With Drop Down List
June 14, 2016
Select a group of sheets from drop down list, and more, in this week's Excel news. If there are topics that you'd like to see covered in future newsletters, please let me know.
- Debra - ddalgleish @ contextures.com
Visit my Excel website for many more tutorials and videos.
Instead of scrolling through a big set of worksheets, use a drop down list to show just a few sheets. For example, select "Computer" from the drop down, and only sheets with "computer" in their name are visible. All other sheets are hidden, except the Menu sheet -- it stays visible too, so you can select "All", or a different type of sheet later.
You can get the sample file and watch a video on my website.
Do you ever use Custom Lists in Excel, as a quick way to fill a column, or as a rule for sorting a list or pivot table? They're handy to have, and you can read about them on my blog.
While setting up my new laptop, I created a few custom lists (names, geographic locations, numbers) and I'll use them when making sample files, or for quickly entering data. If the lists would be useful to you too, just download the workbook from the link below.
The workbook also has a list of all the settings you can change, before getting started with a new version of Excel. You can read about the settings, and download the workbook with the setup lists and custom lists on my website.
Learn how to use Excel macros, to make your work go faster and easier. Registration is open for the Macro for Beginners course by Allen Wyatt (Excel Tips). Save 20% on this online video training if you register by this Thursday, June 16th.
Here are a couple of Excel articles I read recently, that you might find useful.
Excel Shortcuts -- Erik Svensen shares his list of favourite shortcuts. I use most of them, but don't remember ever using that shortcut to remove all the borders. Handy! (Level - All)
Sort Challenge -- Kevin Lehrbass and Oz du Soleil faced an interesting Excel challenge -- how to sort a list of titles, while ignoring an A, An or The at the start of the title. They each had a different formula as a solution. (Level - Intermediate/Advanced)
It's been a long time since I had to help anyone with a science project. But, my grandson came to visit on the weekend, and brought along his school work that was due on Monday. So, I learned a lot about the carnivorous bladderwort plant, and how it catches small prey. The little water fleas at the bottom right don't look too realistic, but it's fun to try and trap them!
NOTE: If you have any problems with the links in the email, you can see this newsletter on my website -- copy this link and paste it into your browser:
Choose Your Excel News: Get the full Contextures news package, or the basic one. To change, click a link below, and use the sign-up form on that page.
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
Last updated: June 14, 2017 11:50 PM