{"id":829,"date":"2018-06-30T18:16:57","date_gmt":"2018-06-30T18:16:57","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=829"},"modified":"2024-02-19T14:55:23","modified_gmt":"2024-02-19T14:55:23","slug":"hiding-rows-and-columns","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/training\/hiding-rows-and-columns\/","title":{"rendered":"Hide Rows and Columns"},"content":{"rendered":"\n

In some cases, you may want to hide some rows or columns. For example, those that are used only for calculations, and there is no need to see them in your worksheet.<\/p>\n\n\n\n

From a technical point of view, hiding columns and rows is actually reducing their size to a minimum. When you hide a row or column<\/a>, width or height are set to 0.<\/p>\n\n\n\n

Hiding<\/h2>\n\n\n\n

Let\u2019s use the example from the previous lesson.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Example 1:<\/h3>\n\n\n\n

Select rows 3<\/strong> and 4<\/strong> and hide them, choosing one of the following methods:<\/p>\n\n\n\n

    \n
  1. HOME >> Cells >> Format >> Hide & Unhide >> Hide Rows<\/strong>.<\/li>\n\n\n\n
  2. Right-click the selected rows and choose Hide<\/strong>.<\/li>\n<\/ol>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    Now, the rows 3<\/strong> and 4<\/strong> are hidden.<\/strong><\/p>\n\n\n\n

    Unhiding<\/h2>\n\n\n\n

    You can unhide these rows using one of the two methods. First, you have to select rows that are located above and below the hidden rows. In our case, it will be rows: 2<\/strong> and 5<\/strong>.<\/p>\n\n\n\n

    Select them and use one of the following methods:<\/p>\n\n\n\n

      \n
    1. HOME >> Cells >> Format >> Hide & Unhide >> Unhide Rows.<\/strong><\/li>\n\n\n\n
    2. Use right-click, then click the Unhide<\/strong> button.<\/li>\n<\/ol>\n\n\n\n

      You can deal with columns in the similar way as you deal with rows.<\/p>\n","protected":false},"excerpt":{"rendered":"

      In some cases, you may want to hide some rows or columns. For example, those that are used only for calculations, and there…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[],"yoast_head":"\nHide Rows and Columns<\/title>\n<meta name=\"description\" content=\"Learn how to hide and unhide rows or columns in Excel. Reduce size to minimum, select rows and click "Hide" or "Unhide". Simple steps provided.\" \/>\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\/training\/hiding-rows-and-columns\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hide Rows and Columns\" \/>\n<meta property=\"og:description\" content=\"Learn how to hide and unhide rows or columns in Excel. Reduce size to minimum, select rows and click "Hide" or "Unhide". Simple steps provided.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/training\/hiding-rows-and-columns\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-30T18:16:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-19T14:55:23+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/example3-2.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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/hiding-rows-and-columns\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/hiding-rows-and-columns\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Hide Rows and Columns\",\"datePublished\":\"2018-06-30T18:16:57+00:00\",\"dateModified\":\"2024-02-19T14:55:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/hiding-rows-and-columns\/\"},\"wordCount\":214,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/hiding-rows-and-columns\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/example3-2.png\",\"articleSection\":[\"training\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/hiding-rows-and-columns\/\",\"url\":\"https:\/\/officetuts.net\/excel\/training\/hiding-rows-and-columns\/\",\"name\":\"Hide Rows and Columns\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/hiding-rows-and-columns\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/hiding-rows-and-columns\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/example3-2.png\",\"datePublished\":\"2018-06-30T18:16:57+00:00\",\"dateModified\":\"2024-02-19T14:55:23+00:00\",\"description\":\"Learn how to hide and unhide rows or columns in Excel. Reduce size to minimum, select rows and click \\\"Hide\\\" or \\\"Unhide\\\". Simple steps provided.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/hiding-rows-and-columns\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/training\/hiding-rows-and-columns\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/hiding-rows-and-columns\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/example3-2.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/example3-2.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/hiding-rows-and-columns\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hide Rows and Columns\"}]},{\"@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":"Hide Rows and Columns","description":"Learn how to hide and unhide rows or columns in Excel. Reduce size to minimum, select rows and click \"Hide\" or \"Unhide\". Simple steps provided.","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\/training\/hiding-rows-and-columns\/","og_locale":"en_US","og_type":"article","og_title":"Hide Rows and Columns","og_description":"Learn how to hide and unhide rows or columns in Excel. Reduce size to minimum, select rows and click \"Hide\" or \"Unhide\". Simple steps provided.","og_url":"https:\/\/officetuts.net\/excel\/training\/hiding-rows-and-columns\/","article_published_time":"2018-06-30T18:16:57+00:00","article_modified_time":"2024-02-19T14:55:23+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/example3-2.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/training\/hiding-rows-and-columns\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/training\/hiding-rows-and-columns\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Hide Rows and Columns","datePublished":"2018-06-30T18:16:57+00:00","dateModified":"2024-02-19T14:55:23+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/training\/hiding-rows-and-columns\/"},"wordCount":214,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/training\/hiding-rows-and-columns\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/example3-2.png","articleSection":["training"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/training\/hiding-rows-and-columns\/","url":"https:\/\/officetuts.net\/excel\/training\/hiding-rows-and-columns\/","name":"Hide Rows and Columns","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/training\/hiding-rows-and-columns\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/training\/hiding-rows-and-columns\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/example3-2.png","datePublished":"2018-06-30T18:16:57+00:00","dateModified":"2024-02-19T14:55:23+00:00","description":"Learn how to hide and unhide rows or columns in Excel. Reduce size to minimum, select rows and click \"Hide\" or \"Unhide\". Simple steps provided.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/training\/hiding-rows-and-columns\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/training\/hiding-rows-and-columns\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/training\/hiding-rows-and-columns\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/example3-2.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/example3-2.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/training\/hiding-rows-and-columns\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Hide Rows and Columns"}]},{"@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\/829"}],"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=829"}],"version-history":[{"count":5,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/829\/revisions"}],"predecessor-version":[{"id":13831,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/829\/revisions\/13831"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=829"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=829"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=829"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}