{"id":12616,"date":"2018-08-26T13:30:47","date_gmt":"2018-08-26T13:30:47","guid":{"rendered":"https:\/\/www.top-password.com\/blog\/?p=12616"},"modified":"2018-08-26T13:33:01","modified_gmt":"2018-08-26T13:33:01","slug":"hide-unhide-entire-row-or-column-in-excel-2016","status":"publish","type":"post","link":"https:\/\/www.top-password.com\/blog\/hide-unhide-entire-row-or-column-in-excel-2016\/","title":{"rendered":"How to Hide \/ Unhide Entire Row or Column in Excel 2016"},"content":{"rendered":"<p>How can I hide a full column in Excel worksheet without deleting it? If you don&#8217;t want others to see a specific row or avoid printing a certain column, you can hide the entire row or column in Excel 2016.<\/p>\n<p><strong>Part 1: Hide a Whole Row or Column in Excel 2016<\/strong><\/p>\n<ol>\n<li>Open the spreadsheet in Excel 2016.<\/li>\n<li>Select the whole row you want to hide by clicking the row number. If you wish to hide an entire column, click the column letter to select it.<\/li>\n<li>Right-click the selected row or column, and then click the <strong>Hide<\/strong> option.\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.top-password.com\/blog\/wp-content\/uploads\/2018\/08\/hide-a-row-in-excel-2016.png\" alt=\"\" width=\"507\" height=\"474\" class=\"alignnone size-full wp-image-12623\" \/>\n<\/li>\n<li>The selected row or column will be hidden from view straight away. But you&#8217;ll see double lines at column or row headers, which indicates a column or row is hidden.\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.top-password.com\/blog\/wp-content\/uploads\/2018\/08\/excel-row-is-hidden.png\" alt=\"\" width=\"507\" height=\"333\" class=\"alignnone size-full wp-image-12624\" \/>\n<\/li>\n<\/ol>\n<p><strong>Part 2: Unhide a Whole Row or Column in Excel 2016<\/strong><\/p>\n<p>To unhide a row, just select the row above and the row below the hidden row. Since row 3 is hidden, we want to select rows 2 to 4. Then, right-click on the selection and click <strong>Unhide<\/strong> from the popup menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.top-password.com\/blog\/wp-content\/uploads\/2018\/08\/unhide-a-row-in-excel-2016.png\" alt=\"\" width=\"507\" height=\"455\" class=\"alignnone size-full wp-image-12625\" \/><\/p>\n<p>To unhide a column, select the columns before and after the hidden columns. Right-click the selected column headers and pick <strong>Unhide<\/strong>.<\/p>\n<p><strong>Part 3: Quickly Unhide All Hidden Rows or Columns<\/strong><\/p>\n<p>If you want to unhide all rows or columns on a sheet, make sure the whole worksheet is selected.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.top-password.com\/blog\/wp-content\/uploads\/2018\/08\/select-the-whole-worksheet.png\" alt=\"\" width=\"506\" height=\"333\" class=\"alignnone size-full wp-image-12626\" \/><\/p>\n<p>Then press <strong>Ctrl<\/strong> + <strong>Shift<\/strong> + <strong>9<\/strong> keyboard combination to unhide all rows, or press <strong>Ctrl<\/strong> + <strong>Shift<\/strong> + <strong>0<\/strong> to show all hidden columns.<\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>How can I hide a full column in Excel worksheet without deleting it? If you don&#8217;t want others to see a specific row or avoid printing a certain column, you can hide the entire row or column in Excel 2016. Part 1: Hide a Whole Row or Column in Excel 2016 Open the spreadsheet in [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,10],"tags":[3943,3944,3942,3941],"class_list":["post-12616","post","type-post","status-publish","format-standard","hentry","category-others","category-tips-tricks","tag-hide-columns-in-excel","tag-hide-rows-in-excel","tag-unhide-column-in-excel-2016","tag-unhide-rows-in-excel-2016"],"_links":{"self":[{"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/posts\/12616","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/comments?post=12616"}],"version-history":[{"count":10,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/posts\/12616\/revisions"}],"predecessor-version":[{"id":12630,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/posts\/12616\/revisions\/12630"}],"wp:attachment":[{"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/media?parent=12616"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/categories?post=12616"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/tags?post=12616"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}