{"id":1417,"date":"2023-05-03T04:10:06","date_gmt":"2023-05-03T04:10:06","guid":{"rendered":"https:\/\/www.tunesbro.com\/blog\/?p=1417"},"modified":"2023-05-03T04:10:07","modified_gmt":"2023-05-03T04:10:07","slug":"how-to-add-a-custom-list-in-excel-mac","status":"publish","type":"post","link":"https:\/\/www.tunesbro.com\/blog\/how-to-add-a-custom-list-in-excel-mac\/","title":{"rendered":"How to Add A Custom List in Excel Mac"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_45_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"ez-toc-toggle-icon-1\"><label for=\"item-69f2e074a3748\" aria-label=\"Table of Content\"><span style=\"display: flex;align-items: center;width: 35px;height: 30px;justify-content: center;direction:ltr;\"><svg style=\"fill: #999;color:#999\" 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: #999;color:#999\" 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><\/label><input  type=\"checkbox\" id=\"item-69f2e074a3748\"><\/a><\/span><\/div>\n<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:\/\/www.tunesbro.com\/blog\/how-to-add-a-custom-list-in-excel-mac\/#Video_Tutorial\" title=\"Video Tutorial:\">Video Tutorial:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.tunesbro.com\/blog\/how-to-add-a-custom-list-in-excel-mac\/#Whats_Needed\" title=\"What&#8217;s Needed\">What&#8217;s Needed<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.tunesbro.com\/blog\/how-to-add-a-custom-list-in-excel-mac\/#What_Should_I_Pay_Attention_to\" title=\"What Should I Pay Attention to?\">What Should I Pay Attention to?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.tunesbro.com\/blog\/how-to-add-a-custom-list-in-excel-mac\/#Method_1_Add_a_custom_list\" title=\"Method 1: Add a custom list\">Method 1: Add a custom list<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.tunesbro.com\/blog\/how-to-add-a-custom-list-in-excel-mac\/#Method_2_Using_AutoFill\" title=\"Method 2: Using AutoFill\">Method 2: Using AutoFill<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.tunesbro.com\/blog\/how-to-add-a-custom-list-in-excel-mac\/#Method_3_Using_a_formula_to_create_a_custom_list\" title=\"Method 3: Using a formula to create a custom list\">Method 3: Using a formula to create a custom list<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.tunesbro.com\/blog\/how-to-add-a-custom-list-in-excel-mac\/#Why_Cant_I_Add_Custom_List_in_Excel_Mac\" title=\"Why Can&#8217;t I Add Custom List in Excel Mac\">Why Can&#8217;t I Add Custom List in Excel Mac<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.tunesbro.com\/blog\/how-to-add-a-custom-list-in-excel-mac\/#Suggestions\" title=\"Suggestions\">Suggestions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.tunesbro.com\/blog\/how-to-add-a-custom-list-in-excel-mac\/#FAQs\" title=\"FAQs\">FAQs<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.tunesbro.com\/blog\/how-to-add-a-custom-list-in-excel-mac\/#Conclusion\" title=\"Conclusion\">Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<p>Microsoft Excel is a powerful tool that can be used for a wide range of purposes. Among its many features, the ability to create custom lists can be very useful. With a custom list, you can quickly fill in a series of cells with specific data, such as a list of employees or a list of products. In this blog post, we will explore the steps to add a custom list in Excel for Mac.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Video_Tutorial\"><\/span>Video Tutorial:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<lite-youtube videoid=\"hA9lzgjudOg\" playlabel=\"Play: Keynote (Google I\/O '18)\"><\/lite-youtube>\n<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Whats_Needed\"><\/span>What&#8217;s Needed<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To add a custom list in Excel for Mac, you will need:<\/p>\n<p>1. A Mac computer with Microsoft Excel installed<br \/>\n2. Your list of data, such as a list of names, dates or products<br \/>\n3. Basic knowledge of how to use Excel<\/p>\n<h2><span class=\"ez-toc-section\" id=\"What_Should_I_Pay_Attention_to\"><\/span>What Should I Pay Attention to?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Before creating a custom list in Excel, there are a few important things to keep in mind:<\/p>\n<p>1. The list must be in a specific order. For example, if you are creating a list of months of the year, they must be in chronological order.<br \/>\n2. The cells where you want to add the list must be highlighted before you add the custom list.<br \/>\n3. If you add a new item to the list, it may not be automatically added to the cells where the list has already been applied.<br \/>\n4. When you enter the first item in a cell, you can drag the lower right corner of the cell down to automatically fill in the rest of the list.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Method_1_Add_a_custom_list\"><\/span>Method 1: Add a custom list<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>1. Open Excel and create a new workbook.<br \/>\n2. Type your list of items in a column on your sheet. For example, you can create a list of months of the year.<br \/>\n3. Select the list of items that you want to turn into a custom list.<br \/>\n4. Click on the \"<strong>Excel<\/strong>\" menu tab located at the top-left of your screen.<br \/>\n5. Click on \"<strong>Preferences<\/strong>\" then click on \"<strong>Custom Lists<\/strong>\".<br \/>\n6. Click on \"<strong>Import<\/strong>\" and find the list that you just created in the column.<br \/>\n7. Click on \"<strong>OK<\/strong>\" to add the list.<br \/>\n8. Close the window.<\/p>\n<h4>Pros:<\/h4>\n<p>&#8211; It is a quick and easy way to create a custom list.<br \/>\n&#8211; You can import your list from other sources and use it in Excel.<br \/>\n&#8211; Once you have created a custom list, you can use it in any workbook.<\/p>\n<h4>Cons:<\/h4>\n<p>&#8211; If you want to change the order of the list, you need to delete and re-create it.<br \/>\n&#8211; Creating long lists can take time and effort.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Method_2_Using_AutoFill\"><\/span>Method 2: Using AutoFill<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>1. Open Excel and create a new workbook.<br \/>\n2. Type the first item of your list into a cell.<br \/>\n3. Click on the cell with your item and hover your cursor over the lower right corner of the cell until it turns into a black plus sign.<br \/>\n4. Drag the fill handle down or across to fill in the rest of the list.<br \/>\n5. Release the mouse button to complete the AutoFill.<\/p>\n<h4>Pros:<\/h4>\n<p>&#8211; It is quick and easy to use.<br \/>\n&#8211; You can use this feature to fill in dates, numbers, and other items.<\/p>\n<h4>Cons:<\/h4>\n<p>&#8211; Only useful for simple lists.<br \/>\n&#8211; You need to manually type the first item for the list to use this method.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Method_3_Using_a_formula_to_create_a_custom_list\"><\/span>Method 3: Using a formula to create a custom list<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>1. Open Excel and create a new workbook.<br \/>\n2. Select the cell where you want to start a new list.<br \/>\n3. In the formula bar, type \"<strong>=<\/strong>\" followed by the first item of the list. For example, \"<strong>=January<\/strong>\".<br \/>\n4. Press the \"<strong>Enter<\/strong>\" key on your keyboard.<br \/>\n5. Click on the cell with your first item and hover your cursor over the lower right corner of the cell until it turns into a black plus sign.<br \/>\n6. Drag the fill handle down or across to fill in the rest of the list.<br \/>\n7. Release the mouse button to complete the AutoFill.<\/p>\n<h4>Pros:<\/h4>\n<p>&#8211; You can use this method to create more complex lists.<br \/>\n&#8211; The formula can be customized to suit different situations.<\/p>\n<h4>Cons:<\/h4>\n<p>&#8211; This method can be time-consuming and require knowledge of formulas.<br \/>\n&#8211; It may not be suitable for beginners.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Why_Cant_I_Add_Custom_List_in_Excel_Mac\"><\/span>Why Can&#8217;t I Add Custom List in Excel Mac<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>1. You may not have administrative rights to add lists.<br \/>\n2. You may not have the latest version of Excel for Mac.<br \/>\n3. The list you are trying to add may not meet the requirements for a custom list.<br \/>\n4. There may be an issue with the data that you are trying to add to the list.<\/p>\n<h4>Fixes:<\/h4>\n<p>1. Ensure that you have administrative rights to add lists.<br \/>\n2. Check for updates and install the latest version of Excel for Mac.<br \/>\n3. Ensure that the list meets the requirements for a custom list.<br \/>\n4. Check the data for any inconsistencies or errors.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Suggestions\"><\/span>Suggestions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>1. Practice adding simple lists first before moving on to more complex lists.<br \/>\n2. Use different methods to create lists to find the one that is most suitable for your situation.<br \/>\n3. Keep a record of your custom lists for future reference.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"FAQs\"><\/span>FAQs<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h4>Q: Can I add a custom list of numbers in Excel for Mac?<\/h4>\n<p>A: Yes, you can add a custom list of numbers in Excel for Mac. Simply follow the same steps as for a list of text items.<\/p>\n<h4>Q: Can I add a custom list from another program?<\/h4>\n<p>A: Yes, you can import a list from another program in Excel for Mac. Follow the same steps as for adding a list from within Excel.<\/p>\n<h4>Q: Can I use a custom list in any workbook?<\/h4>\n<p>A: Yes, once you have created a custom list, you can use it in any workbook.<\/p>\n<h4>Q: Will Excel automatically update my custom list if I make changes to it?<\/h4>\n<p>A: No, if you make changes to your custom list, you will need to update it in Excel manually.<\/p>\n<h4>Q: Can I delete a custom list?<\/h4>\n<p>A: Yes, you can delete a custom list in Excel for Mac. Go to the \"<strong>Custom Lists<\/strong>\" Preferences and delete the list you want to remove.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Adding a custom list in Excel for Mac can save you time and effort when filling in large amounts of data. Whether you use a simple list or a more complex solution, knowing the steps to add custom lists can be a valuable skill when working with Excel. With the right knowledge and tools, you can make your work in Excel more efficient and productive.<script type=\"application\/ld+json\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@type\":\"FAQPage\",\"mainEntity\":[{\"@type\":\"Question\",\"name\":\"Pros:\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"\\n- It is a quick and easy way to create a custom list.\\n- You can import your list from other sources and use it in Excel.\\n- Once you have created a custom list, you can use it in any workbook.\\n\\n\"}},{\"@type\":\"Question\",\"name\":\"Cons:\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"\\n- If you want to change the order of the list, you need to delete and re-create it.\\n- Creating long lists can take time and effort.\\n\\n\\n\\n1. Open Excel and create a new workbook.\\n2. Type the first item of your list into a cell.\\n3. Click on the cell with your item and hover your cursor over the lower right corner of the cell until it turns into a black plus sign.\\n4. Drag the fill handle down or across to fill in the rest of the list.\\n5. Release the mouse button to complete the AutoFill.\\n\\n\"}},{\"@type\":\"Question\",\"name\":\"Pros:\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"\\n- It is quick and easy to use.\\n- You can use this feature to fill in dates, numbers, and other items.\\n\\n\"}},{\"@type\":\"Question\",\"name\":\"Cons:\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"\\n- Only useful for simple lists.\\n- You need to manually type the first item for the list to use this method.\\n\\n\\n\\n1. Open Excel and create a new workbook.\\n2. Select the cell where you want to start a new list.\\n3. In the formula bar, type \\\"=\\\" followed by the first item of the list. For example, \\\"=January\\\".\\n4. Press the \\\"Enter\\\" key on your keyboard.\\n5. Click on the cell with your first item and hover your cursor over the lower right corner of the cell until it turns into a black plus sign.\\n6. Drag the fill handle down or across to fill in the rest of the list.\\n7. Release the mouse button to complete the AutoFill.\\n\\n\"}},{\"@type\":\"Question\",\"name\":\"Pros:\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"\\n- You can use this method to create more complex lists.\\n- The formula can be customized to suit different situations.\\n\\n\"}},{\"@type\":\"Question\",\"name\":\"Cons:\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"\\n- This method can be time-consuming and require knowledge of formulas.\\n- It may not be suitable for beginners.\\n\\n\\n\\n1. You may not have administrative rights to add lists.\\n2. You may not have the latest version of Excel for Mac.\\n3. The list you are trying to add may not meet the requirements for a custom list.\\n4. There may be an issue with the data that you are trying to add to the list.\\n\\n\"}},{\"@type\":\"Question\",\"name\":\"Fixes:\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"\\n1. Ensure that you have administrative rights to add lists.\\n2. Check for updates and install the latest version of Excel for Mac.\\n3. Ensure that the list meets the requirements for a custom list.\\n4. Check the data for any inconsistencies or errors.\\n\\n\\n\\n1. Practice adding simple lists first before moving on to more complex lists.\\n2. Use different methods to create lists to find the one that is most suitable for your situation.\\n3. Keep a record of your custom lists for future reference.\\n\\n\\n\\n\"}},{\"@type\":\"Question\",\"name\":\"Q: Can I add a custom list of numbers in Excel for Mac?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"\\nA: Yes, you can add a custom list of numbers in Excel for Mac. Simply follow the same steps as for a list of text items.\\n\\n\"}},{\"@type\":\"Question\",\"name\":\"Q: Can I add a custom list from another program?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"\\nA: Yes, you can import a list from another program in Excel for Mac. Follow the same steps as for adding a list from within Excel.\\n\\n\"}},{\"@type\":\"Question\",\"name\":\"Q: Can I use a custom list in any workbook?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"\\nA: Yes, once you have created a custom list, you can use it in any workbook.\\n\\n\"}},{\"@type\":\"Question\",\"name\":\"Q: Will Excel automatically update my custom list if I make changes to it?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"\\nA: No, if you make changes to your custom list, you will need to update it in Excel manually.\\n\\n\"}},{\"@type\":\"Question\",\"name\":\"Q: Can I delete a custom list?\",\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"\\nA: Yes, you can delete a custom list in Excel for Mac. Go to the \\\"Custom Lists\\\" Preferences and delete the list you want to remove.\\n\\n\\n\\nAdding a custom list in Excel for Mac can save you time and effort when filling in large amounts of data. Whether you use a simple list or a more complex solution, knowing the steps to add custom lists can be a valuable skill when working with Excel. With the right knowledge and tools, you can make your work in Excel more efficient and productive.\"}}]}<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel is a powerful tool that can be used for a wide range of purposes. Among its many features, the ability to create custom lists can be very useful. With a custom list, you can quickly fill in a series of cells with specific data, such as a list of employees or a list &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.tunesbro.com\/blog\/how-to-add-a-custom-list-in-excel-mac\/\"> <span class=\"screen-reader-text\">How to Add A Custom List in Excel Mac<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":""},"categories":[22],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v18.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Add A Custom List In Excel Mac<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.tunesbro.com\/blog\/how-to-add-a-custom-list-in-excel-mac\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Add A Custom List in Excel Mac\" \/>\n<meta property=\"og:description\" content=\"Microsoft Excel is a powerful tool that can be used for a wide range of purposes. Among its many features, the ability to create custom lists can be very useful. With a custom list, you can quickly fill in a series of cells with specific data, such as a list of employees or a list &hellip; How to Add A Custom List in Excel Mac Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.tunesbro.com\/blog\/how-to-add-a-custom-list-in-excel-mac\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-03T04:10:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-03T04:10:07+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Hazel\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.tunesbro.com\/blog\/#website\",\"url\":\"https:\/\/www.tunesbro.com\/blog\/\",\"name\":\"\",\"description\":\"All things about tech, Windows, Mac, Android and iOS\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.tunesbro.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.tunesbro.com\/blog\/how-to-add-a-custom-list-in-excel-mac\/#webpage\",\"url\":\"https:\/\/www.tunesbro.com\/blog\/how-to-add-a-custom-list-in-excel-mac\/\",\"name\":\"How to Add A Custom List in Excel Mac\",\"isPartOf\":{\"@id\":\"https:\/\/www.tunesbro.com\/blog\/#website\"},\"datePublished\":\"2023-05-03T04:10:06+00:00\",\"dateModified\":\"2023-05-03T04:10:07+00:00\",\"author\":{\"@id\":\"https:\/\/www.tunesbro.com\/blog\/#\/schema\/person\/671c1d7ed0014b4030eeedfb9038da24\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.tunesbro.com\/blog\/how-to-add-a-custom-list-in-excel-mac\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.tunesbro.com\/blog\/how-to-add-a-custom-list-in-excel-mac\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.tunesbro.com\/blog\/how-to-add-a-custom-list-in-excel-mac\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.tunesbro.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Add A Custom List in Excel Mac\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.tunesbro.com\/blog\/#\/schema\/person\/671c1d7ed0014b4030eeedfb9038da24\",\"name\":\"Hazel\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.tunesbro.com\/blog\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0760b75c92ccc032badf58b3c2af9d98?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0760b75c92ccc032badf58b3c2af9d98?s=96&d=mm&r=g\",\"caption\":\"Hazel\"},\"url\":\"https:\/\/www.tunesbro.com\/blog\/author\/hazel\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Add A Custom List In Excel Mac","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.tunesbro.com\/blog\/how-to-add-a-custom-list-in-excel-mac\/","og_locale":"en_US","og_type":"article","og_title":"How to Add A Custom List in Excel Mac","og_description":"Microsoft Excel is a powerful tool that can be used for a wide range of purposes. Among its many features, the ability to create custom lists can be very useful. With a custom list, you can quickly fill in a series of cells with specific data, such as a list of employees or a list &hellip; How to Add A Custom List in Excel Mac Read More &raquo;","og_url":"https:\/\/www.tunesbro.com\/blog\/how-to-add-a-custom-list-in-excel-mac\/","article_published_time":"2023-05-03T04:10:06+00:00","article_modified_time":"2023-05-03T04:10:07+00:00","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Hazel","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/www.tunesbro.com\/blog\/#website","url":"https:\/\/www.tunesbro.com\/blog\/","name":"","description":"All things about tech, Windows, Mac, Android and iOS","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.tunesbro.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.tunesbro.com\/blog\/how-to-add-a-custom-list-in-excel-mac\/#webpage","url":"https:\/\/www.tunesbro.com\/blog\/how-to-add-a-custom-list-in-excel-mac\/","name":"How to Add A Custom List in Excel Mac","isPartOf":{"@id":"https:\/\/www.tunesbro.com\/blog\/#website"},"datePublished":"2023-05-03T04:10:06+00:00","dateModified":"2023-05-03T04:10:07+00:00","author":{"@id":"https:\/\/www.tunesbro.com\/blog\/#\/schema\/person\/671c1d7ed0014b4030eeedfb9038da24"},"breadcrumb":{"@id":"https:\/\/www.tunesbro.com\/blog\/how-to-add-a-custom-list-in-excel-mac\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.tunesbro.com\/blog\/how-to-add-a-custom-list-in-excel-mac\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.tunesbro.com\/blog\/how-to-add-a-custom-list-in-excel-mac\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.tunesbro.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Add A Custom List in Excel Mac"}]},{"@type":"Person","@id":"https:\/\/www.tunesbro.com\/blog\/#\/schema\/person\/671c1d7ed0014b4030eeedfb9038da24","name":"Hazel","image":{"@type":"ImageObject","@id":"https:\/\/www.tunesbro.com\/blog\/#personlogo","inLanguage":"en-US","url":"https:\/\/secure.gravatar.com\/avatar\/0760b75c92ccc032badf58b3c2af9d98?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0760b75c92ccc032badf58b3c2af9d98?s=96&d=mm&r=g","caption":"Hazel"},"url":"https:\/\/www.tunesbro.com\/blog\/author\/hazel\/"}]}},"_links":{"self":[{"href":"https:\/\/www.tunesbro.com\/blog\/wp-json\/wp\/v2\/posts\/1417"}],"collection":[{"href":"https:\/\/www.tunesbro.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tunesbro.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tunesbro.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tunesbro.com\/blog\/wp-json\/wp\/v2\/comments?post=1417"}],"version-history":[{"count":1,"href":"https:\/\/www.tunesbro.com\/blog\/wp-json\/wp\/v2\/posts\/1417\/revisions"}],"predecessor-version":[{"id":1496,"href":"https:\/\/www.tunesbro.com\/blog\/wp-json\/wp\/v2\/posts\/1417\/revisions\/1496"}],"wp:attachment":[{"href":"https:\/\/www.tunesbro.com\/blog\/wp-json\/wp\/v2\/media?parent=1417"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tunesbro.com\/blog\/wp-json\/wp\/v2\/categories?post=1417"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tunesbro.com\/blog\/wp-json\/wp\/v2\/tags?post=1417"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}