Excel Weekly News from Contextures Dec 10, 2013
Quickly clear all filters + 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!
- Debra firstname.lastname@example.org
If you put data validation rules on a cell, you can add messages to help people put valid data into the cell:
Click here to see the details, and watch the video: Show Input and Error Messages in Excel
Instead of using the Ribbon commands to clear the filters in a table or pivot table, add the Clear button to your Quick Access Toolbar. Then, you can clear the filters with a single click, instead of several steps.
Click here to see the details, and watch the video: Clear Excel Filters With a Single Click
Here are a few more Excel articles that I read this week, that you might find useful:
If you want to change data from a horizontal layout to a vertical one, watch this very short video to see the quick steps. The written instructions are in the Excel FAQs on my website.
We don't put up many holiday decorations, but our little Christmas village gets set up in the front hall every year. Each house has a light switch, and my granddaughter loves to help by turning on those lights, every time she visits.
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.