Blogs

2015/05/04

This feature makes the creation of spreadsheets super easy and creates repetitive lists automatically for you. Customize your own lists so that they include the information necessary for your spreadsheet.

Maybe you need to enter a list of employee names, legal practice groups, product lists, or vendors, for example, on a regular basis so it would be much more efficient to set up a custom list instead. 

To make the steps even easier, if the list of data required already exists in another spreadsheet or in another application, e.g. Word, you can copy this data and automatically create a custom list in Excel.

Here's how:

1. If the list of names or data you require already exists, first copy it to clipboard
2. In Excel, Go to File, Options, Advanced, Edit Custom Lists
3. On the left-hand side, you will see all the existing lists. If you have never created a custom list, then it will show the default lists that Excel offers. The right-hand column is where you will enter the information that you require.
4. Under List Entries, either manually type your new list of names, separating each new item with a comma or pressing Enter. On completion, click Add
       OR
   If you have copied the data from Word, just paste the list and click Add
       OR
   If you copied the data from Excel, you will notice the cell range is already listed in the Import list from cells box. Just click Import and the list is automatically created.

Submitted by Claire Morris, IT Training Team Lead, McDermott Will & Emery