Removes the grouping from the selected rows or columns, and the plus and minus buttons in the margin go away. With only some cells selected, Excel asks whether to ungroup rows or columns.
More Format shortcuts
- Apply the Currency formatCtrl+Shift+4
- Apply the Date formatCtrl+Shift+3
- Open Format CellsCtrl+1
- Group rows or columnsAlt+Shift+Right
- Hide the selected columnsCtrl+0
- Hide the selected rowsCtrl+9
- Apply the Number formatCtrl+Shift+1
- Add an outline borderCtrl+Shift+7
- Apply the percent formatCtrl+Shift+5
- Apply the Scientific formatCtrl+Shift+6
- Apply strikethroughCtrl+5
- Apply the Time formatCtrl+Shift+2
- Unhide rowsCtrl+Shift+9