Hot, Hot Weather

Those who have been reading this newsletter for more than a couple of months will remember that we moved about a month ago, this time to a small southern Nevada town right on the Arizona border. One of the non-unique distinguishing features of the town is that it is hot (very hot) because it is part of the Mojave Desert.

What do I mean by hot? Well, today it got up to 111 degrees (F), but that's a temperate summer day. On really hot summer days it gets closer to 120 degrees.

We've lived in hot locations before, having lived in Mesa, Arizona, over two decades ago. I don't mind the heat, as air conditioning is a wonderful invention. It is just as essential for survival as is heat during the winter in other areas of the country.

Anyway, we are quickly adapting back to our "hot weather selves," enjoying all the area has to offer. Plus, our expectations for my wife's health are being realized, which was the primary reason for choosing to move here.

I hope that you enjoy the tips in this week's newsletter.

—Allen
     

ExcelTips (menu) for 11 July 2026
Powerful spreadsheets
Unprotecting Groups of Worksheets

Unprotecting a single worksheet is relatively easy. Unprotecting a whole lot of worksheets is harder. Here's how you can make the task simpler.

Read this tip »

 
Deleting
Conditionally Deleting Rows

Want to delete a bunch of rows in a worksheet based on the value in a certain cell of each row? There are a couple of ways you can approach the problem, as discussed in this tip.

Read this tip »

 
Journal Your Life

Journals go by many names--diaries, sketchbooks, or simply blank books. Regardless of the name, though, journals provide a way for you to record, track, create, dream, and illustrate your life. Journals make it not only possible, but easy. Check out our complete line of high-quality, convenient journals today!

 
Powerful spreadsheets
Automating Copying Macros

You can manually copy macros from one workbook to another, but what if you want to automate the copying process? Here's some ideas you can try out.

Read this tip »

 
Files
Jumping Around Folders

When you open a workbook in Excel, the Open dialog box always starts within the folder in which you were last working. You can use this to your advantage when working in multiple folders, as illustrated in this tip.

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