Search Contextures Sites
Custom Search

Contextures News

What new Excel features do you want?

Nov 10, 2015

Excel improvements, hide formula results, create test data, and much more, in this week's Excel news.

 -  Debra -

Hide Results Based on Date

If a list has dated items, you can hide formula results based on those dates. This month, I'm participating in Movember, so I created an activity tracking file in Excel, with running totals.

The formulas check the date, and only the totals from today or earlier are shown. Here is the formula for the running count, and there is a similar one for the running sum.


You can read more about it, and download the sample file here.

Sample Data for Testing

When you are testing new formulas or techniques in Excel, you might not want to use one of your actual files. One of the most popular downloads on my website each month is my Sample Data file, which has a table with fake sales data. If you want a simple test file to use, you can download it here.

Another way to create data for a quick test is to use the RANDBETWEEN function, with minimum and maximum values. Then, press the right mouse button while you move the data cells a little to the right, and back into place. In the popup menu, click Copy Here as Values Only.

Excel Articles

Here are a couple of Excel articles I read recently, that you might find useful.

Lock Slicers -- Mike Alexander shows how you can lock Slicers in place on a worksheet, so people can't move or resize them. (Level - Basic)
And if you use pivot tables, my Pivot Power Premium add-in will save you hours!

Excel Improvements -- Are there new features that you'd like to see in Excel? Go to the UserVoice site, where you can add your ideas, and vote for others. The Excel Team at Microsoft monitors the site, and tries to respond to any item with 20 or more votes. (Level - Basic)

More Excel Articles -- Find links to more articles in the latest Excel Weekly Roundup on my Contextures blog. And for a bit of spreadsheet humour, you can see what people are saying about Excel, in my weekly collection of tweets.

Days of Wind and Roses

We had beautiful weather for most of last week -- it felt like September. Then, things took a turn for the worse, and it got windy and much cooler. I saw this brave little rose hanging onto a fence, while the wind howled, and dark clouds gathered. It's time to bundle up!

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:



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



Newsletter Index


Excel news
by email




Excel UserForms for Data Entry


30 Excel Functions in 30 Days





Privacy Policy


Contextures Inc., Copyright 2015
All rights reserved.