Excel shortcuts

15 Keyboard Shortcuts for Grouping Data in Excel

1. To group rows: Select the rows you want to group, then press Ctrl+Shift+↓ (down arrow).

2. To group columns: Select the columns you want to group, then press Ctrl+Shift+→ (right arrow).

3. To ungroup rows: Select the rows you want to ungroup, then press Ctrl+Shift+↑ (up arrow).

4. To ungroup columns: Select the columns you want to ungroup, then press Ctrl+Shift+← (left arrow).

5. To group by rows and columns at the same time: Select the cells you want to group, then press Ctrl+Shift+↓ (down arrow) followed by Ctrl+Shift+→ (right arrow).

6. To ungroup by rows and columns at the same time: Select the cells you want to ungroup, then press Ctrl+Shift+↑ (up arrow) followed by Ctrl+Shift+← (left arrow).

7. To group by rows and columns at the same time (alternate method): Select the cells you want to group, then press Ctrl+Shift+↓ (down arrow) followed by Ctrl+Shift+→ (right arrow).

8. To ungroup by rows and columns at the same time (alternate method): Select the cells you want to ungroup, then press Ctrl+Shift+↑ (up arrow) followed by Ctrl+Shift+← (left arrow).

9. To group by rows: Select the rows you want to group, then press Ctrl+Shift+↓ (down arrow).

10. To group by columns: Select the columns you want to group, then press Ctrl+Shift+→ (right arrow).

11. To ungroup by rows: Select the rows you want to ungroup, then press Ctrl+Shift+↑ (up arrow).

12. To ungroup by columns: Select the columns you want to ungroup, then press Ctrl+Shift+← (left arrow).

13. To group by rows and columns at the same time: Select the cells you want to group, then press Ctrl+Shift+↓ (down arrow) followed by Ctrl+Shift+→ (right arrow).

14. To ungroup by rows and columns at the same time: Select the cells you want to ungroup, then press Ctrl+Shift+↑ (up arrow) followed by Ctrl+Shift+← (left arrow).

15. To group by rows and columns at the same time (alternate method): Select the cells you want to group, then press Ctrl+Shift+↓ (down arrow) followed by Ctrl+Shift+→ (right arrow).

16. To ungroup by rows and columns at the same time (alternate method): Select the cells you want to ungroup, then press Ctrl+Shift+↑ (up arrow) followed by Ctrl+Shift+← (left arrow).

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.