Search Contextures Sites

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

30 Excel Functions in 30 Days

 

 

 

Contextures News

Excel Weekly News from Contextures Mar 12, 2013

Did you remember to change your clock for Daylight Savings Time? It was hard to get up on Sunday morning, after losing that hour of sleep. At least the sun has been shining, so that helps, and you can see one of my sunset photos at the end of this newsletter.

In this weeks Excel news, you'll see how to get an accurate count in a pivot table, create a dependent combo boxes, and other tips. Thank you for reading the Excel news!

 -  Debra ddalgleish@contextures.com

Click to Show or Hide Excel Chart Data

Instead of seeing all the chart data, all the time, you can add check boxes on a worksheet, to let people decide which series to show.

No programming is required -- there are formulas that do all the work.

To see the details, and to download the sample file, click here: Click to Show and Hide Chart Data

Create Dependent Combo Boxes

In an Excel UserForm, combo boxes with drop down lists can make it easier to enter data. In this example, you must choose a part type first. Then, the Part combo box only shows part for the selected part type.

To see the details, and to download the sample file, click here: Create Dependent Combo Boxes

Count Blank Entries in Pivot Table

A pivot table is a quick an easy way to sum or count items, but be sure that you're using a field that will give you accurate results. If there are blanks in the field you're using, the count might be wrong.

Click here, to read the details: Count Blank Entries in a Pivot Table

Show and Hide the Ribbon

Whether you love the Excel Ribbon, or hate it, you might not need to see it all the time. The Ribbon uses a fair amount of space at the top of the Excel window, and you might prefer to have more room for the worksheet cells.

To quickly hide the Ribbon command, and leave only the tabs showing:

  1. Double-click one of the Ribbon tabs.
  2. While the commands are hidden, click on any tab, to temporarily see its commands

To show the Ribbon commands again,

  1. Click on a Ribbon tab, then double-click on the selected tab.

Here is a short video that shows how it works.

Recommended Excel Tools

They aren't free, but these Excel tools are a worthwhile investment, so please click on the links to take a look at their features, and decide if they're right for you.

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

Catching the Sunset

It's harder to get up during the first week of daylight savings time, but at least I was still awake at sunset!

sunset

Learn how to create Excel dashboards.

 

Privacy Policy

 

Contextures Inc., Copyright 2014
All rights reserved.