Visiting the Old Stomping Grounds

I hope your week went well and that you are enjoying your weekend. I'm spending mine in my old stomping grounds in Sundance, Wyoming. (Yes, it is where the Sundance Kid got his moniker.) I was invited to conduct a Microsoft Word workshop for a writers' group there, a group of which I used to be a member. (Very fond memories all around.)

While I'm thinking of it, would you mind suggesting to a friend, coworker, or family member that he or she (or they) sign up for ExcelTips? Subscriptions are free, and hopefully you can speak kindly as to the value of the newsletter. Feel to pass along this copy of the newsletter along with your recommendation.

Anyway, I'm off again to another session of the workshop. Enjoy the newsletter!

—Allen
     

ExcelTips (menu) for 25 January 2020
Powerful spreadsheets
Using the COLUMN Function

Need to know the column number for use in a formula? The worksheet function you want is the COLUMN function, described in this tip.

Read this tip »

 
Cell formatting
Changing Cell Colors

If you need to change the color with which a particular cell is filled, the easier method is to use the Fill Color tool, as described in this tip. That isn't the only way to fill cells, however.

Read this tip »

 
Macros! Macros! Get Your Macros Here!

Learn all the best methods for creating and using Excel macros. ExcelTips: The Macros is the best single source for learning about macros or improving your existing skills. Be the person everyone looks to when something needs to happen in Excel. Get yours today!

 
Time formulas
Converting Numeric Values to Times

If you have a bunch of times entered into cells without the colon between the hours and minutes, chances are good that Excel interpreted the time as a numeric value. If you later want to convert those values into real times that Excel can understand, you'll appreciate this tip.

Read this tip »

 
Comments
Printing Comments

Comments can be a boon when you want to annotate your worksheets. If you want, you can instruct Excel to print the comments right along with the worksheet itself. Here's how to instruct Excel to include them.

Read this tip »

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