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. It contains tips specifically related to Excel 2007 through Excel 365. (If you are only using Excel 2003 or an older version, then this archive won't be a good fit for you.)

I should also mention 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 (menu) for 10 January 2026
Macros extend Excel
Generating Unique Numbers for Worksheets

You may need to automatically generate unique numbers when you create new worksheets in a workbook. Here's a couple of easy ways to do it.

Read this tip »

 
Macros extend Excel
Creating and Naming a Worksheet Using a Macro

You can use macros to make your common Excel tasks easier and faster. For instance, if you routinely need to create new worksheets based on an existing worksheet, you might want to use a macro to perform the task. Here's a couple of suggestions for just such a macro.

Read this tip »

 
Baffled by Array Formulas?

Have you heard about the special array formulas you can create in Excel? They make it a snap to perform calculations using large amounts of data and even generate results you can't get with regular formulas. Array formulas may be Excel's best-kept secret. Remove the confusion; discover how to use array formulas today.

 
Online collaboration
Printing Web Discussions

If you are using the Web discussions feature built into some versions of Excel, you may want to print out a discussion at some point. It is easy to do if you follow the four steps in this tip.

Read this tip »

 
Macros extend Excel
Automatically Opening Macro Workbooks when Using a Shortcut Key

Click a button on a toolbar and Excel will go so far as to open a another workbook in order to run a macro associated with the button. Excel is not as accommodating when running a macro associated with a shortcut key. Here's the reason why and what you can do to get around this apparent shortcoming.

Read this tip »

     

Special Note!

I've been publishing ExcelTips for years. Decades, actually. The newsletter you are reading right now is for very old versions of Excel. I still publish it because I know that some people are still using very old versions of Excel. Most people, however, are using newer versions of the program. If you are are using a newer version of Excel (2007, 2010, 2013, 2016, 2019, 2021, or the version in Microsoft 365), then you should seriously consider changing to the version of the newsletter designed for you. You can do so by clicking this link.

Thanks for your support of ExcelTips, and I hope you enjoy whichever version of the newsletter you receive. If you have any questions, just let me know.

 
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