Search Contextures Sites

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

Excel UserForms for Data Entry

 

30 Excel Functions in 30 Days

 

 

Contextures News

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:

  • 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: 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?

__________________________

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.