Excel Tip > Excel Data > Excel Grouping and Outlining > Hiding Group & Outline Symbols in Microsoft Excel 2010

Hiding Group & Outline Symbols in Microsoft Excel 2010

Fb-Button

In this article, we will learn about how we can hide the group and outline in Microsoft Excel 2010.

Outline: -An Outline helps to separate top level and details. It is easy to create an Outline using Auto Outline option in Microsoft Excel 2010 and 2013.

“Group”: - This is used to create an outline or groups of rows and columns automatically.

You can use the shortcut Keys (Shift+Alt+ Right) or Alt>A>G>G.

Before hiding the group and outline symbols, we will learn about how we can create the Outline and Group.

To create the Outline, follow below given steps:-

  • Open in-built marketing budget plan in Excel workbook.
  • Go to File tab, Click on New.
  • New window will appear.
  • Click on Budget in Suggested Searches.

 
img1
 

  • Search Marketing Budget plan.
  • Choose any one template.

 
img2
 

  • Management budget plan’s excel file will get open.
  • Select the whole page of Excel’s sheet.

 
img3
 

  • Go to Data Tab, click on Auto outline group in the outline group.

 
img4
 

  • We can see that groups will create as per the row, column, and the header as well.

 
img5
 
To create the group, follow below given steps:-

  • Select the data range where we want to make the group.

 
img6
 
Go to Data tab and click on group from the Outline group.
 
img7
 

  • Group will get inserted. When you will click on level, selected data will get hidden, and to show the data again click on 2.

 
img8
 
To hide the group and outline, you can press the key Ctrl+8, or

  • Go to Data tab, click on Ungroup under the Outline group.
  • From the drop down list, select clear outline.

 
img9
 
img10
 
This is the way we can hide the group and outline symbols in Microsoft Excel.
 
 

Previous
Next

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Excel Tips

Categories

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.