{"id":8807,"date":"2023-02-26T02:11:54","date_gmt":"2023-02-26T02:11:54","guid":{"rendered":"https:\/\/www.excel-learn.com\/?p=8807"},"modified":"2023-11-03T19:21:17","modified_gmt":"2023-11-03T19:21:17","slug":"how-to-hide-excel-sheet-columns-in-vba","status":"publish","type":"post","link":"https:\/\/www.excel-learn.com\/how-to-hide-excel-sheet-columns-in-vba\/","title":{"rendered":"How to hide Excel Sheet Columns in VBA"},"content":{"rendered":"

Hiding columns in VBA<\/strong><\/h3>\n

By using Worksheet\u2019s Columns<\/strong> property, you may hide one or more columns in VBA.<\/p>\n

This is how you may use the Columns property:<\/p>\n

Columns(\"C\").Hidden = True<\/div>\n

OR<\/p>\n

Columns(3).Hidden = True<\/div>\n
    \n
  • You may hide one or more columns by using this property<\/li>\n
  • If Columns is used as above, it will affect the active worksheet\u2019s column(s)<\/li>\n
  • By using Worksheet. Columns, you may specify another worksheet that is not active.<\/li>\n<\/ul>\n

    An example of hiding one column in an active sheet<\/strong><\/h3>\n

    Our sample sheet contains four columns as shown in the image below:<\/p>\n

    \"VBA-Hide-Column-sample\"<\/p>\n

    VBA code to hide Column \u201cC\u201d:<\/strong><\/p>\n

    Sub hide_cols()\r\n\r\n'Hiding col C\r\n\r\nColumns(\"C\").Hidden = True\r\n\r\nEnd Sub<\/pre>\n
    Result:<\/strong><\/p>\n
    \"VBA-Hide-Column-single\"<\/p>\n
    Hiding two columns example<\/strong><\/h3>\n
    For hiding two or more columns, enclose this in the double quotes separated by a colon.<\/p>\n
    The example below hides B and C columns in our Excel sheet:<\/p>\n
    Code:<\/strong><\/p>\n
    Sub hide_cols()\r\n'Hiding col C and D\r\n\r\nColumns(\"B:C\").Hidden = True\r\n\r\nEnd Sub<\/pre>\n
    Result:<\/strong><\/p>\n
    \"VBA-Hide-Column-multi\"<\/p>\n
    Similarly, you may hide 3 or more columns in the active sheet. For example, this will hide B, C, and D:<\/p>\n
    Columns(\"B:D\").Hidden = True<\/div>\n
    How to hide columns in another sheet?<\/strong><\/h3>\n
    So, if you need to hide the column(s) in another Worksheet then use the \u201cWorksheets\u201d object.<\/p>\n
    To show this demo, we have two sheets in our Workbook:<\/p>\n
      \n
    • Sales (active)<\/li>\n
    • Product Information<\/li>\n<\/ul>\n
      \"column-Hide-sheet-othe\"<\/p>\n
      The product information sheet contains four columns (as shown in the first example).<\/p>\n
      We need to remove a column in that sheet.<\/p>\n
      VBA code:<\/strong><\/p>\n
      Sub hide_cols()\r\n\r\n'Hiding col in another sheet than active\r\n\r\nWorksheets(\"Product Information\").Columns(\"C\").Hidden = True\r\n\r\nEnd Sub<\/pre>\n
      Similarly, you may hide two or more sheets by using syntax i.e.<\/p>\n
      Worksheets(\"Product Information\").Columns(\"B:D\").Hidden = True<\/div>\n
      Unhide the hidden columns<\/strong><\/h3>\n
      To unhide the hidden column(s), just set the Hidden = False<\/strong>.<\/p>\n
      Worksheets(\"Product Information\").Columns(\"C\").Hidden = False<\/div>\n
       <\/p>\n","protected":false},"excerpt":{"rendered":"
      Hiding columns in VBA By using Worksheet\u2019s Columns property, you may hide one or more…<\/p>\n","protected":false},"author":1,"featured_media":8808,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[147],"tags":[],"yoast_head":"\nHow to hide Excel Sheet Columns in VBA<\/title>\n<meta name=\"robots\" content=\"index, follow\" \/>\n<meta name=\"googlebot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta name=\"bingbot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.excel-learn.com\/how-to-hide-excel-sheet-columns-in-vba\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to hide Excel Sheet Columns in VBA\" \/>\n<meta property=\"og:description\" content=\"Hiding columns in VBA By using Worksheet\u2019s Columns property, you may hide one or more...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.excel-learn.com\/how-to-hide-excel-sheet-columns-in-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-26T02:11:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-03T19:21:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/46_3-VBA-Hide-Column-multi.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"303\" \/>\n\t<meta property=\"og:image:height\" content=\"344\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.excel-learn.com\/#website\",\"url\":\"https:\/\/www.excel-learn.com\/\",\"name\":\"Excel Tutorials\",\"description\":\"Tips, Solutions, Tricks\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/www.excel-learn.com\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.excel-learn.com\/how-to-hide-excel-sheet-columns-in-vba\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/46_3-VBA-Hide-Column-multi.jpg\",\"width\":303,\"height\":344,\"caption\":\"VBA-Hide-Column-multi\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.excel-learn.com\/how-to-hide-excel-sheet-columns-in-vba\/#webpage\",\"url\":\"https:\/\/www.excel-learn.com\/how-to-hide-excel-sheet-columns-in-vba\/\",\"name\":\"How to hide Excel Sheet Columns in VBA\",\"isPartOf\":{\"@id\":\"https:\/\/www.excel-learn.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.excel-learn.com\/how-to-hide-excel-sheet-columns-in-vba\/#primaryimage\"},\"datePublished\":\"2023-02-26T02:11:54+00:00\",\"dateModified\":\"2023-11-03T19:21:17+00:00\",\"author\":{\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.excel-learn.com\/how-to-hide-excel-sheet-columns-in-vba\/\"]}]},{\"@type\":[\"Person\"],\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3\",\"name\":\"excelmaster\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.excel-learn.com\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e2a3743b4da71bd52984e02bd5c3280c?s=96&d=mm&r=g\",\"caption\":\"excelmaster\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/8807"}],"collection":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/comments?post=8807"}],"version-history":[{"count":4,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/8807\/revisions"}],"predecessor-version":[{"id":9719,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/8807\/revisions\/9719"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/media\/8808"}],"wp:attachment":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/media?parent=8807"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/categories?post=8807"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/tags?post=8807"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}