Enjoying Spring

I hope you are enjoying temperate weather this week and that things are going well in your corner of the world. I also hope you enjoy this week's tips.

—Allen
     

ExcelTips (ribbon) for 20 May 2017

Charts and charting
Moving Objects with a Chart

Excel allows you to add all sorts of objects to your worksheets. Among the objects you can add are text boxes, shapes, and charts. If you add all three types of objects and you want to move them as one, Excel provides two ways you can accomplish the task.

Read this tip »

(Thanks to Nick Jolly, Ira Bernstein, Bob Beechey, Derek Roberts, Mike Shellito, Peter Atherton, Clifton Schnarr, Benjamin Morin, David Smith, William Driskell, Erik Oberg, Gayle Larson, Bernard de Groot, Darren Goodwin, David Shepherd, Steven Morgenstern, and Gunnar Larsson for contributing to this tip.)

 
Editing
Creating Selections

Want a really easy way to create a selection of a group of cells? Discover how to use the Extend key to make this task easier than ever.

Read this tip »

 
Baffled by Array Formulas?

Have you heard about the special array formulas you can create in Excel? They make it a snap to perform calculations using large amounts of data and even generate results you can't get with regular formulas. Array formulas may be Excel's best-kept secret. Remove the confusion; discover how to use array formulas today.

 
Date formulas
Tombstone Date Math

Doing math with dates is easy in Excel. Doing math with old dates, such as those you routinely encounter in genealogy, is a different story. Here's how you can figure out birth or death dates given one or the other and a precise age.

Read this tip »

 
Online and web
Automatic Text in an E-mail

When creating an e-mail address hyperlink using the Insert Hyperlink dialog box, Excel allows you to enter a subject for the message to be created by the link. If you want to also specify some body text, you need to use the techniques described in this tip.

Read this tip »

     

Help Wanted

This section is for those having problems making Excel behave. If Excel is giving you fits, feel free to submit your own Help Wanted question.

If you have a solution for the problems below, click the link after the problem to send us your answer. (All responses become the sole property of Sharon Parq Associates, Inc., and can be used in any way deemed appropriate.) If your response is used in a future issue, you will be credited for your contribution to the answer.

 
Swapping Two Cells

Is there a way to select any two cells and then swap the contents without doing a three-step move?
—Adam Nimmo (provide an answer for this Help Wanted question)

 
ExcelTips is a free service of Sharon Parq Associates. You can find thousands of tips at our website and a whole lot more. ExcelTips is part of the Tips.Net network.
Sharon Parq Associates, Inc.  •  PO Box 1187  •  Mountain View, WY  82939  •  307-200-0450