{"id":14574,"date":"2024-02-02T14:51:52","date_gmt":"2024-02-02T14:51:52","guid":{"rendered":"http:\/\/learnexcelmacro.com\/wp\/?p=14574"},"modified":"2024-02-02T14:51:52","modified_gmt":"2024-02-02T14:51:52","slug":"vba-to-hide-group-outline-symbol-in-excel","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/","title":{"rendered":"Hide Group outline symbol in Excel – [Manual Option + VBA]"},"content":{"rendered":"

Dear Friends,<\/p>\n

In this article, I am going to share a quick tip related to Excel. It was asked by one of my colleague recently.
\nHow to show or hide Group Outline Symbol in Excel Workbook<\/strong> when you group any row or column. Here I will show you both the methods –<\/p>\n

1. How to hide Group Outline – Using Excel Options (Manual) <\/h4>\n

2. How to hide Group Outline – Using Excel VBA<\/h4>\n

What is Group outline Symbol, I am talking about here?<\/h1>\n

Refer the highlighted part in the below image. That is called group outline which is, by default, becomes visible as soon as you Group any row or column in Excel sheet. To know more about Grouping of Rows and columns, you can read this article in detail<\/a>.
\n

\"Excel<\/a>

Excel Group Outline<\/p><\/div><\/p>\n

Excel Option: How to hide Group Outline in Excel <\/h1>\n

Follow below steps to hide the group outline in your excel workbook.<\/p>\n

Step 1: <\/h2>\n

Go to Excel Options<\/p>\n

Step 2: <\/h2>\n

Click on Advanced Tab [as highlighted in below image]<\/p>\n

Step 3: <\/h2>\n

Now un-check the option displayed under – Display options for this Worksheet <\/strong> [as highlighted in below image][\/fusion_text]
\n

\"Excel<\/a>

Excel Option – To Hide Outline<\/p><\/div><\/p>\n

\n

Note:<\/h2>\n

As you can see this Excel option is not available for the whole workbook. It is available for each WorkSheet. You will get all the Worksheet Names listed here in the drop down to select and set this flag to true or false accordingly.
\n

\"Group<\/a>

Group Outline option – Worksheet Level<\/p><\/div>\n<\/div>\n

Excel VBA to hide Group Outline in Excel <\/h1>\n

As mentioned above, this option is not directly applicable to Whole workbook or Excel as an application. Therefore, you would not find any property to hide or show Group outline in any of these Objects – Application<\/strong> or Workbook.<\/strong>. You will find this property under Application.ActiveWindow<\/strong> and the property name is .DisplayOutline<\/em><\/strong><\/p>\n

\r\n\r\n'To hide group outline in Excel\r\nSub Hide_Group_Outline()\r\n    Application.ActiveWindow.DisplayOutline = False\r\nEnd Sub\r\n<\/code>\r\n<\/pre>\n
Excel VBA to Show Group Outline in Excel <\/h1>\n
\r\n\r\n'To show group outline in Excel\r\nSub Show_Group_Outline()\r\n    Application.ActiveWindow.DisplayOutline = True\r\nEnd Sub\r\n<\/code>\r\n<\/pre>\n
\n
Read more…<\/h2>\n
To know more about Grouping or outlining in Excel, read this article. Here I have covered following about the Grouping in Excel:<\/p>\n
What is Grouping\/Outlining in Excel and How to do that?<\/a><\/h4>\n
What is nested grouping? Is it possible to group at multiple levels?<\/a><\/h4>\n
VBA code to hide and display different levels of Groping<\/a><\/h4>\n
VBA to expand all the groupings done in Excel.<\/a><\/h4>\n
VBA to collapse all the groupings done in Excel<\/a><\/h4>\n<\/div>\n<\/span>","protected":false},"excerpt":{"rendered":"
Dear Friends, In this article, I am going to share a quick tip related to Excel. It was asked by one of my colleague recently. How to show or hide Group Outline Symbol in Excel Workbook when you group any row or column. Here I will show you both the methods – 1. How to […]<\/p>\n","protected":false},"author":45,"featured_media":14593,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1246,1676],"tags":[],"class_list":["post-14574","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-macro","category-excel-tips"],"yoast_head":"\nHide Group outline symbol in Excel - [Manual Option + VBA] - Let's excel in Excel<\/title>\n<meta name=\"description\" content=\"Excel option - to show or hide Group outline symbol in Excel. Excel VBA to show or hide group outlines in Excel. What is group outline symbol.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hide Group outline symbol in Excel - [Manual Option + VBA]\" \/>\n<meta property=\"og:description\" content=\"Excel option - to show or hide Group outline symbol in Excel. Excel VBA to show or hide group outlines in Excel. What is group outline symbol.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Let's excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-02T14:51:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/11\/Group-outline-symbol-setting.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"538\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Hide Group outline symbol in Excel – [Manual Option + VBA]\",\"datePublished\":\"2024-02-02T14:51:52+00:00\",\"dateModified\":\"2024-02-02T14:51:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/\"},\"wordCount\":419,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/11\/Group-outline-symbol-setting.jpg\",\"articleSection\":[\"Excel Macro\",\"Excel Tips\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/\",\"name\":\"Hide Group outline symbol in Excel - [Manual Option + VBA] - Let's excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/11\/Group-outline-symbol-setting.jpg\",\"datePublished\":\"2024-02-02T14:51:52+00:00\",\"dateModified\":\"2024-02-02T14:51:52+00:00\",\"description\":\"Excel option - to show or hide Group outline symbol in Excel. Excel VBA to show or hide group outlines in Excel. What is group outline symbol.\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/11\/Group-outline-symbol-setting.jpg\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/11\/Group-outline-symbol-setting.jpg\",\"width\":800,\"height\":538,\"caption\":\"Group Outline Symbol Settings\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Macro\",\"item\":\"https:\/\/vmlogger.com\/excel\/macro\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Hide Group outline symbol in Excel – [Manual Option + VBA]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let's excel in Excel\",\"description\":\"Let's share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Hide Group outline symbol in Excel - [Manual Option + VBA] - Let's excel in Excel","description":"Excel option - to show or hide Group outline symbol in Excel. Excel VBA to show or hide group outlines in Excel. What is group outline symbol.","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:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"Hide Group outline symbol in Excel - [Manual Option + VBA]","og_description":"Excel option - to show or hide Group outline symbol in Excel. Excel VBA to show or hide group outlines in Excel. What is group outline symbol.","og_url":"https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/","og_site_name":"Let's excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2024-02-02T14:51:52+00:00","og_image":[{"width":800,"height":538,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/11\/Group-outline-symbol-setting.jpg","type":"image\/jpeg"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Hide Group outline symbol in Excel – [Manual Option + VBA]","datePublished":"2024-02-02T14:51:52+00:00","dateModified":"2024-02-02T14:51:52+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/"},"wordCount":419,"commentCount":1,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/11\/Group-outline-symbol-setting.jpg","articleSection":["Excel Macro","Excel Tips"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/","url":"https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/","name":"Hide Group outline symbol in Excel - [Manual Option + VBA] - Let's excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/11\/Group-outline-symbol-setting.jpg","datePublished":"2024-02-02T14:51:52+00:00","dateModified":"2024-02-02T14:51:52+00:00","description":"Excel option - to show or hide Group outline symbol in Excel. Excel VBA to show or hide group outlines in Excel. What is group outline symbol.","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/11\/Group-outline-symbol-setting.jpg","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/11\/Group-outline-symbol-setting.jpg","width":800,"height":538,"caption":"Group Outline Symbol Settings"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2024\/02\/vba-to-hide-group-outline-symbol-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Macro","item":"https:\/\/vmlogger.com\/excel\/macro\/"},{"@type":"ListItem","position":3,"name":"Hide Group outline symbol in Excel – [Manual Option + VBA]"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let's excel in Excel","description":"Let's share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/14574"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=14574"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/14574\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media\/14593"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=14574"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=14574"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=14574"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}