<\/p>\n
When completing tables we may offer some items to be selected from\u00a0the list of options using the Data Validation<\/strong>. You can ensure that users always selects one of the values and no other, or perhaps let Excel to calculate a formula or format the cells in a table right by the selected option. Whether in a single cell, or an entire column, validation\u00a0list<\/strong> (or drop-down list) is very useful\u00a0and help users to facilitate their work. How to do it? Learn in this\u00a0video. If this guide has helped you, become a fan on Facebook<\/a> and recommend this site to your friends, it\u00a0can be useful for them too.<\/p>\n Please note that this tutorial is presented in czech language.<\/em><\/p>\n http:\/\/www.youtube.com\/watch?v=-02SeaxG-sI<\/p>\n","protected":false},"excerpt":{"rendered":" When completing tables we may offer some items to be selected from\u00a0the list of options using the Data Validation. You can ensure that users always selects one of the values and no other, or perhaps let Excel to calculate a formula or format the cells in a table right by the selected option. Whether in […]<\/p>\n","protected":false},"author":1,"featured_media":2424,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[3,56],"tags":[10,58,50],"_links":{"self":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/2423"}],"collection":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/comments?post=2423"}],"version-history":[{"count":0,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/2423\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media\/2424"}],"wp:attachment":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media?parent=2423"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/categories?post=2423"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/tags?post=2423"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}