Supercharge Your Formatting

Earlier this week, on Tuesday, I released a new and updated edition of my Excel Custom Formats e-book. The e-book (which had not been updated in 2.5 years!) provides great information on how to create and modify custom formats for your data. Excel's custom formatting capabilities are often overlooked, even though they form the basis for all cell formatting in the program.

When I announced the newly updated edition, I also mentioned that it would be on sale for only two weeks. The sale allows you to get your own copy of the e-book (either as a download or on a CD-ROM at 30% off the regular price. If you want to save some money and get a great deal, you'll want to go check out Excel Custom Formats today. You can find information here:

    https://store.tips.net/T010132

Thanks for your continued support of ExcelTips.

—Allen
     

ExcelTips (menu) for 11 April 2026
Protecting worksheets
Unlocking a Worksheet with an Unknown Password

It is not unusual, in a corporate world, to be handed a worksheet whose source you don't know. If that worksheet is locked and you need to change it, then you become very interested in figuring out how to unlock the worksheet.

Read this tip »

 
Powerful spreadsheets
Calculating Monthly Interest Charges

Trying to calculate how much people owe you? If you charge interest or service charges on past-due accounts, there are a myriad of ways you can calculate balances. Here's a discussion on a few ways you can try.

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.

 
Filling cells
Working with Record Numbers

Want to keep track of various rows in a data table through the use of record numbers? Here are some options and considerations you should keep in mind.

Read this tip »

 
Spelling
Allowing for Words that Contain Numbers

When Excel does a spell-check of the information in a worksheet, you may want it to ignore words that contain numbers. All it takes is a simple change to the configuration options for the spell-checker.

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