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 firstname.lastname@example.org
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
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
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
Here are a few of the Excel articles that I read last week, that you might find useful:
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.
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.
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.
Contextures Inc., Copyright ©2017
All rights reserved.