Excel Weekly News from Contextures June 03, 2014

Hide Duplicates + more Excel tips

In this week's Excel news, you'll see how to hide duplicates in a sorted list, and other tips. Thank you for reading the Excel news!

 -  Debra   ddalgleish@contextures.com

Create IFRAME Code

If you're working on a blog post or web page, you might need to add a YouTube video or another web page in a frame. With my sample workbook, you can enter the URL, and a couple of specifications, like height and width, and a formula creates the IFRAME code that you can copy to your web page.

Even if you don't need IFRAME code, this sample will show you how to enter data in several cells, and bring it all together in one cell.

Click here to see the details, and download the sample file: Create IFRAME Code

Use Sample Pivot Table Code

If you find sample pivot table macros on my website, you can copy them into your workbooks, to use there. If you're not sure where the code should be pasted, or how to run the macros, this tutorial will help you figure it out.

Click here to read the details, and watch the video: Use Sample Pivot Table VBA Code

Quick Tricks for Auditing Formulas

If you're troubleshooting formulas on a worksheet, these quick tricks can help with the task.

Click here to see the details, and watch the video: Auditing Excel Formulas Quick Tips

More Excel Tips

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

Video: Hide Duplicates in Sorted List

To make a list easier to read, you can hide duplicate items in a column, so only the first item in each group is visible. In the example, month names are repeated, and conditional formatting hides the duplicates..

Lovely Lilacs

The lilacs are starting to bloom in the garden, and these purple ones have a beautiful scent. They're pretty to look at too! There's another lilac shrub, with lighter flowers, and those should be blooming in a week or two. Isn't spring a wonderful time of year?


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.