Forum Discussion
Solved
What is the panel to the left of the row labels?
I received an Excel workbook that has a mystery panel to the left of one of the worksheets (see attached image). This panel has 6 small boxes at the top and under each one is one or more line segments. Each line segment has a small box at one end that contains either a plus or minus sign. Clicking any those boxes hides or unhides the rows they encompass.
My questions are: how was the panel created and how can I delete it?
Here's information about grouping in Excel.
Outline (group) data in a worksheet - Microsoft Support
The shortcut to end grouping is Shift+Alt+Left Arrow. The shortcut to start grouping is Shift+Alt+Right Arrow.
Here's information about grouping in Excel.
Outline (group) data in a worksheet - Microsoft Support
The shortcut to end grouping is Shift+Alt+Left Arrow. The shortcut to start grouping is Shift+Alt+Right Arrow.
Thank you for reply. When I press SHIFT+ALT+LEFTARRAY I see a popup titled "Ungroup" with the "Rows" radio button selected. When I then press "OK" nothing changes, that is, the "panel" remains visible.
- Actually, it's "Data/Outline/Ungroup/Clear Outline" that removes the panel.
