Opening Multiple Workbooks at Once

Need to open a bunch of workbooks from within Excel? It's easy to do when you construct a selection set in the Open dialog box.

Read this tip »

Comma-Delimited Differences for PC and Mac

When you choose to save worksheet data in CSV format, Excel gives you three choices for file formats. Those choices are detailed in this tip.

Read this tip »

Enhance Your Excel Skills with Macros

Macros are a great way to increase your productivity with Excel by making the program work the way you want it to work. Discover the true power behind macros; ExcelTips: The Macros puts almost 800 pages of macro-focused information at your fingertips. Discover more...

Hiding Macros

Need to hide some macros in your workbook? There are three ways you can do it, as covered in this discussion.

Read this tip »

Too Many Formats when Sorting

Sorting is one of the basic operations done in a worksheet. If your sorting won't work and you instead get an error message, it could be because of the number of custom formats in your workbook. This tip provides information to help get rid of this problem.

Read this tip »

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.