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 Feb 25, 2014

Clear old items in pivot table + more Excel tips

In this week's Excel news, you'll see how to clear old items from a pivot table drop down, and other tips. Thank you for reading the Excel news!

 -  Debra

Create Rounded Shapes in Excel 2013

Shape Styles are flat in Excel 2013, but you can change a setting to see rounded options. I use these rounded shapes to create buttons that look "clickable".

Tip: Create a template with these and other favourite settings. Details in the blog post.

Click here to see the details: Create Rounded Shapes in Excel 2013

Manually Clear Old Items in Pivot Drop Down

After removing items from a pivot table's source data, they can still appear in the pivot field drop downs. See how to remove them.

Click here to see the details: Manually Clear Old Items in Pivot Drop Down

Problem Breaking Links in Excel

If an Excel file is linked to another workbook, you can break the links, and just show the values in the cells. Occasionally, the Break Link button is dimmed, so you can't use it. Read this article to see what the problem was, when this happened in one of my files.

Click here to see the details: Problem Breaking Links in Excel

More Excel Tips

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

  • Winston Snyder shares his code for turning the field captions on and off in a pivot table. Tip: If it’s just the headings, “Row Labels” and “Column Labels” that you don’t like, change from Compact Layout to Tabular Layout.
  • 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: Combine Text From Two Cells

You can use the CONCATENATE function, or the & operator, to combine text from two or more cells. If one of the cells has a formatted number, you can add a step, to show that formatting in the combined result.

Dolphin Watching

There are dolphins in this area, and I saw one last year, but it was too far away to get a picture. Last week, one swam by, and it was very close to the shore, so I finally got a picture! It swam slowly, bobbing up and down, so perhaps it was fishing for its lunch.


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.