Don't Miss the Archives

This past week I released the ExcelTips Ribbon 2025 archive. Be sure to check it out, as it contains every single tip published during the last year--hundreds of pages of information! This is all packaged in a handy archive you can search, sort, print, and slice or dice any way you want.

The ExcelTips Ribbon 2025 archive contains more information than I can list here, but it is worthy of your consideration. I should mention, however, that in celebration of the release of this year's archive, you can get any of the available ExcelTips archives--from 2021 through 2025--for 30% off the regular price! This means you can get a download of the full year for only $17.49! This is a limited-time offer (good only through January 21), so you should check it out very soon. You can get the full details here:

https://store.tips.net/T009970

Thanks for your support of ExcelTips.

—Allen
     

ExcelTips (ribbon) for 10 January 2026
Formulas
Returning the Final Word

When processing text in a workbook, you may need to grab the last word in a cell. There are a few ways that you can do the grabbing, as described in this tip.

Read this tip »

(Thanks to Jos Graindor, Steve Aprahamian, Ryszard Raciborski, Brian Dorey, James Woolley, Kevin Keyser, Alan Cannon, Jacques Raubenheimer, Andrew Gray, Michael Avidan (MVP), Thomas Reeves, Julie Faas, and Steven Morgenstern for contributing to this tip.)

 
Charts and charting
Deleting a Chart

Charts serve a purpose, and sometimes that purpose is temporary. If you want to get rid of a chart, here's how to do it.

Read this tip »

 
Serious about Sorting?

Organize your data in the order that makes sense to you. Excel's sorting tools make it easy to get at the data you need. Get a firm grip on sorting today and your data management tasks will be easier than ever!

 
Workbooks
Opening Two Workbooks at Once

Do you work with a group of workbooks all the time in Excel? Windows and Excel both provide a plethora of ways you can open both workbooks at the same time.

Read this tip »

 
Macros extend Excel
Creating a Plus/Minus Button

Want a quick way to convert positive values to negative and vice versa? You can create your own plus/minus button by using a small macro.

Read this tip »

(Thanks to Fernando Ramos for contributing to 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.

 
Stopping Email Addresses from Activating

I have hundreds of workbooks, each for a project we are or have worked on. they contain, among other information, email addresses. Occasionally Excel will convert these addresses to hyperlinks so that when I click on the cell it opens an email. How can I stop Excel from doing this?
—David Manns (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