Waning Summer

In our corner of the world, summer is quickly drawing to a close, although you couldn't tell it by our temperatures over the past week. Days are still long (though getting shorter) and temperatures are still very agreeable. In our area, school bells started ringing again this past week, which is a sure signal that summer is drawing to a close.

I know it is not summer for everyone; I had one reader about a week ago take exception with me talking about summer when he (in the Southern hemisphere) was looking at snow out of his window. I cannot address the experiences of all readers in this portion of the newsletter, so I choose to address MY experiences; what is going on in my corner of the world. (Well, that and to let folks know of other things in which they might be interested.)

Anyway, whatever the season or conditions where you find yourself, I hope you enjoy the tips in this week's issue of the newsletter.

—Allen
     

ExcelTips (menu) for 24 August 2019

Powerful spreadsheets
Creating Long Page Footers

Ever wish that you could create nice, long footers that appear at the bottom of each page when you print your worksheet? Excel is lacking a bit in this capability, but there are ways you can get around the limitation.

Read this tip »

 
Time formulas
Displaying a Result as Minutes and Seconds

When you use a formula to come up with a result that you want displayed as a time, it can be tricky figuring out how to get the display you need. This tip explains how you can convert your formula's result to get just what you want.

Read this tip »

 
Pay a Visit to Formville

Need invoices, statements, receipts, applications, and hundreds of other business forms you can put to use right away? How about if you can get those forms for free? Discover what awaits you in Formville, your destination for free printable business forms.

 
Workbooks
Opening Two Workbooks with the Same Name

If you have two workbooks that each have the same name, opening them at the same time in Excel could cause some problems. This tip examines why this is so and provides some ideas on how to get around the problems.

Read this tip »

 
Sorting
Non-standard Sorting

Information in a cell can be entered using line feeds, which results in multiple lines of data in the same cell. If you later want to sort that information, there are a couple of ways you can approach the problem.

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