Excel Weekly News from Contextures Dec 17, 2013
Ungroup dates in filter drop down + more Excel tips
In this week's Excel news, you'll see how to quickly clear all filters from a list, and other tips. Thank you for reading the Excel news! We'll take a short break for the holidays, and your next newsletter will arrive on January 7th.
- Debra firstname.lastname@example.org
By default, when you turn on an AutoFilter, dates are grouped in the drop down list. You can manually change a setting, to ungroup them in the current workbook. You can also use programming to turn the grouping on or off.
Click here to see the details, and watch the video: Remove Date Grouping in Excel Filter Drop Downs
When you add new items to a pivot table, they might not appear in alphabetical order. Sometimes, if the pivot field is filtered, those items don't appear at all.
Watch this video to see how to show the items alphabetically. Also see how to change a pivot field setting, so new items automatically appear, even if the field is filtered.
Click here to see the details, and watch the video: Show New Pivot Table Items in Alphabetical Order
One of the accessibility features in Microsoft Office is the Voice Narrator. It speaks to you, describing the cell contents or the selected item on the worksheet. I accidentally turned this feature on, and it took a few minutes to figure out how to turn it off again..
Click here to see the details, and watch the video: Turn Off Narrator Voice in Excel Workbook
Here are a few more Excel articles that I read this week, that you might find useful:
This video shows how to use the COUNTIF function to count cells that contain a specific string of text, such as "Pen". How many orders were placed for any kind of pen, such as "Gel Pen", "Pen" or even a "Pencil"?
I'll be taking a little time off to enjoy the holidays, but don't worry, the new intern will be looking after the office while I'm away. She has her own phone, and a trusty calculator, and is learning how to use Excel.
Happy holidays, and I'll see you in January!
In addition to all the free
Excel tips and tutorials, there are other Excel tools that you can
invest in. To learn more about the products listed below, 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 some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2017
All rights reserved.