|
|
|
|
|
How to create a custom list in MS Excel 2010
If you are using the same entries all over again, you can create a custom list with these entries and when you need it just enter the first one then drag the cell down for the rest to fill out automatically.
|
|
 |
|
|
|
|
|
|
|
|
|
|
 |
1.
|
|
|
In MS Excel, click the File tab.
|
|
| |
2.
|
|
|
Click Options on the left.
|
|
| |
4.
|
|
|
Click Edit Custom Lists...
|
|
| |
5.
|
|
|
Let's now create a new custom list the "manual way".
Click NEW LIST.
|
|
| |
6.
|
|
|
And in List entries, enter what ever you want in your list.
I'm going to enter some names, just press Enter to add a new entry. You can use more then one word for one entry.
Click Add when done.
|
|
| |
8.
|
|
|
Another way to add entries to a new lists is to import them from an existing Excel document.
Again, click NEW LIST.
|
|
| |
9.
|
|
|
Click the Import list from cells field.
|
|
| |
10.
|
|
|
In your document, select the cells you want in your new custom list ...
|
|
| |
11.
|
|
|
... and click Import.
|
|
| |
12.
|
|
|
And that's it, the list has been made.
Click OK when done. Close the settings window.
|
|
| |
13.
|
|
|
Let's now see how our new custom lists works.
Enter the first entry from your list, click and hold the cell's right-bottom corner. ...
|
|
| |
14.
|
|
|
... and just drag it in any direction you want your entries to appear.
It's basically a regular excel auto-fill option.
|
|
|
 |
|
 |
|
 |
|
|
