{"id":1776,"date":"2011-08-25T12:25:20","date_gmt":"2011-08-25T12:25:20","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=149"},"modified":"2023-12-30T23:14:26","modified_gmt":"2023-12-30T23:14:26","slug":"hide-columns-and-rows-in-an-excel-worksheet","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/hide-columns-and-rows-in-an-excel-worksheet\/","title":{"rendered":"Excel Courses: Hide columns and rows in an Excel Worksheet"},"content":{"rendered":"<p>If you don\u2019t want part of the <strong>Excel<\/strong> <strong>worksheet<\/strong> to be visible or when you don\u2019t want certain data to appear in print outs, then a simple solution is to temporarily hide columns and rows.<\/p>\n<p><strong>Hide a single column:<\/strong><\/p>\n<p>1)\u00a0\u00a0\u00a0 Right click on the column header of the column you want to hide (this is the grey bar along the top edge of the worksheet)<\/p>\n<p><em>2)\u00a0\u00a0\u00a0 <\/em>Choose <em>Hide <\/em>from the menu<\/p>\n<p><em>3)\u00a0\u00a0\u00a0 <\/em>This column will now be hidden from view<\/p>\n<figure id=\"attachment_150\" aria-describedby=\"caption-attachment-150\" style=\"width: 132px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/08\/excel.png\"><img decoding=\"async\" class=\"size-full wp-image-150 \" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/08\/excel.png\" alt=\"\" width=\"132\" height=\"279\" \/><\/a><figcaption id=\"caption-attachment-150\" class=\"wp-caption-text\">Click Hide<\/figcaption><\/figure>\n<p><strong>Hide more than one column:<\/strong><\/p>\n<p>1)\u00a0\u00a0\u00a0 In the column header drag select to highlight the columns you want hidden<\/p>\n<p><em>2)\u00a0\u00a0\u00a0 <\/em>Right click and choose <em>Hide <\/em>from the menu<\/p>\n<figure id=\"attachment_152\" aria-describedby=\"caption-attachment-152\" style=\"width: 402px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/08\/excel2.png\"><img decoding=\"async\" class=\"size-full wp-image-152 \" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/08\/excel2.png\" alt=\"\" width=\"402\" height=\"328\" \/><\/a><figcaption id=\"caption-attachment-152\" class=\"wp-caption-text\">Example<\/figcaption><\/figure>\n<p><strong>Hide separate columns:<\/strong><\/p>\n<p>1)\u00a0\u00a0\u00a0 Click on the fist column to be hidden<\/p>\n<p><em>2)\u00a0\u00a0\u00a0 <\/em>Press and hold down the CTRL key<em><\/em><\/p>\n<p><em>3)\u00a0\u00a0\u00a0 <\/em>While holding the CTRL key, left click on the rest of the columns you want to hide<em><\/em><\/p>\n<p><em>4)\u00a0\u00a0\u00a0 <\/em>Right click and choose <em>Hide<\/em><\/p>\n<figure id=\"attachment_151\" aria-describedby=\"caption-attachment-151\" style=\"width: 439px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/08\/excel3.png\"><img decoding=\"async\" class=\"size-full wp-image-151 \" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2011\/08\/excel3.png\" alt=\"\" width=\"439\" height=\"347\" \/><\/a><figcaption id=\"caption-attachment-151\" class=\"wp-caption-text\">Example<\/figcaption><\/figure>\n<p><em>Please note:- When you hide a column in an <strong>Excel worksheet<\/strong>, data in that column can still be used and referenced in the worksheet.\u00a0<\/em><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you don\u2019t want part of the Excel worksheet to be visible or when you don\u2019t want certain data to appear in print outs, then a simple solution is to temporarily hide columns and rows. Hide a single column: 1)\u00a0\u00a0\u00a0 Right click on the column header of the column you want to hide (this is [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[99,171,172,219,220,224,231,279,282,288,539,616],"class_list":["post-1776","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-columns-and-rows","tag-excel","tag-excel-how-to","tag-excel-tips","tag-excel-training-y","tag-excel-training-london","tag-excel-tutorial","tag-hidingun-hiding","tag-hints","tag-how-to","tag-training","tag-ya"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1776","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=1776"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1776\/revisions"}],"predecessor-version":[{"id":6797,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1776\/revisions\/6797"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=1776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=1776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=1776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}