Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

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.

Thankfully, Excel makes it easy to hide or unhide rows and columns, allowing you to declutter your spreadsheet and focus on the information that matters most.

In this tutorial, I’ll show you how to create a sheet view in a shared Excel workbook and then add groups as well as hidden rows and columns.

In this guide, you’ll learn how to create a dynamic search box that filters data based on your input, using Excel’s built-in features and Developer tools.