Travel Season

I've got lots of trip-related news this week. If you've been reading the last few issues of the newsletter, you know that I just completed a long road trip across ten states. I put together a short video, less than five minutes, about this trip. You can find it here:

https://youtu.be/RQsmD8hC_1o

As for other trips, I'm on one right now. It has been a few months since I've been down to see my father, sister, and aunt. So, a few days ago I headed down to Texas. I brought one of my granddaughters with me, and we arrived yesterday. Everyone seems to be doing well, and we'll be heading back home this coming Wednesday.

Finally, there is one piece of Excel-related news I need to share with you. Earlier this past week, on Wednesday, I opened the doors to my course about how to slice, dice, and otherwise analyze your data using PivotTables, PivotCharts, slicers, and timelines. This is a great course that won't put a huge dent in your budget. (Right now you can register for as little as $74!)

This is the only time I'm offering this course this year, so you'll want to check it out soon. Full information is here:

https://usingoffice.com/pivottables/

Why not take the opportunity to enhance how you use Excel? This is a great way to discover how to use these tools that can enhance how you use the program.

I hope you enjoy the tips in this week's newsletter.

—Allen

ExcelTips (ribbon) for 6 September 2025

Removing Some Hyperlinks

Removing hyperlinks from cells one at a time can be tedious. If you want to remove hyperlinks from a group of selected cells, then you'll love the two quick approaches in this tip.

Read this tip »

(Thanks to Michael Avidan (MVP), Ryszard Raciborski, Andrija Vrcan, Brian Dorey, Kathy Brancato, Alan Cannon, and Wm Field for contributing to this tip.)

Missing PivotTable Data

Wonder what happened to the data behind a PivotTable? It could be in a number of places, and tracking it down could be a challenge. Here are a few ideas.

Read this tip »

Making Sense of Times and Dates

One of Excel's great strengths is its ability to work with huge amounts of raw data. Two of the most common types of data stored in Excel are times and dates. Working with these special data types is not as easy as it may first seem. Check out ExcelTips: Times and Dates and learn the secrets of working with your times and dates.

Understanding Custom Chart Templates

Excel allows you to create custom chart formats that go beyond the standard formats provided in the program. These custom formats can then be saved in templates that you can apply to future chart-creating endeavors. Here's how to create and save your custom chart templates.

Read this tip »

Converting Numbers to Strings

When creating macros, it is often necessary to change from one type of data to another. Here's how you can change from a numeric data type to a string data type.

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.

Removing All Formatting in a Worksheet

I have a workbook that has been in use in my company for years, and now I've inherited it. I don't like the formatting that has been applied in the worksheets. Is there a quick way to remove all cell formatting from a worksheet, without affecting cell content, so that I can make the data look decent?
—Dennis Polson (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