Contextures

Contextures News

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.

Show Specific Sheet With Drop Down List

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.

select sheets from drop down

Custom Lists

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.

Excel VBA Course

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.

Excel Articles

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)

More Excel Articles -- Visit my Excel website for many more tutorials and videos. And for a bit of fun, read my weekly collection of entertaining Excel tweets.

Science Project

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:

www.contextures.com/newsletter/excelnews2016/20160614ctx.html

Recommended Excel Products

  • Easy Data Entry: Add a popup list, to your worbook, so you can quickly enter items in a cell. The Data Validation Multi Select Premium (DVMSP) kit helps you set things up. Then, a list appears when you click a cell, so only valid items can be entered. Reduce data entry errors and typos. You can customize the list, to allow single or multiple selection, in specific columns.
  • Excel Chart Tools: If you build complex charts, save time with Jon Peltier's Excel Charting add-in. Don't waste hours trying to format the chart yourself!

___________

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.

  • Full News Package: Weekly newsletter, plus occasional emails so you won't miss out on special Excel deals, free webinars, new products, and other Excel news.

Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.

 

 

 

Search Contextures Sites

Excel Data Entry Popup List

 

 

 

 

Last updated: June 14, 2017 11:50 PM