An Eventful Week

Welcome to May! This last week has been rather eventful around the Wyatt household for two reasons.

First, those who have subscribed to the newsletter for a while know that we live in the Southwest corner of Wyoming. Despite living here for the past decade, we have decided that it is time to move, once again. This time it is because the high altitude here (6,700 ft.) has an adverse effect on my wife's health. So, we have decided to move to Mesquite, Nevada, a small border town at a much lower elevation (1,600 ft.). We figure that dropping almost a mile in altitude should help.

In preparation for the move, on Wednesday our house in Wyoming was placed under contract. That means that if all goes well, we should be moved in about four weeks. That leads me to the second big event this past week. The same day that the house went under contract was our 50th wedding anniversary. (Yes, I'm getting *that* old.) I count it a singular blessing to be able to spend my life with my love and my best friend. We are hoping that this move will help prolong our years together as time inexorably moves on. So, Wednesday was a rather significant day for us.

I will keep you up to date about the move, as there is still much to do to make the plan a reality.

My best to you and I hope you enjoy the tips in this week's newsletter.

—Allen
     

ExcelTips (menu) for 2 May 2026
Web publishing
Generating a Web Page

Want your worksheets to be available to others on the Internet? Excel provides a way you can save your data in HTML format, and it is as easy as saving your workbook in any other format.

Read this tip »

 
Files
CSV File Opens with Data in a Single Column

When you import a CSV file into an Excel worksheet, you may be surprised at how the program allocates the information among columns. This tip explains how Excel figures out what goes where.

Read this tip »

 
Serious about Sorting?

Organize your data in the order that makes sense to you. Excel's sorting tools make it easy to get at the data you need. Get a firm grip on sorting today and your data management tasks will be easier than ever!

 
Powerful spreadsheets
Turning Off Screen Updating

Want a quick way to speed up your macros? All you need to do is to stop Excel from updating the screen while the macro is running. Here's how to do it.

Read this tip »

 
Conditional formatting
Conditionally Formatting Non-Integers

The conditional formatting capabilities of Excel are very helpful when you want to call attention to different values according to criteria you specify. The hardest part of using conditional formatting is identifying which condition should be used. This tip examines the different ways you can specify a condition that differentiates between an integer and non-integer in a cell.

Read this tip »

     

Special Note!

I've been publishing ExcelTips for years. Decades, actually. The newsletter you are reading right now is for very old versions of Excel. I still publish it because I know that some people are still using very old versions of Excel. Most people, however, are using newer versions of the program. If you are are using a newer version of Excel (2007, 2010, 2013, 2016, 2019, 2021, or the version in Microsoft 365), then you should seriously consider changing to the version of the newsletter designed for you. You can do so by clicking this link.

Thanks for your support of ExcelTips, and I hope you enjoy whichever version of the newsletter you receive. If you have any questions, just let me know.

 
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