Hectic Times at the Wyatt Household

I'm looking at the calendar (as I periodically do) and notice that time is just whipping by. Our oldest grandson graduated yesterday, and we are heading into the last week of school for most of the kids in our area. This is a hectic time of year, and it is no different around the Wyatt household.

Also, I hope you had the opportunity to check out Mynda Treacy's dashboard course. I sent you an e-mail about it a few days ago, and she will be closing the doors on the course in less than a week. (I'll send out a reminder e-mail about that a day or so before the actual closing.)

To add to the "hecticness" of the season, I'm in the middle of getting things ready to once again accept new registrants into my Excel Macros for Beginners course. It isn't that long until the doors on the course open--the target is June 7. I'll keep you informed about that as we get closer to the date.

If things are just as hectic around your home as there are around mine, I wish you much success in dealing with the work and hope you are having a great time!

—Allen
     

ExcelTips (ribbon) for 21 May 2016

Excel can calculate date in lightening time
Displaying a PivotTable's Name in the PivotTable

When you create a PivotTable, it can have a name. You may want this name to appear within the PivotTable itself. There is no automatic way to do this, but this tip provides a couple of ways you can work around this limitation.

Read this tip »

(Thanks to Al Rurenga and Ted Hook for contributing to this tip.)

 
Customizing Excel
Displaying Page Breaks

Page breaks can be added to a worksheet manually or automatically. If you want to see where Excel places page breaks, you'll want to pay attention to this configuration tip.

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.

 
Powerful spreadsheets
Hiding a Huge Number of Rows

Need to hide a large number of rows? It's easy to do if you combine a few keyboard shortcuts. Here are several techniques you can use.

Read this tip »

 
Macros extend Excel
Using the Status Bar

When developing a macro, you may want to display on the status bar what the macro is doing. Here's how to use this important screen area and the macro commands that enable that use.

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.

 
Replacing in Worksheets and Comments At the Same Time

My students are customizing a checkbook simulation workbook, replacing the default name with their own. For example, I want them to search for "Jason Anderson" and replace the name with "Sue Smith." There are 22 occurrences of "Jason Anderson" in text boxes throughout eight worksheet tabs, and several more on the worksheets themselves. How can I Find and Replace all worksheet occurrences and all comment occurrences at once?
—Dorothy Etzler (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