Forum Discussion
+ indicating rows to expand does not always appear to the left of hidden rows
Group
If I highlight a row and simultaneously hold down Shift/Alt/Right Arrow, a "+" sign appears to the left of the row allowing me to toggle hide or unhide it.
Why does this not work in every spreadsheet? I have another spreadsheet that does not show a "+" to the left of hidden rows.
Thanks in advance
There are two separate but similar features:
1. Hiding rows
2. Grouping rows (outline)
1. Hiding a row or rows is usually achieved by either:
- select the rows, right-click, use 'Hide', or
- press Ctrl+9 will hide any rows currently selectedHiding a row or rows in this way doesn't add the "+" symbol to the row header area.
2. Alternatively, you can use the "Outline" feature, which is on the Data tab:
The shortcut you quote is for using the "Group" button. This essentially groups the rows into an outline level which can be collapsed or expanded using the + or - symbols.
If you don't see the + symbol or - symbol, it's likely that the rows were hidden using the method outlined under part 1 above.
- Thank you for responding. Why is the Outline option not displaying in some worksheets? How do I turn it on?
- If the outline isn't showing, it probably means the rows were hidden (method 1) and not grouped (method 2). You would need to un-hide the rows, then group them using the Outline feature.
