{"id":2717,"date":"2014-04-18T17:00:24","date_gmt":"2014-04-18T15:00:24","guid":{"rendered":"https:\/\/www.itlektor.cz\/?p=2717"},"modified":"2020-09-04T09:42:21","modified_gmt":"2020-09-04T07:42:21","slug":"moznost-nabidky-prejit-na-jinak-go-to-special","status":"publish","type":"post","link":"https:\/\/www.itlektor.cz\/en\/moznost-nabidky-prejit-na-jinak-go-to-special\/","title":{"rendered":"Go to special options"},"content":{"rendered":"<p><\/p>\n<p style=\"text-align: justify;\">When selecting\u00a0the cells in Excel it is sometimes necessary to quickly find cells with some special features. E.g. we want to quickly select the blank cells or cells containing only numbers. Other times, it fits in\u00a0group or summaries selecting only the visible cells. In short, there are situations where users would give anything in the world for the opportunity to facilitate a selection of cells, and therefore there is an opion <strong>Go to &#8230; special<\/strong>. Similarly works the <a href=\"https:\/\/www.itlektor.cz\/en\/microsoft-excel\/excel-paste-special-options\/\">Paste Special<\/a> option, which you can read about\u00a0in previous article. 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<h2>Go to Special<\/h2>\n<p style=\"text-align: justify;\">Firstly, select the range of cells or the entire table in which you want to find a specific property. Use the mouse or <a href=\"https:\/\/www.itlektor.cz\/en\/microsoft-excel\/excel-keyboard-shortcuts-special-symbols\/\">keyboard shortcuts<\/a>. After that, just look into the following icons:<\/p>\n<ul>\n<li><strong>Home<\/strong> tab\u00a0&gt; group\u00a0Editing &gt; icon\u00a0Find and select\u00a0 &gt;\u00a0<strong>Go to special<\/strong><\/li>\n<li>or with a key combination\u00a0<strong>CTRL+G<\/strong> and there Special option<\/li>\n<\/ul>\n<div id='gallery-2' class='gallery galleryid-2717 gallery-columns-2 gallery-size-thumbnail'><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/04\/goto1.jpg\"><img decoding=\"async\" width=\"130\" height=\"130\" src=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/04\/goto1-130x130.jpg\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" aria-describedby=\"gallery-2-2718\" srcset=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/04\/goto1-130x130.jpg 130w, https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/04\/goto1-150x150.jpg 150w\" sizes=\"(max-width: 130px) 100vw, 130px\" title=\"\"><\/a>\n\t\t\t<\/div>\n\t\t\t\t<figcaption class='wp-caption-text gallery-caption' id='gallery-2-2718'>\n\t\t\t\tNaj\u00edt a vybrat\n\t\t\t\t<\/figcaption><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon portrait'>\n\t\t\t\t<a href=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/04\/goto2.jpg\"><img decoding=\"async\" width=\"130\" height=\"130\" src=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/04\/goto2-130x130.jpg\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" aria-describedby=\"gallery-2-2719\" srcset=\"https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/04\/goto2-130x130.jpg 130w, https:\/\/www.itlektor.cz\/wp-content\/uploads\/2014\/04\/goto2-150x150.jpg 150w\" sizes=\"(max-width: 130px) 100vw, 130px\" title=\"\"><\/a>\n\t\t\t<\/div>\n\t\t\t\t<figcaption class='wp-caption-text gallery-caption' id='gallery-2-2719'>\n\t\t\t\tP\u0159ej\u00edt na &#8211; jinak\n\t\t\t\t<\/figcaption><\/figure>\n\t\t<\/div>\n\n<h2>Properties\u00a0options<\/h2>\n<p>Description of the most interesting options in menu Go to &#8211; special are\u00a0mentioned in following\u00a0list:<\/p>\n<ul>\n<li><i>Comments<\/i>\u00a0&#8230; identify cells containing comments<\/li>\n<li><em>Constants<\/em>\u00a0&#8230; identify cells containing a value\n<ul>\n<li><em>number\u00a0<\/em>&#8230;\u00a0number<\/li>\n<li><em>text\u00a0<\/em>&#8230;\u00a0text string<\/li>\n<\/ul>\n<\/li>\n<li><em>Formulas<\/em>\u00a0&#8230; identify cells containing formulas\n<ul>\n<li><i>error<\/i>&#8230; results for Error type #N\/A, #DIV\/0\u00a0etc.<\/li>\n<\/ul>\n<\/li>\n<li><em>Blanks\u00a0<\/em>&#8230; identify empty cells<\/li>\n<li><em>Current array<\/em>\u00a0&#8230; marks the entire array\u00a0in which you have a mouse<\/li>\n<li><em>Visible cells only<\/em>\u00a0&#8230; identify cells that are not hidden or grouped<\/li>\n<li><em>Conditional formatting\u00a0<\/em>&#8230; identify cells that have set rules across Conditional Formatting<\/li>\n<li><em>Data validation<\/em>\u00a0&#8230; identify cells that have set rules through the Data Validation\n<ul>\n<li><em>all\u00a0<\/em>&#8230; mark all cells with the any\u00a0rule<\/li>\n<li><em>same<\/em>\u00a0&#8230; marks only the cells with the same rule that has an active selected cell<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><\/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>When selecting\u00a0the cells in Excel it is sometimes necessary to quickly find cells with some special features. E.g. we want to quickly select the blank cells or cells containing only numbers. Other times, it fits in\u00a0group or summaries selecting only the visible cells. In short, there are situations where users would give anything in the [&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":2719,"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],"tags":[10,58,50],"_links":{"self":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/2717"}],"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=2717"}],"version-history":[{"count":0,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/posts\/2717\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media\/2719"}],"wp:attachment":[{"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/media?parent=2717"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/categories?post=2717"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itlektor.cz\/en\/wp-json\/wp\/v2\/tags?post=2717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}