Check Out WindowsTips

There's a good chance that you use Microsoft Windows on your computer system. If that is the case, you might be interested in checking out the WindowsTips website, located here:

https://windows.tips.net

If you like what you see at the site, you can also sign up for the free weekly WindowsTips newsletter. (A sign-up form is visible at the right side of any page on the site.) I've been publishing the newsletter for several years, but recently (within the past month) appointed my son, Eric, as editor of that publication.

Anyway, check it out. You might learn a thing or two!

—Allen
     

ExcelTips (menu) for 24 February 2018

Files
Working with Lotus 1-2-3 Spreadsheets

If you've got some older data around your office that started in an old Lotus 1-2-3 system, you may want to open it in Excel. How Excel works with that older data depends on a couple of program settings you make.

Read this tip »

 
Creating macros
Continuing Macro Lines

Sometimes a macro command line can get very, very long. This can make it hard to understand when you look at it a month or so from now. It is better to break your command lines up into individual lines that are easier to understand and document.

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.

 
Macros extend Excel
Reversing Cell Contents

Macros are great at working with text. This tip presents an example that shows this versatility by reversing the contents of the text in a given cell.

Read this tip »

 
Excel can calculate at lightening speed
Status Bar Summing No Longer Available

When you select a range of cells, Excel normally displays the sum of those selected cells on the status bar. If the sum no longer appears, here's how you can get it back.

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