Happy Independence Day

To those living in the United States, I hope you are having a great Independence Day. We are celebrating the holiday, but also attending a biannual family reunion today.

I hope you enjoy the tips in this issue of the newsletter.

—Allen
     

ExcelTips (ribbon) for 4 July 2015

Excel can calculate date in lightening time
Adjusting to a Maximum Row Height

Need to check the height of all the rows in a worksheet and then adjust them if a particular criterion is met? This tip provides a macro that checks the rows and adjusts row height if it is above a threshold.

Read this tip »

(Thanks to Michael Avidan (MVP), Kenneth Aschheim, Andrija Vrcan, John Vander Linden, Steve Aprahamian, Bob Beechey, Brian Lair, and Dave Kerr for contributing to this tip.)

 
Editing
Pulling Apart Cells

Separating text values in one cell into a group of other cells is a common need when dealing with text. Excel provides a handy tool that allows you to easily pull apart the cell values. Here's how to use it.

Read this tip »

(Thanks to Willy Vanhaelen for contributing to 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.

 
Macros extend Excel
Default Worksheet when Opening

When opening a workbook, you may want to make sure that a particular worksheet is always displayed first. The only way to ensure this is through the use of a macro, described here.

Read this tip »

 
Formulas
Counting Consecutive Negative Numbers

If you have a range of values that can be either positive or negative, you might wonder how to determine the largest consecutive sequence of negative numbers in the range. This can be done in a couple of ways, as described 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.

 
Returning Nothing If Two Values are Empty

I use a formula that references to cells, B1 and C1. All the formula does is to return the value of one of the cells, as in =IF(A1=1,IF(B1>C1,B1,C1)). Both B1 and C1 normally contain dates, but sometimes either or both of them may be empty. If they are both empty, the returned value (which is 0 because they are empty) shows up as 01/01/1900. When both cells are empty I would like the formula to return a blank value, not a 0. I'm at a loss as to how to modify my formula, though.
—Graham Arnold (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