{"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. 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>. Excel Group Outline<\/p><\/div><\/p>\n Follow below steps to hide the group outline in your excel workbook.<\/p>\n Go to Excel Options<\/p>\n Click on Advanced Tab [as highlighted in below image]<\/p>\n Now un-check the option displayed under – Display options for this Worksheet <\/strong> [as highlighted in below image][\/fusion_text] Excel Option – To Hide Outline<\/p><\/div><\/p>\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. Group Outline option – Worksheet Level<\/p><\/div>\n<\/div>\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 To know more about Grouping or outlining in Excel, read this article. Here I have covered following about the Grouping in Excel:<\/p>\n 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":"\n
\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>\n1. 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
\n<\/a>
Excel Option: How to hide Group Outline in Excel <\/h1>\n
Step 1: <\/h2>\n
Step 2: <\/h2>\n
Step 3: <\/h2>\n
\n<\/a>
Note:<\/h2>\n
\n<\/a>
Excel VBA to hide Group Outline in Excel <\/h1>\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
Read more…<\/h2>\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":"