Springtime in the Rockies

The past week has been a little crazy when it comes to weather in our area. It is "springtime in the Rockies," which means unpredictability. We have had warm days and days with temperatures below freezing. We have had rain, sleet, snow, and wind in just about any combination you can think of. One day we woke up to about 3 inches of snow that melted completely by 10:00 am. Sooner or later the crazy spring weather will give way to summer, and then things should be more settled.

I hope that things have been good in your corner of the world and that you enjoy the tips in this week's newsletter.

—Allen
     

ExcelTips (menu) for 9 May 2026
Worksheets
Freezing Top Rows and Bottom Rows

Freezing the top rows in a worksheet so that they are always visible is easy to do. Freezing the bottom rows is not so easy. Here's a workaround you can use.

Read this tip »

 
Creating macros
Official Color Names in VBA

When creating macros, you can use the ColorIndex and Color properties to set or determine the colors in a cell. Excel provides eight constants that can be used to specify colors, but that is not the limit on how you can work with colors. This tip provides some general guidance on colors and color names in VBA macros.

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.

 
Editing
Can't Empty the Clipboard

The Clipboard is essential to move or copy information from one place in Excel to another. If you get an error when you try to complete an operation that relies on the Clipboard, this can be disconcerting.

Read this tip »

 
Copying data
Changes in Font Size when Copying

Have you ever copied information from one worksheet to another, only to have the information you paste not look the way you expected? There's a reason for that, and it has to do with source and target formatting, as discussed in this tip.

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