Pausing and Reflecting

This past week around the Wyatt household has been rather quiet. Perhaps the highlight of the week was our attendance at a 9/11 memorial service this last Wednesday. The event is held annually in our valley. It gave all of us pause to think back 23 years to where we were on the day that the world changed.

I say that ("the day that the world changed") knowing full well that there seem to be many such world-changing moments in life. I can remember where I was when John Kennedy was shot, when the Challenger space shuttle exploded, when Ronald Regan was shot, and on and on. Those in other generations, no doubt can remember their own set of memorable events. Each life is marked and measured, it seems, by such moments.

I don't mean to be inordinately somber or morose. Still, it was good to pause, reflect, and ponder. It helps me to give perspective to the world and to life.

I hope that you take the opportunity to pause and reflect in your own life. I likewise hope that you find the tips in this week's issue of the newsletter to be helpful.

—Allen
     

ExcelTips (ribbon) for 14 September 2024
Time formulas
Taking the Time into Account in a Formula

Need to check the current time in a formula you are putting together? It can sometimes be tricky to remember what Excel considers as the time and how you should work with it. Here is some guidance on the topic.

Read this tip »

 
Graphics
Hiding Graphics when Filtering

Excel allows you to set up graphics so that they are associated with cells and even stay with the cells when the cells are sorted. But what about when you filter the list? Here's how to make sure that the graphics are no longer visible when the list is filtered.

Read this tip »

 
Are You Foundering at Filtering?

We have all experienced the frustration inherent with using Excel filters. Stop foundering when filtering your data by getting your copy of ExcelTips: Filters and Filtering today. More info available online.

 
Sorting
Sorting Letters and Numbers

Sorting information in a worksheet can be confusing when Excel applies sorting rules of which you are unaware. This is especially true when you are sorting a mixture of letters and numbers.

Read this tip »

 
Printing
Specifying Print Quantity in a Cell

When you print a worksheet, you can specify in the Print dialog box how many copies you want printed. If you want the print quantity to be based on the value entered in a cell, instead, then you'll need to use one of the macro approaches 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.

 
Shortening Worksheet Tabs

I have a workbook in which the worksheet names are long, averaging about 22 characters or so. This makes the worksheet tabs quite wide, and Excel shows the entire name in the tabs. Of course, this makes it difficult to navigate from sheet to sheet using the tabs. Is there a way to specify a maximum width for the worksheet tabs so I can see more tabs in the workbook at one time?
—Thomas Paine (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