Getting the Right Version?

Are you getting the right version of ExcelTips? If you are using Excel 97, 2000, 2002, or 2003, then you are getting what you should be getting--ExcelTips (menu). This version of ExcelTips covers all four of those versions of Excel.

However, if you are using a newer version of Excel (2007, 2010, 2013, 2016, 2019, or the version provided with Office 365/Microsoft 365) then you are NOT reading the newsletter that is geared toward your needs.

You see, I publish two versions of ExcelTips. The one already mentioned, ExcelTips (menu), is for the four older versions of Excel. The other one, ExcelTips (ribbon) is for users of the newest versions of Excel.

If it is time to update your subscription to match the version of Excel you are using, visit the following page to make the change:

I hope your weekend (and week) goes well!


ExcelTips (menu) for 24 July 2021

Understanding Auditing

Excel provides some great tools that can help you see the relationships between the formulas in your worksheets. These are known as auditing tools and are introduced in this tip.

Read this tip »

Printing Workbook Properties

Want to create a printed record of the properties associated with a workbook? There is no easy way to do it in Excel. Here's a macro, however, that you can use to create a worksheet that contains all your workbook properties.

Read this tip »

Supercharge Your Formatting

Want to change how your data looks based on criteria that you determine? It's easy to do using Excel's powerful conditional formatting features. Picture how you want your data to appear, then use conditional formatting to make it happen. Unleash the power of conditional formatting today.

Customizing Excel
Adding a Little Animation to Your Life

Tired of the same old boring Excel look? You can add some life to your worksheets by introducing some animation. Here's what Excel can do and how you can use this feature to add some excitement to your project.

Read this tip »

Powerful spreadsheets
Creating Scenarios

Excel allows you to create different scenarios for the data in your worksheet. These can be saved and managed using the Scenario Manager, as described in this tip.

Read this tip »

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  •  307-200-0450