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

How to Convert an Excel Spreadsheet to a Contact List. As a business owner, you probably interact with multiple contact lists daily. These lists containing client or customer information might ...

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.

Use one or both of these simple Microsoft Excel macros to list all the sheets in an Excel workbook.

Why You Should Add a Table of Contents to Excel What would you do if you had hundreds of sheets in an Excel workbook and needed to find a specific one for updating or modifying data? Searching ...

In case you work in one Excel workbook that you'd like to move to another one, there is a simple solution that doesn't require knowing macros or VBA codes – it can be done in a few simple clicks. Read ...

if you have access to the source file, you can link a table or graph in Excel to your PowerPoint slide. If the data in the worksheet is changed, it is automatically updated.