Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.

You can easily create a drop-down list in Excel to limit the values that can be entered in a column. Here's how to set one up.

While you could tediously copy and paste names and addresses from a text document, with a little know-how in Excel, you can make the process far easier.

If you have a list of email addresses in an Excel spreadsheet, you can import this into a Mac Address Book by converting the Excel file into a text-based Comma Separated Value file.

Image: AndreyPopov, Getty Images/iStockphoto The data you want to use in an Excel drop down list usually won’t be in the same sheet as the drop down.

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