<div>
Go to File &gt;&nbsp;Options &gt;&nbsp;Advanced.<br />
Towards the middle of the list of options in the RIght hand pane is &quot;Display options for this worksheet&quot;; one of those options is &quot;Show Outline symbols if an Outline is applied&quot;.<br />
<br />
This will Show / Hide the Grouping icons.<br />
<br />
Thanks<br />
Rob H
</div>


Go to File > Options > Advanced.
Towards the middle of the list of options in the RIght hand pane is "Display options for this worksheet"; one of those options is "Show Outline symbols if an Outline is applied".

This will Show / Hide the Grouping icons.

Thanks
Rob H

<div>
But only the top row number 8, not the number pad.
</div>


But only the top row number 8, not the number pad.

<div>
We found that Crtl 8 was the function that we needed.
</div>


We found that Crtl 8 was the function that we needed.

<div>
<div class="content wysiwyg-content">
We have a spreadsheet in Microsoft Excel where we have 4 levels of grouping. &nbsp;The toggle rows for the grouping take up a lot of space on the screen.<br />
<br />
Is there a way to hide the grouping toggles?<br />
<br />
We will need to be able to have the user unhide the toggles so they can display the hidden data in the grouping.
</div>
</div>


We have a spreadsheet in Microsoft Excel where we have 4 levels of grouping.  The toggle rows for the grouping take up a lot of space on the screen.

Is there a way to hide the grouping toggles?

We will need to be able to have the user unhide the toggles so they can display the hidden data in the grouping.

Hide Grouping toggles in Excel

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.