Search Contextures Sites
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 firstname.lastname@example.org
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.
- Contextures PivotPower Premium Add-in
- Contextures 30 Excel Functions in 30 Days
- Excel Online Course
- Excel Charting Tools
- Excel Dashboard Kits
- Excel Project Management Templates
- Excel VBA School
Note: I am an affiliate for the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2014
All rights reserved.