Search Contextures Sites


Newsletter Index


Excel news
by email




30 Excel Functions in 30 Days




Contextures News

Excel Weekly News from Contextures Mar 19, 2013

Did you celebrate Pi Day and St. Patrick's Day last week? Things can get pretty rowdy on Pi Day, so I hope you behaved responsibly. ;-)

In this week's Excel news, you'll see how to show running totals in a pivot table, prevent invalid entries in combo boxes, and other tips. Thank you for reading the Excel news!

 -  Debra

Validate Entries in a Combo Box

One of my sample files uses combo boxes to make data entry easier.

Using a combo box for data entry has advantages:

  • you can set the font size
  • you can change the number of rows in the drop down list
  • the entry autocompletes as you type.

The lists are based on data validation setting, but the combo boxes allow you to enter invalid items.

By changing one of the Combo Box settings, you can prevent those entries, and limit people to selecting from the list.

To see the details, and to download the sample file, click here: Validate Entries in Excel Combo Box

Create Links or HTML Code with Formulas

If you ever create links or HTML code for your blog or web site, Excel formulas can help you create those.

For example, I sometimes add new books to my Excel books list, and after I get the product code from Amazon, an Excel formula quickly creates a link.

To see the details, and to download the sample file, click here: Create Amazon Links with Excel Formulas

Show Running Totals in a Pivot Table

Instead of showing just the monthly sales in a pivot table, you can also show a running total of those sales. And, in Excel 2010 and later versions, you can show a % Running Total too.

Click here, to read the details: Pivot Table Percent Running Total

Change Excel Hyperlinks to Text

When you type a website or email address in Excel, a hyperlink might be automatically created. To change the hyperlinks to normal text, you can paste them as values.

For more ways to convert Excel hyperlinks to text, see Prevent Hyperlinks, in the Excel FAQs.

Here is a short video that shows how it works.

Recommended Excel Tools

They aren't free, but these Excel tools are a worthwhile investment, so please 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 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.