Can't Open Multiple Workbooks from the Desktop

Having trouble opening a group of workbooks selected on your desktop? The reason is probably due to Windows, not Excel.

Read this tip »

Changing Multiple Cells at Once

Excel includes several different methods of editing information in your cells. If you want to edit multiple cells all at the same time, you can use the techniques described in this tip.

Read this tip »

(Thanks to Sandi Scrivens, John Hughes, David Ward, Kirk Mays, David Rubin, Fred Burg, John Rose, Janice Moyer, David Pettit, Charlie O'Neill, Saskia Jacobsen, Dick Downey, Henri den Hollander, Dave Kerr, Barry Dysert, and Allan Rey for contributing to 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.

Cycling through Colors

Excel includes quite a few tools that are not normally accessible through the various toolbars. One such esoteric tool is one that allows you to quickly cycle through the colors that can be applied to a cell. This tip explains how to make this handy tool accessible.

Read this tip »

Getting the Name of the Parent Workbook

If you need to insert into a cell the name of the workbook in which a worksheet is contained, you can use the CELL function. This tip explains the proper way to get the info you need.

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.