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 ddalgleish@contextures.com

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:

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.


Contextures Products

Save time with our "Done For You" Excel products.


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




Privacy Policy


Contextures Inc., Copyright 2019
All rights reserved.