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

##### 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.

##### 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.

##### 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 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.

##### 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.