{"id":1624,"date":"2013-03-19T16:08:09","date_gmt":"2013-03-19T15:08:09","guid":{"rendered":"https:\/\/www.itlektor.cz\/?p=1624"},"modified":"2020-09-04T09:48:12","modified_gmt":"2020-09-04T07:48:12","slug":"videonavod-vyber-prazdnych-bunek","status":"publish","type":"post","link":"https:\/\/www.itlektor.cz\/en\/videonavod-vyber-prazdnych-bunek\/","title":{"rendered":"6. Videotutorial &#8211; select blank cells"},"content":{"rendered":"<p><\/p>\n<p style=\"text-align: justify;\">I have prepared another video; and this time we are back to Excel, which will introduce a quick tweaks to select empty cells. You need the table quickly find and select\u00a0blank cells? This trick saves a lot of time. See one minute video and everything also\u00a0try on\u00a0the attached\u00a0file. If this guide has helped you, become a fan on <a href=\"http:\/\/www.facebook.com\/itlektorcz\" target=\"_blank\" rel=\"noopener\">Facebook<\/a> and recommend this site to your friends, it\u00a0can be useful for them too.<\/p>\n<p style=\"text-align: justify;\"><em>Please note that this tutorial is presented in czech language, with english subtitles.<\/em><\/p>\n<div class=\"potter-video\"><iframe title=\"#6 - V\u00fdb\u011br pr\u00e1zdn\u00fdch bun\u011bk v Excelu - videon\u00e1vod (selecting blank cells in Excel)\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/ovDRapcQnTw?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/div>\n<p>Source file can be downloaded\u00a0<a title=\"Pr\u00e1zdn\u00e9 bu\u0148ky\" href=\"https:\/\/www.itlektor.cz\/soubory\/6-videonavod-prazdnebunky.xlsx\">here<\/a>.<\/p>\n<h2>Inserting values into empty cells<\/h2>\n<p>In addition to coloring, this procedure may also be applied eg. for filling empty cells with specified value.<\/p>\n<p>After selecting the blank cells using the procedure mentioned in the video just type in the formula bar a formula or value, and for insertion into all selected cells at once use the key combination <strong>Ctrl + Enter<\/strong>.<\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>I have prepared another video; and this time we are back to Excel, which will introduce a quick tweaks to select empty cells. You need the table quickly find and select\u00a0blank cells? This trick saves a lot of time. See one minute video and everything also\u00a0try on\u00a0the attached\u00a0file. If this guide has helped you, become [&hellip;]<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":1626,"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\/1624"}],"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=1624"}],"version-history":[{"count":0,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/1624\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media\/1626"}],"wp:attachment":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media?parent=1624"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/categories?post=1624"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/tags?post=1624"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}