Want to organize all the worksheets in your Excel workbook? Try creating a table of contents. It makes it easy to find ...

The REGEX functions are available for people using Excel for Microsoft 365 on Windows or Mac, as well as those using Excel ...

The new user interface in the latest version of Microsoft Excel changes all the rules. Here's how to find your way around and get the most out of Excel 2007.

Count each ZIP Code in the unique list. To learn more about dynamic arrays, you can read How to create a sorted unique list in an Excel spreadsheet. How do I count multiple items in Excel pre-365?

Save this for the spreadsheet jocks in your office—we'd bet even the experts don't know all of these formula tips.

How to Create an Excel File Using Visual Basic 6.0. Microsoft announced in early 2012 that it would extend support for aging Visual Basic 6 runtimes and code syntax for the entire life cycle of ...

Want to hide the unused area in Excel so you are able to focus solely on your data? Follow the steps in this article.

Use the SUBSTITUTE () function to remove non-printable characters in Excel Excel offers a CODE () function which returns the ASCII code for a given character.

In an Excel workbook it is possible to insert a GIF, although the animation will only work when the image is inserted into a control. This can be done through Control Toolbox, Design mode and ...

The LOG and the LOG 10 function are both Math and Trigonometry functions. Learn how to use the LOG and LOG 10 functions in Excel.