Excel shortcuts

15 Excel Shortcuts for Grouping Data Fast

If you work with data in Microsoft Excel, you know how important it is to be able to group and ungroup data quickly and easily. There are a few different ways to do this, but the best way is to use some of the built-in shortcuts that Excel offers. Here are 15 of the best shortcuts for grouping data in Excel:

  1. Ctrl + Shift + ' - This shortcut will select the entire column of data that you have highlighted. This is a great shortcut for quickly selecting all of the data in a column that you want to group together.
  2. Ctrl + Shift + - This shortcut will select the entire row of data that you have highlighted. This is a great shortcut for quickly selecting all of the data in a row that you want to group together.
  3. Ctrl + ' - This shortcut will copy the value from the cell above the cell that you have highlighted. This is a great shortcut for quickly copying data from one cell to another.
  4. Ctrl + - This shortcut will delete the row of data that you have highlighted. This is a great shortcut for quickly deleting data that you no longer need.
  5. Ctrl + / This shortcut will select the entire worksheet that you have highlighted. This is a great shortcut for quickly selecting all of the data in a worksheet that you want to group together.
  6. Ctrl + A This shortcut will select all of the data in the worksheet. This is a great shortcut for quickly selecting all of the data in a worksheet that you want to group together.
  7. Ctrl + B This shortcut will bold the data that you have highlighted. This is a great shortcut for quickly making data stand out.
  8. Ctrl + I This shortcut will italicize the data that you have highlighted. This is a great shortcut for quickly making data stand out.
  9. Ctrl + U This shortcut will underline the data that you have highlighted. This is a great shortcut for quickly making data stand out.
  10. Ctrl + 5 This shortcut will strike through the data that you have highlighted. This is a great shortcut for quickly making data stand out.
  11. Ctrl + E This shortcut will center the data that you have highlighted. This is a great shortcut for quickly aligning data.
  12. Ctrl + J This shortcut will justify the data that you have highlighted. This is a great shortcut for quickly aligning data.
  13. Ctrl + L This shortcut will left align the data that you have highlighted. This is a great shortcut for quickly aligning data.
  14. Ctrl + R This shortcut will right align the data that you have highlighted. This is a great shortcut for quickly aligning data.
  15. Ctrl + M This shortcut will indent the data that you have highlighted. This is a great shortcut for quickly indenting data.
  16. Ctrl + Shift + M This shortcut will outdent the data that you have highlighted. This is a great shortcut for quickly outdenting data.

These are just a few of the many shortcuts that you can use to group data in Excel. These shortcuts will save you time and make your job easier. Give them a try the next time you are working with data in Excel.

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.