Playing Catch-up

This past week has been rather busy. We returned from Arizona (finally!) on Wednesday, but we were a bit under the weather with coughs and colds. While trying to fight that off and catch up on sleep, I also had the need to get caught up on work that was delayed while I was traveling.

I *think* I'm mostly caught up, but it seems that just about every time I turn around, I find another thing needing attention. (Perhaps I won't truly be caught up until Monday or Tuesday. Who knows!)

Anyway, I hope your weekend is going well and that you enjoy the tips in this week's newsletter.

—Allen
     

ExcelTips (ribbon) for 22 April 2017

Powerful spreadsheets
Making Pane Settings Persist

When you freeze panes in a worksheet, those panes should persist even though you save the workbook and reload it. There could be any number of reasons as to why they aren't persisting, however. This tip provides some ideas on how to address the problem.

Read this tip »

(Thanks to Tony Davis, Roger Morehouse, Brian Lair, Allen Cody, Janice Cope, Gayle Larson, Alec Whatmough, and Don Wilcox for contributing to this tip.)

 
Date formulas
End-of-Month Calculations

Don't want to use the EOMONTH function to figure out the end of a given month? Here are some other ideas for discovering the date you need.

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 »

 
Powerful spreadsheets
Odd Arrow Key Behavior

Press the up or down arrow keys, and you expect Excel to change which cell is selected. If this doesn't occur on your worksheet, it could be due to a simple inadvertent keypress on the keyboard.

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.

 
Mimicing Small Caps in Excel

I would like to mimic the "small caps" capability of Word within Excel. The only way I can think to do this is to develop a macro that will step through every character in a cell. If the character is lowercase and 11 pt, then the macro should change the character to uppercase 9 pt. If the character is uppercase (or not a letter), then it should not be affected. Problem is, I don't know how to affect the formatting of individual characters in the cell in the manner described.
—Conrad Lowther (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