{"id":46074,"date":"2024-05-27T18:00:38","date_gmt":"2024-05-27T16:00:38","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=46074"},"modified":"2024-05-26T19:48:41","modified_gmt":"2024-05-26T17:48:41","slug":"dependent-cascading-drop-down-lists","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/dependent-cascading-drop-down-lists\/","title":{"rendered":"How to Create Dependent Cascading Drop Down Lists in Excel Fast"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/05\/Dependent-Cascading-Drop-Down-Lists.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-46361 size-large\" title=\"Dependent Cascading Drop Down Lists\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/05\/Dependent-Cascading-Drop-Down-Lists-1024x576.png\" alt=\"Dependent Cascading Drop Down Lists\" width=\"640\" height=\"360\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/05\/Dependent-Cascading-Drop-Down-Lists-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/05\/Dependent-Cascading-Drop-Down-Lists-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/05\/Dependent-Cascading-Drop-Down-Lists-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/05\/Dependent-Cascading-Drop-Down-Lists-180x100.png 180w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/05\/Dependent-Cascading-Drop-Down-Lists.png 1280w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/a><br \/>\nCascading drop downs in <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/\" target=\"_blank\" rel=\"noopener\">Microsoft Excel<\/a> are a powerful tool that allows users to create cascading lists where the selection in one dropdown determines the options available in another. This feature enhances data entry efficiency and accuracy by limiting choices based on previous selections. Commonly used in forms and data management, dependent dropdowns help streamline workflows and ensure consistency in data input.<\/p>\n<p><strong>Key Takeaways:<\/strong><\/p>\n<ul>\n<li>Simplified Data Entry: Cascading drop-down lists streamline the data entry process by presenting users with only relevant choices based on prior selections, reducing the likelihood of errors.<\/li>\n<li>Data Preparation: Proper setup is crucial for creating effective cascading lists. Ensure your data is well-organized in separate columns with no duplicates or blanks to maintain data integrity.<\/li>\n<li>Primary List Setup: The primary drop-down list is created using Excel\u2019s Data Validation feature. This list serves as the foundation for subsequent dependent lists and must be clear and well-defined.<\/li>\n<li>Connecting Secondary Lists: Secondary (dependent) lists are linked to the primary list using named ranges and the INDIRECT function. Accurate naming and range definition are essential for seamless functionality.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent 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\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/dependent-cascading-drop-down-lists\/#Introduction_to_Cascading_Drop-Down_Lists_in_Excel\" title=\"Introduction to Cascading Drop-Down Lists in Excel\">Introduction to Cascading Drop-Down Lists in Excel<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/dependent-cascading-drop-down-lists\/#Setting_the_Stage_for_Your_Drop-Down_Lists\" title=\"Setting the Stage for Your Drop-Down Lists\">Setting the Stage for Your Drop-Down Lists<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/dependent-cascading-drop-down-lists\/#Step-by-Step_Creation_of_Main_Drop-Down_List\" title=\"Step-by-Step Creation of Main Drop-Down List\">Step-by-Step Creation of Main Drop-Down List<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/dependent-cascading-drop-down-lists\/#Crafting_the_Dependent_Child_Drop-Down_List\" title=\"Crafting the Dependent (Child) Drop-Down List\">Crafting the Dependent (Child) Drop-Down List<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/dependent-cascading-drop-down-lists\/#Time-Saving_Tips_and_Tricks\" title=\"Time-Saving Tips and Tricks\">Time-Saving Tips and Tricks<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/dependent-cascading-drop-down-lists\/#FAQs_About_Dependent_Cascading_Drop_Down_Lists\" title=\"FAQs About Dependent Cascading Drop Down Lists\">FAQs About Dependent Cascading Drop Down Lists<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Introduction_to_Cascading_Drop-Down_Lists_in_Excel\"><\/span>Introduction to Cascading Drop-Down Lists in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>The Power of Dependent Data Selection<\/h3>\n<p>Imagine choosing a category like &#8216;Produce Type&#8217; and immediately having another list populated with relevant options like assorted fruits or vegetables. That&#8217;s the impressive power of dependent data selection in Excel. With dependent <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/conditionally-formatting-a-drop-down-list\/\" target=\"_blank\" rel=\"noopener\">drop-down lists<\/a>, a choice in one cell influences the list of options in another, reducing errors and simplifying the process of data entry.<\/p>\n<h3>Streamlining Data Entry with Cascading Functionality<\/h3>\n<p>Cascading functionality in Excel is a true time-saver. Instead of sifting through irrelevant choices, you efficiently zoom in on the data that matters, simply by making a selection from a prior related drop-down list. It&#8217;s an elegant way to streamline <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-data-entry-form-excel\/\" target=\"_blank\" rel=\"noopener\">data entry and<\/a> guide users through a series of choices, ensuring they can&#8217;t select a &#8220;Drink&#8221; when they should be picking a &#8220;Category of beverage.<\/p>\n<h2><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"Setting_the_Stage_for_Your_Drop-Down_Lists\"><\/span>Setting the Stage for Your Drop-Down Lists<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Preparing Your Data for Cascading Lists<\/h3>\n<p>Before diving into creating cascading lists, you need to lay the groundwork. Arrange your data neatly in separate columns: one for each level of your cascading sequence. Ensure the data is clean, with no <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/highlight-duplicates-in-excel\/\" target=\"_blank\" rel=\"noopener\">duplicates<\/a> or blank entries, as they could lead to confusion or errors down the line. Think of it as setting the stage for your Excel masterpiece where every cell plays a pivotal role.<\/p>\n<p>The data set looks like this;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Cascading Drop Down in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/05\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia648358762024-05-22T193A063A04.419593_Excel_Mastery_Create_Dependent_Cascading_Drop_Down_Lists_in_Minutes_-1.png\" alt=\"Cascading Drop Down in Excel\" width=\"308\" height=\"244\" \/><\/p>\n<h3>Why Proper Setup is Crucial for Dependable Drop-Downs<\/h3>\n<p>Starting off on the right foot with a well-structured setup is key to avoiding headaches later. Proper preparation prevents performance problems; this adage holds especially true for dependable drop-downs. By establishing a sound data foundation, you ensure that your cascading lists work harmoniously, providing users with a seamless experience and maintaining data integrity across your workbook.<\/p>\n<h2><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"Step-by-Step_Creation_of_Main_Drop-Down_List\"><\/span>Step-by-Step Creation of Main Drop-Down List<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Defining Your Primary Data Choices<\/h3>\n<p>Your primary data choices act as the cornerstone of your drop-down lists. These are your headers or main categories that will guide the rest of the selections. Lay these out clearly and distinctly, as they dictate what options will be available in the subsequent dependent lists. It&#8217;s about striking the right balance \u2013 detailed enough to cover all options, yet concise enough to prevent overwhelm.<\/p>\n<h3>Applying Data Validation for Your First List<\/h3>\n<p>To create your first drop-down list, you&#8217;ll employ <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-data-validation\/\" target=\"_blank\" rel=\"noopener\">Excel&#8217;s Data Validation feature<\/a>. It&#8217;s a straightforward process where you:<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span> <\/strong>Choose the cell that will house your main drop-down.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Cascading Drop Down in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/05\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia648358762024-05-22T193A063A23.023910_Excel_Mastery_Create_Dependent_Cascading_Drop_Down_Lists_in_Minutes_-2.png\" alt=\"Cascading Drop Down in Excel\" width=\"480\" height=\"797\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2: <\/strong><\/span>Go to the &#8216;Data&#8217; tab, and click on &#8216;<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/dynamic-data-validation-list-in-excel\/\" target=\"_blank\" rel=\"noopener\">Data Validation<\/a>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Cascading Drop Down in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/05\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia648358762024-05-22T193A063A51.874408_Excel_Mastery_Create_Dependent_Cascading_Drop_Down_Lists_in_Minutes_-3.png\" alt=\"Cascading Drop Down in Excel\" width=\"1347\" height=\"436\" \/><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3:<\/span> <\/strong>From the settings, select &#8216;List&#8217; under the validation criteria.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Cascading Drop Down in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/05\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia648358762024-05-22T193A073A06.327257_Excel_Mastery_Create_Dependent_Cascading_Drop_Down_Lists_in_Minutes_-4.png\" alt=\"Cascading Drop Down in Excel\" width=\"1174\" height=\"529\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4: <\/strong><\/span>Set the source to reference the cells containing your primary choices i.e., the categories.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Cascading Drop Down in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/05\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia648358762024-05-22T193A073A22.575354_Excel_Mastery_Create_Dependent_Cascading_Drop_Down_Lists_in_Minutes_-5.png\" alt=\"Cascading Drop Down in Excel\" width=\"1116\" height=\"797\" \/><\/p>\n<p><strong>RESULT:<\/strong> By completing these steps, you&#8217;ll have set up a user-friendly, error-resistant primary drop-down list, ready to be connected to your dependent lists.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Cascading Drop Down in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/05\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia648358762024-05-22T193A073A37.057168_Excel_Mastery_Create_Dependent_Cascading_Drop_Down_Lists_in_Minutes_-6.png\" alt=\"Cascading Drop Down in Excel\" width=\"530\" height=\"413\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Crafting_the_Dependent_Child_Drop-Down_List\"><\/span>Crafting the Dependent (Child) Drop-Down List<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Connecting Secondary Lists to the Primary Selection<\/h3>\n<p>To achieve the magic of cascading, you must now connect your secondary lists to the primary selection. This involves a bit of Excel wizardry with named ranges and the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/indirect-function-excel\/\" target=\"_blank\" rel=\"noopener\">INDIRECT function<\/a> to ensure that the choices in your second drop-down are contingent on what was selected in the first list.<\/p>\n<p>It requires attention to detail, as the named ranges must precisely match the primary entries for the connection to work flawlessly.<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span> Create Named Ranges:<\/strong> Define <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-a-named-range-in-excel\/\" target=\"_blank\" rel=\"noopener\">named ranges<\/a> for each category based on the primary list items using Formulas &gt; Name Manager.<\/p>\n<ul>\n<li>Select the Data Range: Highlight the cells that contain the data for one of your secondary categories.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Cascading Drop Down in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/05\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia648358762024-05-22T193A083A50.458881_Excel_Mastery_Create_Dependent_Cascading_Drop_Down_Lists_in_Minutes_-7.png\" alt=\"Cascading Drop Down in Excel\" width=\"331\" height=\"362\" \/><\/p>\n<ul>\n<li>Open Name Manager: Go to the Formulas tab and click on <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-a-named-range-in-excel\/\" target=\"_blank\" rel=\"noopener\">Name Manager<\/a>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Cascading Drop Down in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/05\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia648358762024-05-22T193A103A06.663757_Excel_Mastery_Create_Dependent_Cascading_Drop_Down_Lists_in_Minutes_-8.png\" alt=\"Cascading Drop Down in Excel\" width=\"946\" height=\"569\" \/><\/p>\n<ul>\n<li>Create a New Named Range: Click New, enter a name that exactly matches the corresponding primary list item, and ensure the range is correctly referenced. Click OK.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Cascading Drop Down in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/05\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia648358762024-05-22T193A103A22.694447_Excel_Mastery_Create_Dependent_Cascading_Drop_Down_Lists_in_Minutes_-_GIF_9.gif\" alt=\"Cascading Drop Down in Excel\" width=\"1594\" height=\"946\" \/><\/p>\n<ul>\n<li>Repeat for Other Categories: Repeat the above steps for each secondary category, ensuring each named range corresponds accurately to its primary list item.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span> Prepare Secondary List:<\/strong> Select the cell for the secondary drop-down list, and go to Data &gt; Data Validation.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Cascading Drop Down in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/05\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia648358762024-05-22T193A113A29.295315_Excel_Mastery_Create_Dependent_Cascading_Drop_Down_Lists_in_Minutes_-_11.png\" alt=\"Cascading Drop Down in Excel\" width=\"1349\" height=\"623\" \/><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3:<\/span> Use INDIRECT Function: <\/strong>Choose <strong>List<\/strong> then in the source field, enter =INDIRECT(E5), assuming E5 is the cell with the primary selection.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Cascading Drop Down in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/05\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia648358762024-05-22T193A113A40.482366_Excel_Mastery_Create_Dependent_Cascading_Drop_Down_Lists_in_Minutes_-_12.png\" alt=\"Cascading Drop Down in Excel\" width=\"1443\" height=\"626\" \/><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4:<\/span> Verify Functionality:<\/strong> Test by selecting different options in the primary list to ensure the secondary list updates correctly.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Cascading Drop Down in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/05\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia648358762024-05-22T193A113A54.813640_Excel_Mastery_Create_Dependent_Cascading_Drop_Down_Lists_in_Minutes_-GIF_13.gif\" alt=\"Cascading Drop Down in Excel\" width=\"1356\" height=\"722\" \/><\/p>\n<p><strong>NOTE: Adjust Named Ranges:<\/strong> Ensure named ranges exactly match the primary list items to avoid errors.<\/p>\n<h3><\/h3>\n<h2><span class=\"ez-toc-section\" id=\"Time-Saving_Tips_and_Tricks\"><\/span>Time-Saving Tips and Tricks<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Speeding Through Drop-Down List Creation<\/h3>\n<p>To speed through the creation of drop-down lists, familiarize yourself with <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/\" target=\"_blank\" rel=\"noopener\">Excel shortcuts<\/a> and embrace the power of drag-and-drop for copying your Data Validation settings. You can also use templates or previously crafted lists as a starting point, saving valuable time. Automating repetitive tasks with macros can be another game-changer, cutting down the manual workload and ensuring a uniform structure across your workbook.<\/p>\n<h3><\/h3>\n<h2><span class=\"ez-toc-section\" id=\"FAQs_About_Dependent_Cascading_Drop_Down_Lists\"><\/span>FAQs About Dependent Cascading Drop Down Lists<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>What is a dropdown list?<\/h3>\n<p>A dropdown list in Excel is a helpful feature that lets users select a value from a set of predefined options within a cell. This not only speeds up data entry but also reduces mistakes, as choices are limited to those in your list, ensuring consistency and accuracy in your data.<\/p>\n<h3>What Are Dependent Cascading Drop-Down Lists in Excel?<\/h3>\n<p>Dependent <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-a-cascading-list-box-1702993d-d670-4d9b-8063-acabacb76605\" target=\"_blank\" rel=\"nofollow noopener\">cascading drop-down lists in Excel<\/a> are connected lists where the options in a secondary drop-down change based on the selection made in the first drop-down. It&#8217;s a smart way to navigate through layers of data and is particularly useful for handling large, complex datasets with interrelated attributes.<\/p>\n<h3>Can You Create a Cascade with More Than Two Levels?<\/h3>\n<p>Absolutely, you can create a cascade with more than two levels in Excel. This allows for an even more detailed and structured approach to data selection, guiding the user through a series of dependent choices. Multi-level cascading is ideal for complex data categorization where selections need to be refined at each stage.<\/p>\n<h3>How Do You Update or Modify an Existing Cascading Drop-Down List?<\/h3>\n<p>To update or modify an existing cascading drop-down list, you typically need to adjust the named ranges or Data Validation settings that control the lists. Adding or changing entries may also require updates to the dependent lists\u2019 references. Regular maintenance ensures that your cascading lists remain functional and current with your dataset.<\/p>\n<h3>How many levels of dynamic (cascading) dropdowns can you construct ?<\/h3>\n<p>You can construct numerous levels of dynamic (cascading) dropdowns, typically as many as needed, as long as the hierarchy remains clear and manageable. However, bear in mind that the more levels you add, the more complex it becomes to manage and maintain the data. Therefore, for practicality and ease of use, it&#8217;s best to keep the levels to a reasonable number.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Unlock Excel&#8217;s potential with our guide on cascading drop-down lists. Simplify data management and improve user experience in your spreadsheets.<\/p>\n","protected":false},"author":1,"featured_media":46361,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"How to Create Dependent Cascading Drop Down Lists in Excel Fast","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[34],"tags":[2749,2750,2751,2752],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/46074"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=46074"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/46074\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/46361"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=46074"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=46074"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=46074"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}