Springtime in the Rockies

This past week has been interesting, when it comes to weather. On some days it has been warm, and other days it has been frigid with blowing snow. Sometimes it can even vary from hour to hour as little snow squalls blow through the area.

This is springtime in the Rockies, to be sure. (OK. Technically it isn't Spring yet, but you know what I mean.) The upshot is that you cannot know what to expect, and if you travel through the area this time of year, you can hope for the best but you need to plan for the worst.

I hope that your week has gone well and that you enjoy the tips in this week's newsletter.

—Allen
     

ExcelTips (menu) for 16 March 2024

Excel can calculate at lightening speed
Random Resetting of the Standard Toolbar

Excel allows you to easily customize what appears on its various toolbars. If you make customizations to the Standard toolbar and they disappear, you're not alone!

Read this tip »

 
Formulas
Referencing the Last Six Items in a Formula

If you have a list of data in a column, you may want to determine an average of whatever the last few items are in the column. This tip examines a couple of formulas you can use to calculate the average of the last six items in a data column, even if the number of items changes over time.

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
Last Saved Date in a Footer

When printing out a worksheet, you may want Excel to include, in the footer, the date the data was last saved. There is no easy way to include that information without using a macro. Here's how you can get the output you need.

Read this tip »

 
Tools
Searching a Workbook by Default

When you display the Find tab of the Find and Replace dialog box, you'll notice that any search, by default, will be on the current worksheet. If you want Excel to default to searching the entire workbook, you'll need to resort to a macro to accomplish the task.

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