Search Contextures Sites
Excel Weekly News from Contextures Apr 09, 2013
A few signs of spring are finally appearing, and we enjoyed a walk through the local conservation area on the weekend. The Credit River flows through, and the water was rushing under the rusty iron bridge that crosses it. It's great to spend time outdoors, without risking frostbite! You can see my photo at the end of the newsletter.
In this week's Excel news, you'll see how to create a drop down list with symbols, build a chart with keyboard shortcuts, and other tips. Thank you for reading the Excel news!
- Debra firstname.lastname@example.org
Create a Drop Down List With Symbols
To make data entry easier, you can use Excel's data validation feature to create a drop down list of options. Usually you make list of words, but you can also create a drop down list with symbols, such as up and down arrows.
To see the details, and a short video, click here: Create a Drop Down List With Symbols
Create a Dynamic Hyperlink
When you type a web site's address onto a worksheet, it usually changes to a hyperlink. Click that link, and your web browser will open, showing the selected web site.
You can also use the HYPERLINK function to create a link, and go to a web site, or even to a location in your Excel file. In this example, select a country from a drop down list, and the hyperlink changes to take you to that country's largest city, in the population table.
To see the details, and to download the sample file, click here: Create a Dynamic Hyperlink
Create Pivot Chart with Shortcut Keys
Use shortcut keys to quickly create a pivot chart, either on a new chart sheet, or on the worksheet. The shortcuts work for regular charts too.
Click here, to read the details, and to see the short video: Create Pivot Chart with Shortcut Keys
Video: Different Drop Downs in One Cell
As you saw in the article above, you can create drop down lists of words or symbols in Excel. To make these lists even more helpful, you can create dependent drop down lists. These lists will change, depending on what you have selected in another cell.
For example, select a country from the first list, and see the cities from that country in the second list. Watch this video to see the steps for creating dependent drop down lists.
For written instructions, please go to this page on my Contextures website: Data Validation - Dependent Lists
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.
River Walk Photo
Here's the view of our local river, from the rusty iron bridge that crosses it. The day was a bit cool, but sunny with a clear sky.
Contextures Inc., Copyright ©2014
All rights reserved.