{"id":12095,"date":"2011-11-20T14:07:00","date_gmt":"2011-11-20T14:07:00","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=769"},"modified":"2017-10-17T05:49:26","modified_gmt":"2017-10-17T05:49:26","slug":"drop-down-list-in-excel","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/","title":{"rendered":"How to Create Drop Down List in Excel"},"content":{"rendered":"<p>Drop down list is made in Excel Cell to limit the Entry in to a Cell from a predefined set of values. It means you are restricted to select one value out of set of Predefined values. On creating a drop down list on a cell or cell-range, one drop-down will be displayed with set of predefined values, on selecting that cell and user can select one value out of that. You can not enter any value other than those predefined values.<br \/>\nNow we will see how to make Drop Down List in Excel 2003, 2007 and 2010.<\/p>\n<ul>\n<li><a href=\"#excel-2003\">How to Create Drop Down in Excel 2003<\/a><\/li>\n<li><a href=\"#excel-2007-2010\">How to Create Drop Down in Excel 2007\/2010<\/a><\/li>\n<li><a href=\"#named-range-excel\">How to Create Drop Down using named Range <\/a><\/li>\n<\/ul>\n<p><a name=\"excel-2003\"><\/a><\/p>\n<h2>How to Create Drop Down in Excel 2003<\/h2>\n<p>Follow below steps to Create Drop Down List in Excel 2003:<\/p>\n<p>Step 1. Click on <strong>Data &#8211;&gt; Data Validation option<\/strong> from the Top Menu<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Drop-down-list-2003-1.png\" alt=\"drop-down-list\" \/><\/p>\n<p>Step 2. In validation criteria Select &#8220;List&#8221; from the Drop down<\/p>\n<p>Step 3. Click on Settings tab in the dialog box.<\/p>\n<p>Step 4. Select &#8220;List&#8221;option from the Drop Down<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Drop-down-list-2003-2.png\" alt=\"drop-down-list\" \/><\/p>\n<p>Step 5. Now Enter the List of Values in Source, you want to Add in the Drop down. Write all the Values separated by Comma (,).<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Drop-down-list-2003-3.png\" alt=\"drop-down-list\" \/><\/p>\n<p><strong>Note: <\/strong>If you want to populate this list from the Values entered in to a Cell Range.<\/p>\n<p><strong>For Example:<\/strong> If you want to populate the Values from the Cell Range A1 to A5. So Enter the Source as<strong> =$A$1:$A$5<\/strong>. Whatever you enter in this Cell Range, will be shown in the Drop Down List.<\/p>\n<p>Step 6. A down arrow should appear in the Selected Cell as shown below.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Drop-down-list-2003-4.png\" alt=\"drop-down-list\" \/><\/p>\n<h2>How to Create Drop Down in Excel 2007\/2010<\/h2>\n<p><a name=\"excel-2007-2010\"><\/a><\/p>\n<p>Follow below steps to Create Drop Down List in Excel 2007\/2010:<\/p>\n<p>Step 1. Click on <strong>Data Tab &#8211;&gt; Data Validation option<\/strong> from the Ribbon<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Drop-down-list-2007-1.png\" alt=\"drop-down-list\" \/><\/p>\n<p>Step 2. In validation criteria Select &#8220;List&#8221; from the Drop down<\/p>\n<p>Step 3. Click on Settings tab in the dialog box.<\/p>\n<p>Step 4. Select &#8220;List&#8221;option from the Drop Down<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Drop-down-list-2003-2.png\" alt=\"drop-down-list\" \/><\/p>\n<p>Step 5. Now Enter the List of Values in Source, you want to Add in the Drop down. Write all the Values separated by Comma (,).<\/p>\n<p><strong>Note: <\/strong>If you want to populate this list from the Values entered in to a Cell Range.<\/p>\n<p><strong>For Example:<\/strong> If you want to populate the Values from the Cell Range A1 to A5. So Enter the Source as<strong> =$A$1:$A$5<\/strong>. Whatever you enter in this Cell Range, will be shown in the Drop Down List.<\/p>\n<p>Step 6. A down arrow should appear in the Selected Cell as shown below.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Drop-down-list-2007-3.png\" alt=\"drop-down-list\" \/><\/p>\n<p><a name=\"named-range-excel\"><\/a><\/p>\n<h2>How to Create Drop Down using named Range<\/h2>\n<p>Follow below steps to Create Drop Down List using Named Range in Excel:<\/p>\n<p>Step 1. For this first we need to make the Named Range in the workbook.<br \/>\nStep 2. To make the Named Range, Select the Range<br \/>\nStep 3. Press <strong>Ctrl+F3<\/strong><br \/>\n<br \/><img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Defined-Name.png\" alt=\"defined-names-in-excel\" \/><\/br><br \/>\nStep 4. Click on <strong>&#8220;New Button&#8221;<\/strong> in the Name Manager Dialog Box.<br \/>\n<\/br><img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Defined-Name-3.png\" alt=\"defined-names-in-excel\" \/><\/br><br \/>\nStep 5. Give a <strong>Name<\/strong> and <strong>Select the Scope<\/strong><br \/>\nStep 6. Click OK<\/br><br \/>\n<img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Defined-Name-4.png\" alt=\"defined-names-in-excel\" \/><\/br><br \/>\nStep 7. Click Close.<br \/>\nStep 8. Now Ranged Name is created.<br \/>\n<\/br><img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Defined-Name-5.png\" alt=\"defined-names-in-excel\" \/><\/br><br \/>\nStep 9. To Create the Drop Down List Follow the below Instructions:<br \/>\nStep 10. Select the Cell or Cell Range where you want to Create the Drop down list.<br \/>\nStep 11. Go to <strong>Data Validation &#8211;&gt; Select List<\/strong><br \/>\nStep 12. In Source Data enter <strong><em>=Ranged Name which is created above<\/em><\/strong><\/p>\n<p><\/br><img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2011\/11\/Defined-Name-6.png\" alt=\"defined-names-in-excel\" \/><\/br><\/p>\n<span class=\"et_bloom_bottom_trigger\"><\/span>","protected":false},"excerpt":{"rendered":"<p>Drop down list is made in Excel Cell to limit the Entry in to a Cell from a predefined set of values. It means you are restricted to select one value out of set of Predefined values. On creating a drop down list on a cell or cell-range, one drop-down will be displayed with set [&hellip;]<\/p>\n","protected":false},"author":45,"featured_media":779,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1672,1673,1682],"tags":[],"class_list":["post-12095","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-formula","category-excel-functions","category-popular-articles"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.5 (Yoast SEO v23.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Create Drop Down List in Excel - Let&#039;s excel in Excel<\/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:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Create Drop Down List in Excel\" \/>\n<meta property=\"og:description\" content=\"Drop down list is made in Excel Cell to limit the Entry in to a Cell from a predefined set of values. It means you are restricted to select one value out of set of Predefined values. On creating a drop down list on a cell or cell-range, one drop-down will be displayed with set [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Let&#039;s excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2011-11-20T14:07:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-10-17T05:49:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/vmlogger.com_-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"How to Create Drop Down List in Excel\",\"datePublished\":\"2011-11-20T14:07:00+00:00\",\"dateModified\":\"2017-10-17T05:49:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/\"},\"wordCount\":549,\"commentCount\":6,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"\",\"articleSection\":[\"Excel Formula\",\"Excel Functions\",\"Popular Articles\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/\",\"name\":\"How to Create Drop Down List in Excel - Let&#039;s excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"\",\"datePublished\":\"2011-11-20T14:07:00+00:00\",\"dateModified\":\"2017-10-17T05:49:26+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Formula\",\"item\":\"https:\/\/vmlogger.com\/excel\/excel-formula\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Create Drop Down List in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let&#039;s excel in Excel\",\"description\":\"Let&#039;s share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore &amp; currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Create Drop Down List in Excel - Let&#039;s excel in Excel","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:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"How to Create Drop Down List in Excel","og_description":"Drop down list is made in Excel Cell to limit the Entry in to a Cell from a predefined set of values. It means you are restricted to select one value out of set of Predefined values. On creating a drop down list on a cell or cell-range, one drop-down will be displayed with set [&hellip;]","og_url":"https:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/","og_site_name":"Let&#039;s excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2011-11-20T14:07:00+00:00","article_modified_time":"2017-10-17T05:49:26+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/vmlogger.com_-1.png","type":"image\/png"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"How to Create Drop Down List in Excel","datePublished":"2011-11-20T14:07:00+00:00","dateModified":"2017-10-17T05:49:26+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/"},"wordCount":549,"commentCount":6,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/#primaryimage"},"thumbnailUrl":"","articleSection":["Excel Formula","Excel Functions","Popular Articles"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/","url":"https:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/","name":"How to Create Drop Down List in Excel - Let&#039;s excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/#primaryimage"},"thumbnailUrl":"","datePublished":"2011-11-20T14:07:00+00:00","dateModified":"2017-10-17T05:49:26+00:00","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2011\/11\/drop-down-list-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Formula","item":"https:\/\/vmlogger.com\/excel\/excel-formula\/"},{"@type":"ListItem","position":3,"name":"How to Create Drop Down List in Excel"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let&#039;s excel in Excel","description":"Let&#039;s share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore &amp; currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12095"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=12095"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12095\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12095"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12095"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12095"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}