Have you let your friends, relatives, neighbors, students, or coworkers know about ExcelTips? If not, why not give it some thought and drop them a line. Let them know what ExcelTips has done for you, and invite them to visit the ExcelTips website:

http://excelribbon.tips.net

Once there, they can sign up for their own copy of the newsletter; the sign-up form is at the right side of any page.

Thanks for your continued support of ExcelTips.

—Allen

ExcelTips (menu) for 16 May 2026

Switching Editing Location

Excel allows you to edit the contents of a cell in two places—the cell itself or in the Formula bar. If you want to switch from one place to the other while you are editing, you'll need to rely on the mouse.

Read this tip »

Adding Borders to Cells

Excel makes it easy to add all sorts of lines around a cell or range of cells. How easy? This tip demonstrates how to add just the borders you want.

Read this tip »

ExcelTips at Your Fingertips

Support ExcelTips and obtain a valuable resource—your own copies of the ExcelTips archives. Each archive contains all the tips for a calendar year; often over 400 pages of detailed info on how to better use Excel. Learn more about Excel today!

Entering Dates without Separators

When doing data entry into a worksheet, you might want to enter dates without the need to type the separators that are normally part of those dates. Here's a discussion on how this can be done in Excel, along with the benefits and drawbacks of using such an approach.

Read this tip »

Finding Rows with Values in Two Columns

When you use Excel to input and store information, you need to be concerned with whether the information meets your expectations. For instance, you may want to make sure that each row has a value in only one of two columns, and not in both columns. This tip examines ways you can find where the data doesn't meet this expectation.

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