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
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.
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 ©2018
All rights reserved.