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.
Save time with our "Done For You" Excel products.
- Pivot Power Premium Add-in - Time-saving tools for pivot table users
- Data Entry Popup Kit - Quick and easy data entry with a popup list
- Data Entry Search Popup - Enhanced data entry popup, with Search box
- Excel Tools Add-in - Make instant backups, sheet list with links, much more
- More Excel products from Contextures
Note: I am an affiliate for the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2018
All rights reserved.