{"id":1584,"date":"2022-03-13T14:01:00","date_gmt":"2022-03-13T14:01:00","guid":{"rendered":"https:\/\/www.bjorn-meijer.nl\/?p=1584"},"modified":"2022-03-11T14:01:56","modified_gmt":"2022-03-11T14:01:56","slug":"f5-toets-in-excel","status":"publish","type":"post","link":"https:\/\/www.bjorn-meijer.nl\/en\/2022\/03\/13\/f5-key-in-excel\/","title":{"rendered":"F5 key in Excel"},"content":{"rendered":"

The F5 key in Excel is a bit of a neglected child within Excel. The possibilities behind this key are very useful, but often unknown.<\/p>\n\n\n\n

The F5 key has already been discussed in the post for the delete empty rows<\/a>.<\/p>\n\n\n\n

In this post we will look at several examples that allow you to perform complex actions in a simple way with the F5 key.<\/p>\n\n\n\n

Empty overwritten template<\/h2>\n\n\n\n

Suppose you keep a weekly record of your energy levels in an Excel document, but you accidentally worked in the template and did not save an empty copy of it. If you are not aware of the operation of the F5 key, this can (depending on the size of the template) be a hell of a job to empty the template. This can be done easily with the F5 key.<\/p>\n\n\n\n

\"Window
Window F5 (Go to)<\/figcaption><\/figure>\n\n\n\n
  1. Make a copy of the template and save it somewhere you can find it.<\/li>
  2. Press the F5 key (Go to).<\/li>
  3. Press the button s<\/span>special<\/strong>.<\/li>
  4. Select the option C<\/span>instants<\/strong> and select the option G<\/span>stalls<\/strong>.<\/li>
  5. click on OK<\/strong> and all cells with numbers are selected. Cells with formulas, texts, etc. are not selected.<\/li>
  6. Press the Delete key and your template is empty again.<\/li><\/ol>\n\n\n\n
    \"Empty
    Empty template using hotkey F5<\/figcaption><\/figure>\n\n\n\n

    Remove all comments from worksheet<\/h2>\n\n\n\n

    Comments in cells are identified by the red triangle in the top right corner of a cell. Do you have a worksheet that you want to remove the comments from in a worksheet? Then proceed as follows:<\/p>\n\n\n\n

    1. Press the F5 key (Go to).<\/li>
    2. Press the button s<\/span>special<\/strong>.<\/li>
    3. Select the option remarkg<\/span>and<\/strong>.<\/li>
    4. Press the button OK.<\/strong><\/li>
    5. Right-click on a selected cell.<\/li>
    6. From the shortcut menu, choose the option onm<\/span>remove acknowledgments<\/strong>.<\/li><\/ol>\n\n\n\n
      \"Delete
      Delete comments using F5<\/figcaption><\/figure>\n\n\n\n

      As you can see in the F5 key (Go To) window, there are many options to select from. With the help of this selection it is again possible to perform other operations.<\/p>","protected":false},"excerpt":{"rendered":"

      The F5 key in Excel is a bit of a neglected child within Excel. The possibilities behind this test are very useful,\u2026 Continue reading<\/a><\/p>","protected":false},"author":1,"featured_media":265,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[7],"tags":[],"class_list":["post-1584","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"\nF5-toets in Excel - Bj\u00f6rn Meijer<\/title>\n<meta name=\"description\" content=\"De F5-toets in Excel is een beetje het ondergeschoven kindje binnen Excel. De mogelijkheden achter deze toets zijn zeer handig, maar vaak ook onbekend.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.bjorn-meijer.nl\/en\/2022\/03\/13\/f5-key-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"F5-toets in Excel\" \/>\n<meta property=\"og:description\" content=\"De F5-toets in Excel is een beetje het ondergeschoven kindje binnen Excel. De mogelijkheden achter deze toets zijn zeer handig, maar vaak ook onbekend. De\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bjorn-meijer.nl\/en\/2022\/03\/13\/f5-key-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Bj\u00f6rn Meijer\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-13T14:01:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-11T14:01:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Bj\u00f6rn Meijer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bj\u00f6rn Meijer\" \/>\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:\/\/www.bjorn-meijer.nl\/2022\/03\/13\/f5-toets-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/03\/13\/f5-toets-in-excel\/\"},\"author\":{\"name\":\"Bj\u00f6rn Meijer\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\"},\"headline\":\"F5-toets in Excel\",\"datePublished\":\"2022-03-13T14:01:00+00:00\",\"dateModified\":\"2022-03-11T14:01:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/03\/13\/f5-toets-in-excel\/\"},\"wordCount\":342,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\"},\"image\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/03\/13\/f5-toets-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png\",\"articleSection\":[\"Excel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.bjorn-meijer.nl\/2022\/03\/13\/f5-toets-in-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/03\/13\/f5-toets-in-excel\/\",\"url\":\"https:\/\/www.bjorn-meijer.nl\/2022\/03\/13\/f5-toets-in-excel\/\",\"name\":\"F5-toets in Excel - Bj\u00f6rn Meijer\",\"isPartOf\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/03\/13\/f5-toets-in-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/03\/13\/f5-toets-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png\",\"datePublished\":\"2022-03-13T14:01:00+00:00\",\"dateModified\":\"2022-03-11T14:01:56+00:00\",\"description\":\"De F5-toets in Excel is een beetje het ondergeschoven kindje binnen Excel. De mogelijkheden achter deze toets zijn zeer handig, maar vaak ook onbekend.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/03\/13\/f5-toets-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.bjorn-meijer.nl\/2022\/03\/13\/f5-toets-in-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/03\/13\/f5-toets-in-excel\/#primaryimage\",\"url\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png\",\"contentUrl\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png\",\"width\":300,\"height\":300,\"caption\":\"Microsoft Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/03\/13\/f5-toets-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.bjorn-meijer.nl\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"F5-toets in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#website\",\"url\":\"https:\/\/www.bjorn-meijer.nl\/de\/\",\"name\":\"Bj\u00f6rn Meijer\",\"description\":\"At My Playground\",\"publisher\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.bjorn-meijer.nl\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\",\"name\":\"Bj\u00f6rn Meijer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1\",\"width\":165,\"height\":165,\"caption\":\"Bj\u00f6rn Meijer\"},\"logo\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/www.bjorn-meijer.nl\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"F5-toets in Excel - Bj\u00f6rn Meijer","description":"De F5-toets in Excel is een beetje het ondergeschoven kindje binnen Excel. De mogelijkheden achter deze toets zijn zeer handig, maar vaak ook onbekend.","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:\/\/www.bjorn-meijer.nl\/en\/2022\/03\/13\/f5-key-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"F5-toets in Excel","og_description":"De F5-toets in Excel is een beetje het ondergeschoven kindje binnen Excel. De mogelijkheden achter deze toets zijn zeer handig, maar vaak ook onbekend. De","og_url":"https:\/\/www.bjorn-meijer.nl\/en\/2022\/03\/13\/f5-key-in-excel\/","og_site_name":"Bj\u00f6rn Meijer","article_published_time":"2022-03-13T14:01:00+00:00","article_modified_time":"2022-03-11T14:01:56+00:00","og_image":[{"width":300,"height":300,"url":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","type":"image\/png"}],"author":"Bj\u00f6rn Meijer","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Bj\u00f6rn Meijer","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.bjorn-meijer.nl\/2022\/03\/13\/f5-toets-in-excel\/#article","isPartOf":{"@id":"https:\/\/www.bjorn-meijer.nl\/2022\/03\/13\/f5-toets-in-excel\/"},"author":{"name":"Bj\u00f6rn Meijer","@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615"},"headline":"F5-toets in Excel","datePublished":"2022-03-13T14:01:00+00:00","dateModified":"2022-03-11T14:01:56+00:00","mainEntityOfPage":{"@id":"https:\/\/www.bjorn-meijer.nl\/2022\/03\/13\/f5-toets-in-excel\/"},"wordCount":342,"commentCount":0,"publisher":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615"},"image":{"@id":"https:\/\/www.bjorn-meijer.nl\/2022\/03\/13\/f5-toets-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","articleSection":["Excel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.bjorn-meijer.nl\/2022\/03\/13\/f5-toets-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.bjorn-meijer.nl\/2022\/03\/13\/f5-toets-in-excel\/","url":"https:\/\/www.bjorn-meijer.nl\/2022\/03\/13\/f5-toets-in-excel\/","name":"F5-toets in Excel - Bj\u00f6rn Meijer","isPartOf":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.bjorn-meijer.nl\/2022\/03\/13\/f5-toets-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.bjorn-meijer.nl\/2022\/03\/13\/f5-toets-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","datePublished":"2022-03-13T14:01:00+00:00","dateModified":"2022-03-11T14:01:56+00:00","description":"De F5-toets in Excel is een beetje het ondergeschoven kindje binnen Excel. De mogelijkheden achter deze toets zijn zeer handig, maar vaak ook onbekend.","breadcrumb":{"@id":"https:\/\/www.bjorn-meijer.nl\/2022\/03\/13\/f5-toets-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bjorn-meijer.nl\/2022\/03\/13\/f5-toets-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bjorn-meijer.nl\/2022\/03\/13\/f5-toets-in-excel\/#primaryimage","url":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","contentUrl":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","width":300,"height":300,"caption":"Microsoft Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.bjorn-meijer.nl\/2022\/03\/13\/f5-toets-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.bjorn-meijer.nl\/de\/"},{"@type":"ListItem","position":2,"name":"F5-toets in Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.bjorn-meijer.nl\/de\/#website","url":"https:\/\/www.bjorn-meijer.nl\/de\/","name":"Bj\u00f6rn Meijer","description":"At My Playground","publisher":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bjorn-meijer.nl\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615","name":"Bj\u00f6rn Meijer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/","url":"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1","width":165,"height":165,"caption":"Bj\u00f6rn Meijer"},"logo":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/www.bjorn-meijer.nl"]}]}},"jetpack_featured_media_url":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/posts\/1584","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/comments?post=1584"}],"version-history":[{"count":4,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/posts\/1584\/revisions"}],"predecessor-version":[{"id":1775,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/posts\/1584\/revisions\/1775"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/media\/265"}],"wp:attachment":[{"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/media?parent=1584"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/categories?post=1584"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/tags?post=1584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}