{"id":42,"date":"2025-10-12T19:54:59","date_gmt":"2025-10-12T17:54:59","guid":{"rendered":"https:\/\/callmelazy.eu\/?page_id=42"},"modified":"2026-08-08T12:29:29","modified_gmt":"2026-08-08T10:29:29","slug":"power-dropdown","status":"publish","type":"page","link":"https:\/\/callmelazy.eu\/?page_id=42","title":{"rendered":"Power Dropdown"},"content":{"rendered":"\n<p class=\"has-normal-font-size wp-block-paragraph\">In-cell dropdown lists are an incredibly powerful Microsoft Excel feature. Power Dropdown makes them even more powerful:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"has-normal-font-size\">The list is displayed in a popup window, making it more user-friendly.<\/li>\n\n\n\n<li class=\"has-normal-font-size\">The list automatically extends to the entire table column, if your data validation list is part of a table.<\/li>\n\n\n\n<li class=\"has-normal-font-size\">You can choose to display additional text (a \u201clabel\u201d), next to the selectable value. From another column of the table you are picking the valid values from, for example.<\/li>\n\n\n\n<li class=\"has-normal-font-size\">The values are deduped and you can also take labels (see above) into account while deduping.<\/li>\n\n\n\n<li class=\"has-normal-font-size\">You can filter the list by typing. If you added labels, the filter also applies to them.<\/li>\n\n\n\n<li class=\"has-normal-font-size\">A button can take you to the data validation list, very handy if you can&#8217;t remember where it was.<\/li>\n\n\n\n<li class=\"has-normal-font-size\">With the Premium version, you can also pre-define filters, to limit the user choices.<\/li>\n<\/ul>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Check it out:<\/p>\n\n\n<div class=\"guten-video-wrapper\" data-property=\"{&quot;url&quot;:&quot;https:\\\/\\\/www.youtube.com\\\/watch?v=9DRjNOwsFwo&quot;,&quot;class&quot;:&quot;guten-video-background&quot;,&quot;width&quot;:&quot;100%&quot;,&quot;height&quot;:&quot;500px&quot;,&quot;playing&quot;:false,&quot;muted&quot;:false,&quot;loop&quot;:false,&quot;controls&quot;:true,&quot;playsinline&quot;:true,&quot;style&quot;:{},&quot;config&quot;:{&quot;youtube&quot;:{&quot;playerVars&quot;:{&quot;start&quot;:0,&quot;end&quot;:0}}}}\"><\/div>\n\n\n<p class=\"wp-block-paragraph\">Click <a href=\"https:\/\/www.youtube.com\/watch?v=rlF-HVhocEI\">here <\/a>to see how to implement cascading dropdown lists using Power Dropdown.<\/p>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">Click <a href=\"https:\/\/appsource.microsoft.com\/en-us\/product\/office\/WA200008888\">here<\/a> to install Power Dropdown and start your 3-month trial.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Once the trial period is over, you have the following subscription options:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Standard subscription: 3 EUR per user per year<\/li>\n\n\n\n<li>Premium subscription: 6 EUR per user per year<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Taxes may apply and will be calculated at checkout.<\/em><\/p>\n\n\n\n<div class=\"wp-block-group is-nowrap is-layout-flex wp-container-core-group-is-layout-3a88641f wp-block-group-is-layout-flex\">\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/appsource.microsoft.com\/en-us\/product\/office\/WA200008888\" target=\"_blank\" rel=\" noreferrer noopener\"><img decoding=\"async\" src=\"https:\/\/callmelazy.eu\/wp-content\/uploads\/microsoft\/MS_AppSource.png\" alt=\"\" class=\"wp-image-258\"\/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/portal.azure.com\/#view\/Microsoft_Azure_Marketplace\/GalleryItemDetailsBladeNopdl\/preview\/undefined\/id\/callmelazy.powerdropdown\" target=\"_blank\" rel=\" noreferrer noopener\"><img decoding=\"async\" src=\"https:\/\/callmelazy.eu\/wp-content\/uploads\/microsoft\/MS_Azure_Marketplace.png\" alt=\"\" class=\"wp-image-259\"\/><\/a><\/figure>\n<\/div>\n\n\n\n<p class=\"has-normal-font-size wp-block-paragraph\">If you&#8217;d like to learn more about Power Dropdown, click <a href=\"https:\/\/powerdropdown.callmelazy.eu\/help.html\" target=\"_blank\" rel=\"noreferrer noopener\">here <\/a>for the user guide.<br><a href=\"https:\/\/powerdropdown.callmelazy.eu\/assets\/Power%20Dropdown%20Demo%20v2.xlsx\">Download a demo file<\/a> to experience Power Dropdown using some pre-defined in-cell dropdowns.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In-cell dropdown lists are an incredibly powerful Microsoft Excel feature. Power Dropdown makes them even more powerful: Check it out: Click here to see how to implement cascading dropdown lists using Power Dropdown. Click here to install Power Dropdown and start your 3-month trial. Once the trial period is over, you have the following subscription [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":33,"parent":0,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"wp-custom-template-product-page","meta":{"footnotes":""},"class_list":["post-42","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/callmelazy.eu\/index.php?rest_route=\/wp\/v2\/pages\/42","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/callmelazy.eu\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/callmelazy.eu\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/callmelazy.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/callmelazy.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=42"}],"version-history":[{"count":16,"href":"https:\/\/callmelazy.eu\/index.php?rest_route=\/wp\/v2\/pages\/42\/revisions"}],"predecessor-version":[{"id":94,"href":"https:\/\/callmelazy.eu\/index.php?rest_route=\/wp\/v2\/pages\/42\/revisions\/94"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/callmelazy.eu\/index.php?rest_route=\/wp\/v2\/media\/33"}],"wp:attachment":[{"href":"https:\/\/callmelazy.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=42"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}