{"id":180605,"date":"2021-02-17T13:24:36","date_gmt":"2021-02-17T10:24:36","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-create-a-custom-list-in-microsoft-excel\/"},"modified":"2021-02-17T13:24:36","modified_gmt":"2021-02-17T10:24:36","slug":"how-to-create-a-custom-list-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-custom-list-in-microsoft-excel\/","title":{"rendered":"#How to Create a Custom List in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2780f3cb0bd\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a2780f3cb0bd\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-custom-list-in-microsoft-excel\/#Create_a_Custom_List_of_Items_in_Excel\" >Create a Custom List of Items in Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-custom-list-in-microsoft-excel\/#Import_a_List_of_Items_From_Cells\" >Import a List of Items From Cells<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-custom-list-in-microsoft-excel\/#Use_Your_Custom_List\" >Use Your Custom List<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-custom-list-in-microsoft-excel\/#Edit_or_Delete_a_Custom_List\" >Edit or Delete a Custom List<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Create a Custom List in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-435491\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2019\/07\/stock-lede-microsoft-office_excel-1.png\" alt=\"Excel Logo on a gray background\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Reduce tedious data entry and the risk of errors by creating custom lists in Microsoft Excel. By setting up a list ahead of time, you can use autofill or add a drop-down selection for the items, saving you time.<\/p>\n<p>Microsoft Excel comes with a few custom lists of its own. These include things like the days of the week and months of the year. This is what makes a feature like autofill so convenient. You simply enter one word, like Sunday or January, and drag the fill handle to complete the list.<\/p>\n<p>A custom list that you create works the same way. So once you enter the list items, you can simply type one and use autofill to fill in the rest.<\/p>\n<p>Plus, you can reuse your custom lists across other Excel workbooks.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Create_a_Custom_List_of_Items_in_Excel\"><\/span>Create a Custom List of Items in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>A custom list in Microsoft Excel can contain any items you like. For business, it\u2019s great for a list of products, product attributes, employees, or locations. \u00a0But you can also use a custom list for personal items, like a list of payees for your bills, food items for meal planning, or products for your shopping list.<\/p>\n<p>With your list of items in mind, open your Excel workbook and access the settings.<\/p>\n<p>On Windows, go to File &gt; Options. Select \u201cAdvanced\u201d on the left and scroll down to the \u201c<a href=\"https:\/\/buradabiliyorum.com\/en\/category\/general\/\" data-internallinksmanager029f6b8e52c=\"3\" title=\"General\" target=\"_blank\" rel=\"noopener\">General<\/a>\u201d section. Click \u201cEdit Custom Lists.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-707965\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/01\/AdvancedEditCustomLists-ExcelWindows.png\" alt=\"Click File, Options, Advanced, Edit Custom Lists\" width=\"650\" height=\"510\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>On Mac, go to Excel &gt; Preferences. In the \u201cFormulas and Lists\u201d section, click \u201cCustom Lists.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-707964\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/01\/PreferencesCustomLists-ExcelMac.png\" alt=\"Click Excel, Preferences, Custom Lists\" width=\"602\" height=\"354\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Make sure that \u201cNew List\u201d is selected in the \u201cCustom Lists\u201d box. Then, enter your list items in the \u201cList Entries\u201d box. Hit the \u201cEnter\u201d or \u201cReturn\u201d key after each so that every item <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>ears on a separate line.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-707967\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/01\/AddCustomListEntries-ExcelWindows.png\" alt=\"Type each list item and click Add\" width=\"650\" height=\"477\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Click \u201cAdd,\u201d and you\u2019ll see your list items appear in the \u201cCustom Lists\u201d box. If you\u2019re finished, click \u201cOK\u201d on Windows, or on Mac, simply close the Custom Lists window.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-707966\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/01\/AddedCustomListEntries-ExcelWindows.png\" alt=\"Added custom list entries\" width=\"650\" height=\"477\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Import_a_List_of_Items_From_Cells\"><\/span>Import a List of Items From Cells<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you already have your list of items in the spreadsheet, you can turn it into a custom list using the Import feature. Then you can reuse the list wherever you need to without reentering the items.<\/p>\n<p>If you\u2019ve closed the Custom Lists window, head back to it using the instructions above. Enter the cell range containing the list items in the \u201cImport List From Cells\u201d box. Alternatively, you can use your cursor to drag through the list of cells for the range to populate automatically. Click \u201cImport.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-707969\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/01\/ImportListEntries-ExcelWindows.png\" alt=\"Drag through the list items to import them\" width=\"650\" height=\"263\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll then see the imported items appear in the \u201cCustom Lists\u201d box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-707968\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/01\/ImportedListEntries-ExcelWindows.png\" alt=\"Imported List Entries\" width=\"650\" height=\"477\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Click \u201cOK\u201d on Windows, or click the red \u201cX\u201d on Mac to close the window.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Use_Your_Custom_List\"><\/span>Use Your Custom List<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The nice thing about creating a custom list in Microsoft Excel is that you can use it in any Excel spreadsheet or workbook. Head to a spot where you want to add the list items and type in one of them. Use the fill handle to complete the list.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-707973\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/01\/AutofillCustomList-ExcelWindows.png\" alt=\"Drag the fill handle to complete the list\" width=\"427\" height=\"236\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can also follow our tutorial for adding a drop-down list based on a custom list for easier data entry.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Edit_or_Delete_a_Custom_List\"><\/span>Edit or Delete a Custom List<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You may need to change a custom list that you create by adding or removing items from it. On the other hand, you might want to simply delete a list you never use. Go back to the Custom Lists section for both of these actions.<\/p>\n<p>To edit a custom list, select it in the \u201cCustom Lists\u201d box. Make your changes in the \u201cList Entries\u201d box and click \u201cAdd.\u201d This will not create a new custom list; it will simply update your existing one.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-707976 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/01\/EditCustomList-ExcelWindows.png\" alt=\"Edit list entries\" width=\"650\" height=\"476\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To delete a custom list, select it in the \u201cCustom Lists\u201d box and hit \u201cDelete.\u201d Confirm this action by clicking \u201cOK.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-707970 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/01\/DeleteCustomList-ExcelWindows.png\" alt=\"Select the list and click Delete, OK\" width=\"650\" height=\"477\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you find yourself repeating a list of items in your spreadsheets, make your data entry a bit easier by creating a custom list in Microsoft Excel. And for more help with lists, take a look at how to create a checklist in Excel.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/707962\/how-to-create-a-custom-list-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Create a Custom List in Microsoft Excel&#8221; Reduce tedious data entry and the risk of errors by creating custom lists in Microsoft Excel. By setting up a list ahead of time, you can use autofill or add a drop-down selection for the items, saving you time. Microsoft Excel comes with a few custom&#8230;<\/p>\n","protected":false},"author":1,"featured_media":180606,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2019\/07\/stock-lede-microsoft-office_excel-1.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-180605","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/180605","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=180605"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/180605\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/180606"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=180605"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=180605"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=180605"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}