Hair on Fire

It's been a rough two weeks, for more than one reason.

I told you near the end of April that we were moving in the near future. Well, the near future has arrived, and we moved out of our home at the first of this week. Today, however, we are at a family reunion in Texas. Then, tomorrow we high-tail it back to Wyoming so we can close on the sale on Monday.

Well, about a week or ten days ago, the hosting company for the Tips.Net websites decided they absolutely HAD to do an upgrade for security reasons. They took about 12-14 hours, during which the sites were down, and when they finished they said "check it out and let us know of any issues."

There were, of course, issues. Like email not working. Like commenting not working. Like back-end processes not working. Like database access not working. Like FTP not working. On and on and on. And they were quite slow in getting things fixed.

The bottom line is that if you tried to email me a solution to last week's Help Wanted questions, there's a good chance I didn't get it. Because I wasn't getting anything! All in the middle of trying to pack up the house and a business.

As everyone knows, there are only 24 hours in a day. Sometimes a perfect storm happens, and you still need to try to get through everything in those 24 hours. There were days I was no fun to be around, I know.

I'm hoping, at this point, that things are pretty well back to normal, at least as far as my hosted servers are concerned. I guess that only time will tell, but this go-round all the hair-on-fire issues will be happening as we move into our new house this next week.

I honestly mean it when I say that I hope you've had a good week. I hope you also enjoy the tips in this week's newsletter.

—Allen
     

ExcelTips (menu) for 6 June 2026

Online collaboration
Refreshing Web Discussions

How to refresh the Discussions screen to ensure all comments are visible.

Read this tip »

 
AutoCorrect
Using AutoCorrect

The AutoCorrect feature in Excel is a great tool for quickly entering information. Here's an explanation of the feature and a quick overview of how to use it.

Read this tip »

 
Enhance Your Excel Skills with Macros

Macros are a great way to increase your productivity with Excel by making the program work the way you want it to work. Discover the true power behind macros; ExcelTips: The Macros puts almost 800 pages of macro-focused information at your fingertips. Discover more...

 
Formulas
Condensing Sequential Values to a Single Row

If you have a bunch of ZIP Codes or part numbers in a list, you may want to "condense" the list so that sequential series of numbers are shown as a range. There are a number of ways this can be accomplished.

Read this tip »

 
Excel can calculate at lightening speed
Drop-Down List Font Sizes

Excel has several features that cannot be customized. The font size in the drop-down lists is one of them. If you need make changes to this, however, there is a potential workaround. This tip explains more.

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