Search Contextures Sites


Newsletter Index





30 Excel Functions in 30 Days




Contextures News

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

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.

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.



Privacy Policy


Contextures Inc., Copyright 2017
All rights reserved.