Having a Good Week

I hope that things are going well in your corner of the world. Here, in the Wyatt corner, things have been buzzing just a bit, as I've dealt with an influx of new students in a course I prepared for Microsoft Word users. (It's a good "busy," though, as I enjoy helping people out.)

Speaking of courses, I'm thinking of opening the doors to my Excel Macros Master Class again in the near future. There are still a few logistical issues I need to deal with, but I hope to get those ironed out in due course. If I do decide to open the doors (or, I should say, *when* I decide to open the doors) I'll let you know.

I hope you enjoy the tips in this week's newsletter and that you have a great week.

—Allen
     

ExcelTips (ribbon) for 16 February 2019

Macros extend Excel
Pulling First Letters from Parenthetical Text

When working with text in Excel, you can slice and dice it in many ways. This tip shows how to pull first letters from within parenthetical text in a cell.

Read this tip »

(Thanks to Steve Aprahamian, Harold Druss, Joe Smith, Patrick Sedgwick, James Woolley, Ryszard Raciborski, Joe Malfesi, Dennis Riddle, Bob Beechey, David Gray, Wayne Edmondson, Philip Webb, Jan Martens, and Andrija Vrcan for contributing to this tip.)

 
Powerful spreadsheets
Understanding R1C1 References

Referring to cells is typically done using a letter and a number, which represent the column and row. That's not the only way that Excel can refer to cells, however. Here's an alternative method of designating cell references.

Read this tip »

 
Supercharge Your Formatting

Want to change how your data looks based on criteria that you determine? It's easy to do using Excel's powerful conditional formatting features. Picture how you want your data to appear, then use conditional formatting to make it happen. Unleash the power of conditional formatting today.

 
Date formulas
Ages in Years and Months

Calculating an age is a common task when working with dates. If you want to figure out the number of years and months between two dates, you'll appreciate the discussion in this tip.

Read this tip »

 
Powerful spreadsheets
Creating Scenarios

Excel allows you to create different scenarios for the data in your worksheet. These can be saved and managed using the Scenario Manager, as described in this tip.

Read this tip »

 
Macros extend Excel
Understanding Macros

What is a macro? Ever wonder what these are and how to use them? This tip answers the basics of what a macro is used for, different ways you can create them, and where they can be stored.

Read this tip »

 
Formulas
Listing Combinations

You can easily use the COMBIN worksheet function to determine the number of combinations that can be made from a given number of digits. However, you might want a way to enumerate all those combinations. This can be easily done using the macros presented in this tip.

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.

 
Executing a Macro After Printing is Done

I have a macro that hides some rows in a worksheet and then prints the worksheet. To do this I use the BeforePrint event handler. The problem is, I want to unhide the rows automatically after the printing is completed. How would I do this?
—Franklin Chott (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 1187  •  Mountain View, WY  82939  •  307-200-0450