Search Contextures Sites


Newsletter Index


Excel news
by email




Excel UserForms for Data Entry


30 Excel Functions in 30 Days



Contextures News

Excel Weekly News from Contextures Apr 29, 2014

Click to hide details + more Excel tips

In this week's Excel news, you'll see how to quickly show or hide table details, and other tips. Thank you for reading the Excel news!

 -  Debra

Click to Hide Details

If you have a wide table in a worksheet, you might not need to see all the columns, all the time. You can use grouping, to quickly show or hide some of the columns -- no macros required for this quick trick.

Click here to see the details, and try it in your own files: Click to Hide Details

Dashboard Course and Tools

You could use the above tip, for hiding columns, with a wide table on a dashboard. If you'd like to improve your dashboard skills, Mynda Treacy from My Online training Hub is opening her Excel Dashboard Course, and if you sign up by Thursday, May 1st, you can get the course for 20% off.

I've been through this course, and highly recommend it. The course is video based, delivered online and is available 24/7. You'll receive comprehensive workbooks and sample dashboards to keep, and there’s even an option to download the videos.

Bonus: If you sign up for Mynda's course through one of my links, I'll send you a copy of the time-saving DataPig Dashboard Tools add-in. Just enter the Referral Code – DebraD – in the box just below the Buy Now button. You can see the Dashboard Tool key features in this very short video.

Hide Pivot Table Errors

When there are errors in the pivot table source data, you might see errors in the pivot table Values area. If possible, fix the errors in the data, so they don't show up in the pivot table If you can't fix the source data, it's possible to hide the errors in the pivot table. In the pivot table options, you can change a setting, to hide those errors.

Click here to read the details, and watch the video: Hide Pivot Table Errors

Problems Pasting in a Filtered List

You can run into serious problems, if you try to copy and paste data into a filtered list. See why the problem occurs, and a couple of workarounds, to help you avoid the problem.

Click here to see the details, and watch the video: Problems Pasting in an Excel Filtered List

More Excel Tips

Here are a few of the Excel articles that I read recently, that you might find useful:

  • Erin describes the spreadsheet she uses to keep track of her finances, including a pile of student loans. Read the comments too, to see how other recent graduates are using Excel.
  • Mynda Treacy explains how you can save time by using chart templates, with all your favourite colours, and other settings, stored in them.
  • Finally, for a humorous peek at what other people are saying about Excel, read this week's collection of Excel tweets, on my Excel Theatre blog.

Video: Flexible COUNTIF Formula

You can use the COUNTIF function to count something specific. In this video, you'll see how to create a drop down list of operators, to choose less than, greater than, etc., to use in a formula. Also, use a cell reference in the formula, so you can quickly change the criterion.

Do You Like Pie?

After last week's cruel joke of snow in April, Mother Nature was kinder this week. The little patch of rhubarb in our garden is beginning to sprout, but it might be a few weeks before there is enough for a rhubarb pie.


Recommended Excel Tools

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.


Learn how to create Excel dashboards.


Privacy Policy


Contextures Inc., Copyright ©2014
All rights reserved.