Thank You!

I just want to give a shout-out to those who are working in criticial positions, helping the rest of us get through the problems we are facing. I was in my local well-picked-over grocery store today, and the workers there were trying to go about their jobs under difficult circumstances. I stopped into a local urgent care facility a couple of days ago, and the workers there were battling just as valiantly as they could.

I could name off dozens of other jobs where people are trying to help in the best ways they can. I find their efforts heartening, and I appreciate all they are doing. Thank you, each and every one.

That being said, I also know that huge swaths of the world are either working from home or newly unemployed. If you are one of those who are working from home, I know that figuring out how to do that work can be a challenge. (I know, as I've been a work-at-home type of guy for large segments of my life.) It can be difficult to figure out how to do the work you need to get done when you are not in familiar surroundings, and it can be an even bigger difficulty when you have family vying for your attention.

As I mentioned last week, by plan is to keep on providing my newsletters and, thereby, hopefully bring a bit of normalcy (or normality, if you prefer) into your inbox. I've had multiple readers let me know that they look forward to the newsletters more than ever right now, as they are using this time to expand what they can do with Excel. I appreciate those sentiments.

Whatever challenges you are facing, I hope you are finding productive ways to face them with grace and aplomb.

—Allen
     

ExcelTips (ribbon) for 28 March 2020

Macros extend Excel
Creating an Animated Count Up

You might want to display a value in a cell as an upward-counting value. This might seem difficult but can be done rather easily with a macro. This tip looks at a couple of approaches you can use.

Read this tip »

(Thanks to Steve Aprahamian, Alan Cannon, Ryszard Raciborski, Wayne Edmondson, Bob Beechey, Eric Nordby, Ben Davies, Ronald Doeleman, James Woolley, and Marc Mouillard for contributing to this tip.)

 
Printing
Printing Rows Conditionally

Need to only print out certain rows from your data? It's easy to do if you apply the filtering or sorting techniques presented in this tip.

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!

 
Date formulas
Calculating Week-Ending Dates

When working with dates, you may need to figure out all the dates on which weeks end in a given year. There are several formulaic ways to accomplish this task, as described in this tip.

Read this tip »

 
Worksheets
Condensing Multiple Worksheets Into One

Want a quick way to combine your worksheets? This tip features a simple macro to do the task for you.

Read this tip »

 
Formulas
Counting Cells Containing a Formula

Cells in a worksheet can contain different types of information, such as numbers, text, and formulas. If you want to determine the number of cells in a range that contain the latter type of information (formulas), then this tip provides several techniques you can use.

Read this tip »

 
Time formulas
Automatically Entering a Data Entry Time

Excel worksheets can be used to keep track of all sorts of information. You may want to use it, for instance, to track entries made at specific times. Here are ways to "time stamp" your entries automatically.

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.

 
Entering Characters with Diacritical Marks

I frequently need to type letters that use diacritics. For instance, if I want to enter an A with an umlaut over it, I can do this in Word or Outlook using Ctrl+: (colon) followed by the letter A. This won't work in Excel, however. How can I enter the diacritics I need, in Excel, using keyboard shortcuts?
—David Fournier (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