Is ExcelTips Valuable to You?

There are a lot of resources available these days for people who use Excel. You can find websites, YouTube videos, and even other newsletters. To my knowledge, ExcelTips has been around longer than any other Excel resource on the Internet. (I've been publishing the newsletter since 1998.)

The point is, if you know others who use Excel, I think they could benefit by the decades of knowledge and experience available in the ExcelTips newsletter. They will never know about ExcelTips, though, unless YOU let them know. Do them (and me) a favor and help spread the word about the value that you see in ExcelTips. Simply direct them to the website:

   http://excelribbon.tips.net

Let them know that they can sign up for the newsletter using the form at the right side of any page on the site.

—Allen
     

ExcelTips (menu) for 20 September 2025

Printing
Repeating Rows on a Printout Except On the Last Page

When setting up a worksheet for printing, you can specify that Excel repeat some of your rows at the top of each page printed. If you want to have the repeating occur on every page except the last, then you will need to use a macro to do the printing.

Read this tip »

 
Excel can calculate at lightening speed
Viewing Your Work Full-Screen

Want to use the maximum space possible for displaying information on screen? You'll want to learn how to use the full-screen display mode of Excel, then.

Read this tip »

 
Formatting Made Powerful

Discover one of the foundational building blocks of Excel. Custom formats are the basis for all cell-level formatting in Excel, and you can master their use. Display your data exactly and precisely as you want.

 
Date formulas
Converting European Dates to US Dates

Those in Europe use a date format that is different than those in the US; this is not news. But what if you need to convert those European dates to US dates? There are several ways you can make the conversion, depending on your needs.

Read this tip »

 
Tools
Understanding Outlining

Outlining, a feature built into Excel, can be a great way to help organize large amounts of data. This tip provides an overview to the feature, focusing on different ways you can create your outline.

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