This article was co-authored by How.com.vn Staff. Our trained team of editors and researchers validate articles for accuracy and comprehensiveness. How.com.vn's Content Management Team carefully monitors the work from our editorial staff to ensure that each article is backed by trusted research and meets our high quality standards.
The How.com.vn Tech Team also followed the article's instructions and verified that they work.
This article has been viewed 16,472 times.
This How.com.vn teaches you how to create and save a new custom list on Excel in order to automatically fill columns and rows, using a Mac or Windows PC.
Steps
Creating a New List
Open Microsoft Excel on your computer. Excel is the spreadsheet tool of the Microsoft Office productivity suite. It is available on both Windows and Mac operating systems.
Launch Excel's Custom Lists editor. How you open the Custom Lists editor will vary depending on your operating system and software version of Excel.- For "Excel 2010" or later software on Windows, first, click the File menu at the top of your screen. Then, click Options, Advanced, and General, respectively. Here, click Edit Custom Lists.
- For "Excel 2007" on Windows, click the Microsoft Office button in the upper-left corner of your screen. It looks like colored squares in a circle. Then, click Excel Options, Popular, Top options for working with Excel, respectively. Here, click Edit Custom Lists.
- For "Excel for Mac", click the Excel menu in the upper-left corner. Then, click Preferences and Custom Lists, respectively. This will open the editor.
Advertisement
Select NEW LIST in the "Custom lists" box. You will see a list of all your lists in the Custom Lists editor. Click NEW LIST at the top of the Custom lists box to create a new custom list.
Click on the "List entries" box. This is the second box in the Custom Lists editor next to the Custom lists box. Here, you can see all the list entries when you select a list from the Custom lists box.- This box will be empty when you select NEW LIST.
Type in entries for your new list. If your new list is short, you can manually fill out the List entries box with entries.- Hit ↵ Enter on your keyboard after each entry.
Click the cell selector icon next to the Import button. This button lets you select a range of cells, such as a column or row, from your spreadsheets in order to use this data for your List entries. This option could be useful for long lists with too many entries to manually enter.- On Windows, this button looks like an upwards-pointing arrow icon.
- On Mac, it's a red, diagonal arrow inside a rectangle box.
Click Import. This button will import all the data from the selected range of cells, and plug it into the List entries box.
Click Add. This button will create your new custom list.
Click OK. It will save your changes, and quit the Custom Lists editor. You can now use your new custom list.- If you're on a Mac, you might not have an OK button here. In this case, close the dialogue box by clicking the red "X" button in the upper-left corner of the Custom Lists window.
Advertisement
Using Your New List
Type in one of your custom list entries in a cell. This can be any entry from the custom list.
Press Enter on your keyboard.
Click on the cell. Select the cell with your custom list entry in it by clicking on the cell. This will highlight the cell borders.
Click and drag the AutoFill handle in any direction. The handle looks like a small, square dot in the lower-right corner of the cell. It will automatically fill out your sheet with the rest of your custom list entries.Advertisement
Expert Q&A
About this article
1. Open Microsoft Excel.
2. Launch the Custom Lists editor.
3. Select NEW LIST.
4. Enter your list items under List entries.
5. Click Add.
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
