{"id":36,"date":"2018-06-27T11:24:12","date_gmt":"2018-06-27T11:24:12","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=36"},"modified":"2024-03-29T15:48:43","modified_gmt":"2024-03-29T15:48:43","slug":"deleting-a-row-with-vba","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/vba\/deleting-a-row-with-vba\/","title":{"rendered":"Deleting a Row With VBA"},"content":{"rendered":"\n<p>In Excel, you can delete a row by right-clicking on the number of the row and then selecting Delete. But when you want to delete rows using more sophisticated methods you have to use VBA. It will allow you to delete rows in many different ways.<\/p>\n\n\n\n<h2 class=\"format wp-block-heading\">Delete a specific row<\/h2>\n\n\n\n<p>The most basic way to <a href=\"https:\/\/officetuts.net\/excel\/vba\/delete-a-row-if-cell-contains\/\">delete a row in VBA<\/a> is by using the row number.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted toolbar:2 nums:false plain:false lang:vb decode:true show_mixed:false\">Sub deleteSpecificRow()\nRows(4).Delete\nEnd Sub<\/pre>\n\n\n\n<p>This will delete the fourth row each time you execute the macro.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/delete-a-specific-row.png\" alt=\"\" class=\"wp-image-48\"\/><\/figure>\n\n\n\n<h2 class=\"format wp-block-heading\">Delete multiple rows<\/h2>\n\n\n\n<p>You can also delete a few rows at once. Instead of selecting the row number, <a href=\"https:\/\/officetuts.net\/excel\/vba\/select-range-using-variables\/\">select a range<\/a> of rows.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted toolbar:2 nums:false lang:vb decode:true\">Sub deleteMultipleRows()\nRows(\"2:4\").Delete\nEnd Sub<\/pre>\n\n\n\n<p>It will delete rows 2, 3, and 4.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/delete-multiple-rows.png\" alt=\"\" class=\"wp-image-40\"\/><\/figure>\n\n\n\n<h2 class=\"format wp-block-heading\">Delete selected rows<\/h2>\n\n\n\n<p>So far we created macros that deleted <a href=\"https:\/\/officetuts.net\/excel\/examples\/add-row-number-to-an-excel-table\/\">rows with fixed numbers<\/a> inside the code. This time, let\u2019s delete rows from a selection. &nbsp;Let\u2019s use the following code.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted toolbar:2 nums:false lang:vb decode:true\">Sub deleteSelectedRows()\nSelection.EntireRow.Delete\nEnd Sub<\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/delete-selected-rows.png\" alt=\"\" class=\"wp-image-46\"\/><\/figure>\n\n\n\n<h2 class=\"format wp-block-heading\">Delete blank rows<\/h2>\n\n\n\n<p>In this example, Excel identifies which cells are blank, selects them, and removes the rows in which they are present.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted toolbar:2 nums:false lang:vb decode:true\">Sub deleteBlankRows()\nSelection.SpecialCells(xlCellTypeBlanks).Select\nSelection.EntireRow.Delete\nEnd Sub<\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/delete-blank-rows.png\" alt=\"\" class=\"wp-image-49\"\/><\/figure>\n\n\n\n<p>This macro deletes rows from selection only if it contains the phrase \u201cBad Row\u201d.<\/p>\n\n\n\n<h3 class=\"format caution wp-block-heading\">CAUTION<\/h3>\n\n\n\n<p class=\"caution\">Remember that text is case-sensitive.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted toolbar:2 lang:vb decode:true\">Sub deleteRowswithSelectedText()\nFor Each Cell In Selection\n   If Cell.Value = \"Bad Row\" Then\n      Rows(Cell.Row).ClearContents\n   End If\nNext\nSelection.SpecialCells(xlCellTypeBlanks).Select\nSelection.EntireRow.Delete\nEnd Sub<\/pre>\n\n\n\n<p><strong>Code analysis<\/strong>:<\/p>\n\n\n\n<p><strong>2.<\/strong>&nbsp;The loop goes through each element in the selection.<\/p>\n\n\n\n<p><strong>3<\/strong>.&nbsp;Excel checks the actual <a href=\"https:\/\/officetuts.net\/excel\/formulas\/get-cell-value\/\">cell value<\/a> and if the value is exactly \u201cBad Row\u201d.<\/p>\n\n\n\n<p><strong>4.<\/strong>&nbsp;If the condition is met, Excel clears the contents of the cell. We can\u2019t delete the cell because the cell position will change and some of the \u201cBad Rows\u201d may stay.<\/p>\n\n\n\n<p><strong>7.<\/strong>&nbsp;When all \u201cBad Rows\u201d are cleared then Excel selects these cells.<\/p>\n\n\n\n<p><strong>8.<\/strong>&nbsp;Then deletes rows of these cells.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/delete-rows-with-selected-text.png\" alt=\"\" class=\"wp-image-44\"\/><\/figure>\n\n\n\n<p>If you also want to delete those rows that consist of this phrase, and not only the exact match, use the InStr function. This function returns the position of the first occurrence of the phrase.<\/p>\n\n\n\n<p>change<\/p>\n\n\n\n<pre class=\"wp-block-preformatted toolbar:2 nums:false lang:vb decode:true\">Cell.Value = \"Bad Row\"<\/pre>\n\n\n\n<p>to<\/p>\n\n\n\n<pre class=\"wp-block-preformatted toolbar:2 nums:false lang:vb decode:true\">InStr(Cell, \"Bad Row\") &gt; 0<\/pre>\n\n\n\n<p>We have four different examples inside our worksheet. Each of them returns a position.<\/p>\n\n\n\n<ul>\n<li>\u201cBad Row\u201d returns 1<\/li>\n\n\n\n<li>\u201cGood Row\u201d returns 0<\/li>\n\n\n\n<li>\u201c1 Bad Row\u201d returns 3<\/li>\n\n\n\n<li>\u201cBad Row !\u201d returns 1<\/li>\n<\/ul>\n\n\n\n<p>That means that all rows but \u201cGood Row\u201d will be removed.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/delete-rows-with-selected-text-broad.png\" alt=\"\" class=\"wp-image-45\"\/><\/figure>\n\n\n\n<h2 class=\"format wp-block-heading\">Delete row where the cell type is a string<\/h2>\n\n\n\n<p>In this example, we will delete a row if the cell type is a string.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/delete-row-based-on-type.png\" alt=\"\" class=\"wp-image-41\"\/><\/figure>\n\n\n\n<p>At first glance,&nbsp;cells&nbsp;<strong>A3, A4<\/strong>, and&nbsp;<strong>A5<\/strong>&nbsp;seem to be of the same type. But when you look at what is going on behind the scenes (<span class=\"shortcut\">Ctrl + `<\/span>) you will see that each of them is different.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/delete-row-behind.png\" alt=\"\" class=\"wp-image-43\"\/><\/figure>\n\n\n\n<pre class=\"wp-block-preformatted toolbar:2 lang:vb decode:true\">Sub deleteifString()\nSelection.SpecialCells(xlCellTypeConstants, 2).Select\nSelection.EntireRow.Delete\nEnd Sub<\/pre>\n\n\n\n<p>In the second line, you have the following code: xlCellTypeConstants. It means that we are searching for constants. Number 2 means the second type, which is text.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"328\" height=\"336\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/go-to-special.png\" alt=\"\" class=\"wp-image-238\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/go-to-special.png 328w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/go-to-special-293x300.png 293w\" sizes=\"(max-width: 328px) 100vw, 328px\" \/><\/figure>\n\n\n\n<p>Excel will choose only <a href=\"https:\/\/officetuts.net\/excel\/vba\/custom-data-types\/\">values of type text<\/a>.<\/p>\n\n\n\n<p>The result.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/delete-row-based-on-type-result.png\" alt=\"\" class=\"wp-image-42\"\/><\/figure>\n\n\n\n<h2 class=\"format wp-block-heading\">Delete even\/odd rows<\/h2>\n\n\n\n<p>Now let\u2019s delete only those rows that are even.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted toolbar:2 lang:vb decode:true\">Sub deleteEven()\nFor Each Cell In Selection\n   If Cell.Row Mod 2 = 0 Then\n      Rows(Cell.Row).ClearContents\n   End If\nNext\nSelection.SpecialCells(xlCellTypeBlanks).Select\nSelection.EntireRow.Delete\nEnd Sub<\/pre>\n\n\n\n<p>The code is very similar to that from the previous example. There is only one difference.<\/p>\n\n\n\n<p>Cell.Row Mod 2 = 0<\/p>\n\n\n\n<p>This means, if the remainder after division is 0 (for numbers: 2, 4, 6, 8, \u2026) then the number is even, if it\u2019s 1 then it\u2019s an odd number (1, 3, 5, 6, \u2026).<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/delete-even.png\" alt=\"\" class=\"wp-image-39\"\/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>In Excel, you can delete a row by right-clicking on the number of the row and then selecting Delete. But when you want&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[170,190],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Deleting a Row With VBA<\/title>\n<meta name=\"description\" content=\"Learn how to delete rows in Excel using VBA. This guide will show you how to delete specific rows and multiple rows at once using macros and range selection.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/vba\/deleting-a-row-with-vba\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Deleting a Row With VBA\" \/>\n<meta property=\"og:description\" content=\"Learn how to delete rows in Excel using VBA. This guide will show you how to delete specific rows and multiple rows at once using macros and range selection.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/vba\/deleting-a-row-with-vba\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-27T11:24:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-29T15:48:43+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/delete-a-specific-row.png\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\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:\/\/officetuts.net\/excel\/vba\/deleting-a-row-with-vba\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/vba\/deleting-a-row-with-vba\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Deleting a Row With VBA\",\"datePublished\":\"2018-06-27T11:24:12+00:00\",\"dateModified\":\"2024-03-29T15:48:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/vba\/deleting-a-row-with-vba\/\"},\"wordCount\":498,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/vba\/deleting-a-row-with-vba\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/delete-a-specific-row.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"vba\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/vba\/deleting-a-row-with-vba\/\",\"url\":\"https:\/\/officetuts.net\/excel\/vba\/deleting-a-row-with-vba\/\",\"name\":\"Deleting a Row With VBA\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/vba\/deleting-a-row-with-vba\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/vba\/deleting-a-row-with-vba\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/delete-a-specific-row.png\",\"datePublished\":\"2018-06-27T11:24:12+00:00\",\"dateModified\":\"2024-03-29T15:48:43+00:00\",\"description\":\"Learn how to delete rows in Excel using VBA. This guide will show you how to delete specific rows and multiple rows at once using macros and range selection.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/vba\/deleting-a-row-with-vba\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/vba\/deleting-a-row-with-vba\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/vba\/deleting-a-row-with-vba\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/delete-a-specific-row.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/delete-a-specific-row.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/vba\/deleting-a-row-with-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Deleting a Row With VBA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Deleting a Row With VBA","description":"Learn how to delete rows in Excel using VBA. This guide will show you how to delete specific rows and multiple rows at once using macros and range selection.","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:\/\/officetuts.net\/excel\/vba\/deleting-a-row-with-vba\/","og_locale":"en_US","og_type":"article","og_title":"Deleting a Row With VBA","og_description":"Learn how to delete rows in Excel using VBA. This guide will show you how to delete specific rows and multiple rows at once using macros and range selection.","og_url":"https:\/\/officetuts.net\/excel\/vba\/deleting-a-row-with-vba\/","article_published_time":"2018-06-27T11:24:12+00:00","article_modified_time":"2024-03-29T15:48:43+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/delete-a-specific-row.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/vba\/deleting-a-row-with-vba\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/vba\/deleting-a-row-with-vba\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Deleting a Row With VBA","datePublished":"2018-06-27T11:24:12+00:00","dateModified":"2024-03-29T15:48:43+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/vba\/deleting-a-row-with-vba\/"},"wordCount":498,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/vba\/deleting-a-row-with-vba\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/delete-a-specific-row.png","keywords":["file","pinterest"],"articleSection":["vba"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/vba\/deleting-a-row-with-vba\/","url":"https:\/\/officetuts.net\/excel\/vba\/deleting-a-row-with-vba\/","name":"Deleting a Row With VBA","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/vba\/deleting-a-row-with-vba\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/vba\/deleting-a-row-with-vba\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/delete-a-specific-row.png","datePublished":"2018-06-27T11:24:12+00:00","dateModified":"2024-03-29T15:48:43+00:00","description":"Learn how to delete rows in Excel using VBA. This guide will show you how to delete specific rows and multiple rows at once using macros and range selection.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/vba\/deleting-a-row-with-vba\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/vba\/deleting-a-row-with-vba\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/vba\/deleting-a-row-with-vba\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/delete-a-specific-row.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/delete-a-specific-row.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/vba\/deleting-a-row-with-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Deleting a Row With VBA"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/36"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=36"}],"version-history":[{"count":33,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/36\/revisions"}],"predecessor-version":[{"id":12593,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/36\/revisions\/12593"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=36"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=36"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=36"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}