Groups the selected rows or columns, so you can collapse them with the minus button in the margin and expand them again with the plus button. With only some cells selected, Excel asks whether to group rows or columns. Groups are a tidier way than hiding to fold away detail in a report.
More Format shortcuts
- Apply the Currency formatCtrl+Shift+4
- Apply the Date formatCtrl+Shift+3
- Open Format CellsCtrl+1
- 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
- Ungroup rows or columnsAlt+Shift+Left
- Unhide rowsCtrl+Shift+9