Enjoying Easter

Welcome to Easter weekend 2019. For many this is a time celebrating new life and renewal of life, rooted in Christian theology. For others it is a time to mark the coming of Spring and the new life that is exhibited by the changing of the seasons. For still others it is a time to join with family and friends and celebrate whatever the Easter Bunny may bring.

This year, in the Wyatt household, it is also a time of reuniting, as we celebrate our biannual family reunion. We are in Mesa, Arizona, this weekend, getting together with my parents, siblings, and everyone's families. I mentioned the reunion in this space last week, but now the festivities are in full swing.

However you choose to celebrate this weekend (and whatever you choose to celebrate this weekend), I hope that it is a joyous time for you and yours.

My best to you.

—Allen
     

ExcelTips (menu) for 20 April 2019
Linking workbooks
Easily Changing Links

If you have linked information in your worksheets, you may want a way you can easily change the targets to which those links are pointing. One way you can do this is to make the links dynamic, using the INDIRECT worksheet function.

Read this tip »

 
Excel can calculate at lightening speed
Changing Error Checking Rules

Excel can check the data and formulas in your worksheet to see if it detects any errors. The rules used for this checking can be modified, if you desire.

Read this tip »

 
Lookup Exactly the Data You Want

Excel's lookup functions are easily the most powerful worksheet functions you can use. Master these seven functions you'll never again view a worksheet full of data in the same way. The power these functions provide you is anything but small. Take your first step today!

 
Data Validation
Adding Pop-Up Documentation to a Cell

Want to have a small help screen pop up when a user selects a particular cell? This can be done by using data validation, as described in this tip.

Read this tip »

 
Files
Pulling Filenames into a Worksheet

You can use Excel for all types of data processing. You may want to work with filenames in a worksheet, but the first task is getting those names into the worksheet. Here are a couple of ways you can get filenames, parsed according to a delimiter, into a worksheet.

Read this tip »

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