SOLVED

What is the panel to the left of the row labels?

Copper Contributor

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?

Screenshot 2024-02-22 110627.png

3 Replies
best response confirmed by MichaelSoyka (Copper Contributor)
Solution

@MichaelSoyka 

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.

@OliverScheurich 

 

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.
1 best response

Accepted Solutions
best response confirmed by MichaelSoyka (Copper Contributor)
Solution

@MichaelSoyka 

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.

View solution in original post