Oct 04 2022 11:13 AM
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
Oct 04 2022 12:04 PM
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 selected
Hiding 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.
Oct 04 2022 12:25 PM
Oct 04 2022 12:32 PM
Oct 04 2022 12:52 PM
Oct 04 2022 12:54 PM
Oct 04 2022 12:59 PM
Oct 04 2022 01:08 PM
Oct 04 2022 01:19 PM