Excel Weekly News from Contextures August 26, 2014

Fix Pivot Headings + more Excel tips

During the summer, I am sending you the newsletter twice each month, instead of weekly. You will get the next newsletter on September 9th. In this week's Excel news, you'll see how to remove "Sum of in pivot table headings, and other tips. Thank you for reading the Excel news, and I hope that you are enjoying the Excel articles. If you have suggestions for future topics, please let me know.

 -  Debra -  ddalgleish@contextures.com

Data Validation Multi-Select Premium Update

Earlier this month, I updated my Data Validation Multi-Select Premium kit, so it's much easier to customize the code, and add it to your file. If you've purchased a copy of the kit, you should have received an email with a link to download the new version.

I've also created a page with answers to frequently asked questions about the product, and please let me know if you have any other questions.

Create Random Text in Excel

To enter random numbers on an Excel worksheet, you can use the RANDBETWEEN function. Set a bottom and top number, and a random number from that range is returned.

In this example, CHOOSE and RANDBETWEEN work together in a formula, to return text -- a random region name (East, West or Central) in one column, and a random gender (Male or Female), in another column.

Click here to see the details, and watch the video: Create Random Text in Excel

Remove Sum Of in Pivot Table Headings

For pivot table Value fields, "Sum of" or "Count of" is automatically added to the field name. You can shorten these default names, or change them to something more descriptive. Watch the short video, to see the steps, or follow the written instructions.

Click here to read the details, and watch the video: Remove Sum Of in Pivot Table Headings

More Excel Tips

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

Excel Announcements

Here are some upcoming events, courses, recently published books, and other new items, related to Excel:

Video: Get Text With LEFT RIGHT MID Functions

In this video, see how to use the LEFT, RIGHT and MID functions, to pull the year, month and day from a string of numbers.

Picking Tomatoes

It's hard to believe that summer is almost over, and school starts next week. My garden is doing well, and there were lots of tomatoes ready to pick, so I put my little helpers to work. Those tomatoes taste extra delicious when someone else picks them!


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.