This is handy for things you use often like product, employee, or attribute lists.

Create custom lists in Excel Open Microsoft Excel on your Mac.

You can open the workbook where you want to insert the custom list or any other workbook since the lists are reusable.

Click Excel from your menu.

Select Preferences.

Click Custom Lists in the window that pops open.

Another window will open where you can create your custom lists and there are two ways to do it.

Create custom lists manually You can add your list items one-by-one easily.

Click inside the List entries box.

Add your items, separating each on its own line by hitting the Enter key.

When you finish adding items, click Add.

You will see those list items automatically populate in the Custom Lists box.

Create custom lists from a spreadsheet You may already have a list of items in an Excel spreadsheet that you want to transform into a custom list.

This is also easy to do.

To speed up the process, move to the spreadsheet that contains the list items.

Reopen the Custom Lists window if necessary.

Click inside the Import list from cells box.

Either select the cells on your spreadsheet by dragging through them and hitting the Enter key or typing the cell range in the box.

Click Import. You will see those items populate in both the List entries and Custom Lists boxes.

Use your Excel custom lists When you want to add items to a spreadsheet from a custom list youve created, start by adding the first item you put on that list.

Select the cell for your first item.

Move your cursor to the bottom right corner of the cell until the handle appears.

Drag to populate subsequent cells with your list items.

Release the cursor.

Youll notice as you continue to drag from the first cell, items from your list will appear briefly.

When you release the cursor, your list items will display in the cells.

You can drag to display your list items in either a column or a row, whichever works best for your spreadsheet.

If you stop dragging before the end of your list, only those items up until that point will display.

If you continue dragging longer than the number of items in your list, the list items will begin again.

Wrapping it up The ability to create custom lists in Excel is just one of those little time savers that comes in handy.

Is this a feature that you currently use in Excel or are you going to give it a try now Let us know what you think of it Tagged: Excel How to List Mac Productivity Tutorial MORE FROM iDB How to create drop-down lists in Excel on Mac How to use the redesigned Reminders app on Mac How to customize the list appearance in Reminders on Mac Newsletter Get updates directly into your inbox.

Home Apps Tutorials Jailbreak News Jailbreak Tweaks Downloads Wallpapers Accessories Deals Podcasts Write for iDB Contact Us.

How To Create Charts With Excel For Mac