{"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\/de\/2022\/03\/13\/f5-taste-in-excel\/","title":{"rendered":"F5-Taste in Excel"},"content":{"rendered":"

Die F5-Taste in Excel ist ein etwas vernachl\u00e4ssigtes Kind in Excel. Die M\u00f6glichkeiten hinter diesem Schl\u00fcssel sind sehr n\u00fctzlich, aber oft unbekannt.<\/p>\n\n\n\n

Die F5-Taste wurde bereits im Beitrag f\u00fcr die erw\u00e4hnt leere Zeilen entfernen<\/a>.<\/p>\n\n\n\n

In diesem Beitrag sehen wir uns einige Beispiele an, mit denen Sie komplexe Aktionen einfach mit der Taste F5 ausf\u00fchren k\u00f6nnen.<\/p>\n\n\n\n

Leere \u00fcberschriebene Vorlage<\/h2>\n\n\n\n

Angenommen, Sie verfolgen Ihre Energieniveaus w\u00f6chentlich in einem Excel-Dokument, aber Sie haben versehentlich in der Vorlage gearbeitet und keine leere Kopie davon gespeichert. Wenn Sie nicht wissen, wie die Taste F5 funktioniert (abh\u00e4ngig von der Gr\u00f6\u00dfe der Vorlage), kann es eine H\u00f6llenarbeit sein, die Vorlage zu leeren. Das geht ganz einfach mit der Taste F5.<\/p>\n\n\n\n

\"Fenster
Fenster F5 (Gehe zu)<\/figcaption><\/figure>\n\n\n\n
  1. Erstellen Sie eine Kopie der Vorlage und speichern Sie sie an einem Ort, an dem Sie sie finden k\u00f6nnen.<\/li>
  2. Dr\u00fccken Sie die Taste F5 (Gehe zu).<\/li>
  3. Dr\u00fccken Sie den Knopf S<\/span>Besondere<\/strong>.<\/li>
  4. W\u00e4hlen Sie die Option aus C<\/span>Augenblicke<\/strong> und w\u00e4hlen Sie die Option aus G<\/span>Fenster<\/strong>.<\/li>
  5. klicke auf OK<\/strong> und alle Zellen mit Zahlen sind ausgew\u00e4hlt. Zellen mit Formeln, Texten etc. werden nicht selektiert.<\/li>
  6. Dr\u00fccken Sie die Entf-Taste und Ihre Vorlage ist wieder leer.<\/li><\/ol>\n\n\n\n
    \"Vorlage
    Vorlage mit Hotkey F5 leeren<\/figcaption><\/figure>\n\n\n\n

    Entfernen Sie alle Kommentare aus dem Arbeitsblatt<\/h2>\n\n\n\n

    Kommentare in Zellen erkennen Sie an dem roten Dreieck in der oberen rechten Ecke einer Zelle. Haben Sie ein Arbeitsblatt, in dem Sie Kommentare in einem Arbeitsblatt l\u00f6schen m\u00f6chten? Gehen Sie dann wie folgt vor:<\/p>\n\n\n\n

    1. Dr\u00fccken Sie die Taste F5 (Gehe zu).<\/li>
    2. Dr\u00fccken Sie den Knopf S<\/span>Besondere<\/strong>.<\/li>
    3. W\u00e4hlen Sie die Option aus Notizg<\/span>und<\/strong>.<\/li>
    4. Dr\u00fccken Sie den Knopf OK.<\/strong><\/li>
    5. Klicken Sie mit der rechten Maustaste auf eine ausgew\u00e4hlte Zelle.<\/li>
    6. W\u00e4hlen Sie die Option aus dem verk\u00fcrzten Dropdown-Men\u00fc anm<\/span>Anerkennungen entfernen<\/strong>.<\/li><\/ol>\n\n\n\n
      \"Kommentare
      Kommentare mit F5 l\u00f6schen<\/figcaption><\/figure>\n\n\n\n

      Wie Sie im Fenster F5-Taste (Gehe zu) sehen k\u00f6nnen, stehen viele Optionen zur Auswahl. Mit Hilfe dieser Auswahl ist es wieder m\u00f6glich, andere Operationen durchzuf\u00fchren.<\/p>","protected":false},"excerpt":{"rendered":"

      Die F5-Taste in Excel ist ein etwas vernachl\u00e4ssigtes Kind in Excel. Die M\u00f6glichkeiten hinter diesem Schl\u00fcssel sind sehr n\u00fctzlich,\u2026 Weiterlesen<\/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\/de\/2022\/03\/13\/f5-taste-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\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\/de\/2022\/03\/13\/f5-taste-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=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bj\u00f6rn Meijer\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"3\u00a0Minuten\" \/>\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\":\"de\",\"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\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.bjorn-meijer.nl\/2022\/03\/13\/f5-toets-in-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@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\":\"de\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\",\"name\":\"Bj\u00f6rn Meijer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@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\/de\/2022\/03\/13\/f5-taste-in-excel\/","og_locale":"de_DE","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\/de\/2022\/03\/13\/f5-taste-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":{"Verfasst von":"Bj\u00f6rn Meijer","Gesch\u00e4tzte Lesezeit":"3\u00a0Minuten"},"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":"de","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":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bjorn-meijer.nl\/2022\/03\/13\/f5-toets-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"de","@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":"de"},{"@type":["Person","Organization"],"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615","name":"Bj\u00f6rn Meijer","image":{"@type":"ImageObject","inLanguage":"de","@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\/de\/wp-json\/wp\/v2\/posts\/1584","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bjorn-meijer.nl\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bjorn-meijer.nl\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/de\/wp-json\/wp\/v2\/comments?post=1584"}],"version-history":[{"count":4,"href":"https:\/\/www.bjorn-meijer.nl\/de\/wp-json\/wp\/v2\/posts\/1584\/revisions"}],"predecessor-version":[{"id":1775,"href":"https:\/\/www.bjorn-meijer.nl\/de\/wp-json\/wp\/v2\/posts\/1584\/revisions\/1775"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/de\/wp-json\/wp\/v2\/media\/265"}],"wp:attachment":[{"href":"https:\/\/www.bjorn-meijer.nl\/de\/wp-json\/wp\/v2\/media?parent=1584"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/de\/wp-json\/wp\/v2\/categories?post=1584"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/de\/wp-json\/wp\/v2\/tags?post=1584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}