Doors will Open Soon

I've had some folks ask when I'm going to again open the doors to my Excel Macros for Beginners course. The last time I did so was before the holidays, and now that the holidays are over, I know many of you are chomping at the bit to accomplish that New Year's resolution to finally figure out how to create and use macros.

So you can keep your eyes peeled, my plan right now is to again open the doors on March 1. I'll send out a special announcement when that time rolls around, as I don't want you to miss the opportunity.

Until then, I hope you enjoy the tips in this week's issue of the newsletter.

—Allen
     

ExcelTips (ribbon) for 6 February 2016

Column formatting
Widening Multiple Columns Proportionally

It is easy to adjust the width of columns in Excel. It is much harder to adjust the width of a range of columns proportionally. This tip provides a macro that can make the proportional adjustment easy.

Read this tip »

(Thanks to Michael Avidan (MVP) and Bob Beechey for contributing to this tip.)

 
Excel can calculate date in lightening time
Setting Page Margins

When getting ready to print your worksheet, you may want to take a moment to check what margins Excel will use on the printout. The program makes it easy to modify the margins of your printed page.

Read this tip »

 
ExcelTips at Your Fingertips

Support ExcelTips and obtain a valuable resource—your own copies of the ExcelTips archives. Each archive contains all the tips for a calendar year; often over 500 pages of detailed info on how to better use Excel. Learn more about Excel today!

 
Worksheets
Returning a Worksheet Name

Need to know the name of the current worksheet? You can use the CELL function as the basis for finding this information and putting it in a cell.

Read this tip »

(Thanks to Michael Avidan (MVP) for helping with this tip.)

 
Editing
Inserting a Radical Symbol

The radical symbol is used frequently in some branches of mathematics. If you want to insert a radical symbol in a cell, here's how to go about it.

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.

 
Getting a Conditional Count of Cells Containing Values

The formula =SUMIF(B1:B100,"Current",D1:D100) provides the sum of the values in column D, provided the corresponding cell in column B contains the text "Current". What I actually need is a count of the values in column D when column B contains "Current". (The count of values in D may well be different than the number of instances of "Current" in B.) I wish it was a simple as changing SUMIF to COUNTIF, but that produces an error.
—Kenneth Bachelor (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