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.)

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.

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 »

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 »

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 »

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 »

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)