• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 89
  • Last Modified:

Hide Grouping toggles in Excel

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.
0
btgtech
Asked:
btgtech
  • 2
  • 2
1 Solution
 
Rob HensonFinance AnalystCommented:
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
0
 
btgtechAuthor Commented:
We found that you can also use Ctrl 8 to toggle the Outline Symbols on and off.
0
 
Rob HensonFinance AnalystCommented:
But only the top row number 8, not the number pad.
0
 
btgtechAuthor Commented:
We found that Crtl 8 was the function that we needed.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now