In this month’s column, find out how to change text strings to sentence case in Excel.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

You can easily hide and unhide columns in Excel by individually revealing hidden columns or using the "Format" option to unhide all hidden cells.

You can change views in Excel depending on what you're doing and what you want to see. Learn how in this step-by-step tutorial.

However, when you're creating a spreadsheet in Microsoft Excel, the double-click shortcut can be just as useful. In this guide, I'll share 11 of my favorite double-click Excel tricks. After typing a ...

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.