Contextures News 20130423

Pivot Table Conditional Formatting

April 23, 2013

Show running totals in a worksheet, fix conditional formatting in a pivot table, and more, in this week's Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.

Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.

Will spring ever arrive? I'd like to get my garden started, and set up a spreadsheet to keep track of what has been planted. The birds look a bit chilly too, like the little yellow finch that you can see in my photo at the end of the newsletter.

Pivot Table Conditional Formatting

If you use conditional formatting in a pivot table, it might not update correctly, if you add new data or change the layout.

There is a setting that you can change, to ensure that the formatting automatically adjusts.

Pivot Table Conditional Formatting

To see the details, and a short video, click here: Pivot Table Conditional Formatting

Create a Running Total in an Excel Column

Instead of showing an overall total, you can create a running total on a worksheet, by using the SUM function in each row.

running total on a worksheet

To see the details, and a short video, click here: Create a Running Total in an Excel Column

Click to Move Excel List Items Up or Down

In this Excel file from Jim Cone, you can click the up/down arrows to rotate a list of items on an Excel sheet. For example, if January is at the top of the list, one click moves February up, and January rotates to the bottom of the list.

Move Excel List Items Up or Down

Click here, to read the details, and to download the sample file: Click to Move Excel List Items Up or Down

Video: Create Named Ranges from Worksheet Labels

It's a good idea to use named cells in your worksheets. You can use names in formulas, and quickly select a named range.

This video shows you a quick way to create several names with a single click, by using the labels that you typed in worksheet cells. For more on naming ranges, please visit the Excel Names page on my Contextures website.

Excel Dashboard Course Recommendation

For a limited time, Mynda Treacy from My Online training Hub is opening her Excel Dashboard course, and if you sign up by 8 pm Pacific time on May 1st, you can get the course for 20% off. Use the Discount code: DASH

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.

The previous classes were very successful, and you can read the glowing reviews from the students, who loved all the techniques that they learned in the course, and are using them to impress their colleagues.

Click here to find out find out details of the course, read the student comments, and watch the 'behind the scenes' video that shows you what you'll receive as a member.

Remember, if you sign up by May 1st, you can get the dashboard course for 20% off. Use the Discount code: DASH

Are your skills up to date

Contextures Products

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

Yellow Finch Photo

It's still a bit cold, but a few more birds are starting to appear, like this little yellow finch. He was sitting in a tree in front of our house last Friday, and it was easy to spot his bright feathers.

That's it for this week! If you have any comments or questions, send me an email.

NOTE: For the online version, paste this URL into your web browser:
I'll also post any article updates or corrections there.

Debra Dalgleish

Debra Dalgleish

P.S. You can choose the full Contextures news package (news and occasional special announcements), or basic news package (news only). Click either link to change your option.



Get weekly Excel tips from Debra


pivot power free






Last updated: October 28, 2018 9:42 AM