Click an Excel worksheet cell that you've linked to a drop-down list. For example, if cell E1 displays a drop-down list when you click it, click that cell to select it.

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

Data Validation in Microsoft Excel allows users to control the type of data entered into the worksheet. It picks from a list of rules to limit the type of data that can be entered into a cell.

Here are six tips to turn you into a spreadsheet pro whether you're using Microsoft Excel or Google Sheets. Alphabetize your data You can customize your spreadsheet data a number of ways ...

The busier a Microsoft Excel workbook is the more ways you need to get around in it. Check out these shortcuts to help you move between sheets.