How do I create a custom list in Excel 2010?

Create a custom list

1. For Excel 2010 and later, click File > Options > Advanced > General > Edit Custom Lists.
2. For Excel 2007, click the Microsoft Office Button.
3. In the Custom Lists box, click NEW LIST, and then type the entries in the List entries box, beginning with the first entry.
4. When the list is complete, click Add.

How do I edit a custom list in Excel 2010?

Creating a custom list

1. Click the File tab and then click Options.
2. Click the Advanced tab.
3. Click the Edit Custom Lists button in the General section.
4. Click inside the List Entries list box and then type each entry (in the desired order), pressing Enter after each list item.
5. Click the Add button.

Can you save a custom sort in Excel?

Normally we can save filter criteria by Custom Views feature in Excel, but the Custom Views feature can’t reserve custom sort criteria/order.

How do I create a custom autofill list in Excel?

Select File→Options→Advanced (Alt+FTA) and then scroll down and click the Edit Custom Lists button located in the General section. The Custom Lists dialog box opens with its Custom Lists tab, where you now should check the accuracy of the cell range listed in the Import List from Cells text box.

How do I create a custom AutoFill list in Excel?

How do you edit a custom list in Excel?

Edit a custom list

1. Click the File tab and select Options from the menu.
2. From the Excel Options dialog box select Advanced from the categories on the left.
3. Scroll to the bottom of the Advanced screen and click the Edit Custom Lists button in the middle of the screen.
4. Select your custom list from the ones displayed.

How do I save a custom filter in Excel?

1 Answer. In the “View” ribbon select “Custom Views” in the group “Workbook Views”. If it does not appear go to options->customize ribbon-> select all commands-> find “Custom Views”-> add to a custom ribbon. This will save the table filtering among other things.

How do you create a custom AutoFill list?

How to use custom lists with Excel 2010?

In Excel 2010, you can use the AutoFill feature to create a custom list with names, locations, or other items and then use the AutoFill handle to fill these list items in order in a workbook.

How do I delete a custom list in Excel?

In the Custom Lists box, choose the list that you want to delete, and then click Delete. Once you create a custom list, it is added to your computer registry, so that it is available for use in other workbooks.

Can you create a custom list of numbers?

Note: A custom list can only contain text or text that is mixed with numbers. For a custom list that contains numbers only, such as 0 through 100, you must first create a list of numbers that is formatted as text. There are two ways to create a custom list.

What are the maximum specs for Microsoft Excel?

Below is a list of Microsoft Excel 2010 maximum limits and specifications. You may also want to check out the following resources with key new features for each version: Looking for Microsoft Excel training courses? Colors in a workbook: 16 million colors (32 bit with full access to 24 bit color spectrum)