{"id":6179,"date":"2017-05-18T22:05:35","date_gmt":"2017-05-18T20:05:35","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=6179"},"modified":"2023-11-30T20:54:57","modified_gmt":"2023-11-30T19:54:57","slug":"how-to-unhide-columns-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-unhide-columns-in-excel\/","title":{"rendered":"How to Unhide Columns in Excel"},"content":{"rendered":"<p>We normally use &#8220;helper columns&#8221; to do calculations <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/remove-column\/\" target=\"_blank\" rel=\"noopener\">in our Excel<\/a> worksheet. \u00a0These &#8220;helper columns&#8221; are for our own internal use and we usually hide these columns so no one else can see them, like our evil boss!<\/p>\n<p>But once we are done with presenting our Excel worksheet to our evil boss, we can\u00a0<strong>unhide these Excel columns<\/strong>\u00a0very\u00a0easily!<\/p>\n<p>For our example, <strong>Columns B and C are hidden<\/strong>:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/Unhide-Columns-1.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Unhide Columns in Excel\"  class=\"alignnone size-full wp-image-6182\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/Unhide-Columns-1.jpg\" alt=\"How to Unhide Columns in Excel\" width=\"363\" height=\"372\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/Unhide-Columns-1.jpg 363w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/Unhide-Columns-1-293x300.jpg 293w\" sizes=\"(max-width: 363px) 100vw, 363px\" \/><\/a><\/p>\n<p>I explain how you can do this below:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/Ba3_ha0uN4w?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Unhide-Columns.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Unhide-Columns.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">How-to-Unhide-Columns.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong> <\/span>Select the columns that is both on the left and right of the hidden columns.<\/p>\n<p>For our example, since our hidden columns are\u00a0<strong>B and C<\/strong>, then we need to highlight columns\u00a0<strong>A (left of B) and D (right of C).<\/strong><\/p>\n<p>Right-click and select\u00a0<strong>Unhide:<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/Unhide-Columns-2.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Unhide Columns in Excel\"  class=\"alignnone size-full wp-image-6183\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/Unhide-Columns-2.jpg\" alt=\"How to Unhide Columns in Excel\" width=\"402\" height=\"375\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/Unhide-Columns-2.jpg 402w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/Unhide-Columns-2-300x280.jpg 300w\" sizes=\"(max-width: 402px) 100vw, 402px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: center;\"><\/h2>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0Your hidden columns are <strong>now displayed<\/strong>!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/Unhide-Columns-3.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Unhide Columns in Excel\"  class=\"alignnone size-full wp-image-6184\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/Unhide-Columns-3.jpg\" alt=\"How to Unhide Columns in Excel\" width=\"692\" height=\"305\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/Unhide-Columns-3.jpg 692w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/Unhide-Columns-3-300x132.jpg 300w\" sizes=\"(max-width: 692px) 100vw, 692px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff;\"><strong>How to Unhide Columns in Excel<\/strong><\/span><\/p>\n<h2><\/h2>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-5924 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-Pivot.jpg\" sizes=\"(max-width: 530px) 100vw, 530px\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-Pivot.jpg 530w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-Pivot-300x170.jpg 300w\" width=\"530\" height=\"300\" alt=\"\" title=\"\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>We normally use &#8220;helper columns&#8221; to do calculations in our Excel worksheet. \u00a0These &#8220;helper columns&#8221; are for our own internal use and we usually hide these columns so no one else can see them, like our evil boss! But once we are done with presenting our Excel worksheet to our evil boss, we can\u00a0unhide these [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17790,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"How to Unhide Columns in Excel","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[6,7,10,41],"tags":[243,85,179,242],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/6179"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=6179"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/6179\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17790"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=6179"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=6179"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=6179"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}