Excitement Abounds!

Yesterday was the end of the school year for our town, and it won't be long until all the schools are recessed for summer break. (Well, except for those districts that implement year-round school. For them there is no summer break!)

People are busy right now making plans for the summer, and vacations will soon be here along with trips to visit friends and relatives. Temperatures (at least near here) are more moderate and daylight is more plentiful. In other words, it is a great, exciting time of the year.

I hope you have some great plans this summer and that you are able to achieve them.

—Allen
     

ExcelTips (ribbon) for 30 May 2015

Worksheets
Referencing Worksheet Tabs

Ever want to use the name of a worksheet tab within a cell? Here's how you can access that information using the CELL function.

Read this tip »

 
Charts and charting
Selecting Fonts for a Chart

When formatting a chart, you might want to change the characteristics of the font used in various chart elements. This can be easily done, but the exact steps depend on the version of Excel you are using.

Read this tip »

 
Still Can?t Use Excel Macros to Make Work Easier?

If you want to learn macros to complete assignments faster and very accurately, but can?t get started, this practical VBA training reveals how Excel VBA truly works, in a non-programming way and in only 3 simple lessons (still absolutely free). CLICK HERE!

 
Macros extend Excel
Running a Macro when a Worksheet is Deactivated

When you change from one worksheet to another, you may want to have Excel automatically run a macro for the worksheet you are leaving. You can easily create such a macro by using the Auto_Deactivate event.

Read this tip »

 
Data Validation
Changing Fonts in Data Validation Drop-Down Lists

The data validation capabilities of Excel allow you to easily create drop-down lists showing what data is acceptable for a particular cell. If you want to change which font Excel uses in the drop-down list, you're out of luck.

Read this tip »

 
     

Help Wanted

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.

 
Filtering for Purchases within a Given Month

I have a worksheet that contains sales information consisting of customer names (column A) and purchase date (column B). I need to filter the list so that I can see customers who have purchased exactly X times within a given calendar month, where X is a value such as 1, 2, etc. Is there a way to do this using the built-in filtering, or is another approach better?
—Anand Karpe (provide an answer for this Help Wanted question)

 
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 794  •  Orem, UT  84059  •  801-607-2035