Adding a drop-down list in Excel is a great way to speed up data entry, keep your sheet tidy, and avoid typos. Here's how to set one up. Written by Elyse Betters Picaro, Senior Contributing Editor ...

Microsoft Excel can save you time in lots of little ways, like adding a drop-down list to cells so that only pre-written text can be entered.

The result is a bullet point. See the photo above. If you already had a list in your spreadsheet but want to add bullets to it using the Char function, type the formula =CHAR (149)&” “&A3.

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.

Whether you're handling a big event, a project, a home renovation, or everyday chores, Microsoft Excel can help you make a tailored to-do list. Yes, you read that right!

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