Opening Workbooks at Startup

Each time you start Excel, you may want to have the program load one or more workbooks automatically. Excel provides two ways you can accomplish this goal, as discussed in this tip.

Read this tip »

(Thanks to Alec Whatmough, Graham Rice, Steve Aprahamian, Ryszard Raciborski, Michael Avidan (MVP), Alan Cannon, Ira Bernstein, Greg Presnall, Stephen Farrell, Brian Dorey, and Tomek Dluzniewski for contributing to this tip.)

Alphabetic Column Designation

Want to know the letters assigned by Excel to a particular column? Excel normally deals with column numbers, but you can translate those numbers into the corresponding alphabetic column designations.

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!

Adjusting Times for Time Zones

Collect a series of times in a worksheet, and you might need to adjust those times for various time zones. This involves a simple math operation, as described in this tip.

Read this tip »

Opening a Workbook and Suppressing Automatic Macros

Want to stop Excel from running any automatic macros that may be stored with a workbook? Here's how to do it.

Read this tip »

This section is for those having problems making Excel behave. If Excel is giving you fits, feel free to submit your own Help Wanted question.

If you have a solution for the problems below, click the link after the problem to send us your answer. (All responses become the sole property of Sharon Parq Associates, Inc., and can be used in any way deemed appropriate.) If your response is used in a future issue, you will be credited for your contribution to the answer.

Most Frequent Value in a Column

I have a worksheet that contains readings from our production process. These readings are in column D of the worksheet, and there can be several thousand of them on a daily basis. The readings are always positive integer values. I need to know what reading most frequently occurs in the column. I would like to know what the reading is and how many occurrences there are for that reading.
—Barry Lasson (provide an answer for this Help Wanted question)