Search Contextures Sites
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 firstname.lastname@example.org
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:
- Double-click one of the Ribbon tabs.
- While the commands are hidden, click on any tab, to temporarily see its commands
To show the Ribbon commands again,
- 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.
- Contextures PivotPower Premium Add-in
- Contextures 30 Excel Functions in 30 Days
- Excel Online Course
- Excel Charting Tools
- Excel Dashboard Kits
- Excel Project Management Templates
- Excel VBA School
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!
Contextures Inc., Copyright ©2014
All rights reserved.