Boxes, Boxes, and More Boxes

The saga of unpacking the boxes in the new house continues. I've come to believe that the number of boxes multiplied during the move. (You never know what those boxes are doing in the dark!) It seems that every time we turn around, there is another box to unpack and stow in its final position. I think we will get done with it all, but it may take six months (or more).

I hope that you are doing well in your corner of the world and that you enjoy the tips in this week's newsletter.

—Allen
     

ExcelTips (ribbon) for 20 June 2026
Comments
Adding Footnotes to a Report

Do you want to add footnotes to a report you create in Excel? You may be out of luck, but there are a few workarounds you can try.

Read this tip »

(Thanks to Ira Bernstein, Michael Avidan (MVP), Jim Comin, and Dick Downey for contributing to this tip.)

 
Drawing objects
Flipping a Drawing Object

Don't like the way a drawing object looks? Perhaps flipping the object could help appearances. Excel allows you to flip drawing objects either horizontally or vertically.

Read this tip »

 
Journal Your Life

Journals go by many names--diaries, sketchbooks, or simply blank books. Regardless of the name, though, journals provide a way for you to record, track, create, dream, and illustrate your life. Journals make it not only possible, but easy. Check out our complete line of high-quality, convenient journals today!

 
Editing
Entering Data as Thousands

There are many different ways you may need to enter data in a worksheet. For instance, you might want to enter data in thousands, without the need to type the trailing zeroes. This tip examines several ways you can enter this type of data easily.

Read this tip »

 
Tools
Creating Add-Ins

Want to create your own add-in? Excel makes it easy to do. Here are all the steps you need.

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.

 
Calculating an Average of Visible Cells

I routinely filter data in a worksheet based on various criteria. I would like to calculate an average of the visible values in column C. In other words, when I filter the data, I want the average of what is visible in column C after the filter is applied. I tried the AVERAGE function, but it seems to apply to all cells in column C regardless of their visibility.
—Gary Jensen (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