Microsoft Excel for Mac 2011 represents the largest step forward for serious Mac spreadsheet jockeys in many years, more so than either Excel 2004 ( ) or Excel 2008 ( ). There are literally. A shortcut way to group rows or columns is to highlight the rows/columns you wish to group and use ALT+SHIFT+RIGHT ARROW to group the rows/columns, and ALT+SHIFT+LEFT ARROW to ungroup them. You can go multiple levels as well (so you could group rows 1-30, and then group rows 20-25 as a subgroup of the first).
This Excel tutorial explains how to sort data in alphabetical order based on two columns in Excel 2011 for Mac (with screenshots and step-by-step instructions).
See solution in other versions of Excel:
Question: In Microsoft Excel 2011 for Mac, I'm trying to sort a chart that has 6 columns of data. I need to sort this data by 2 columns - first by column B (ie: Product column) in alphabetical order and then by column D (ie: Quantity) smallest to largest. How do I do this?
Answer: To apply this sort in Excel, highlight the data that you wish to sort. Then select the Data tab from the toolbar at the top of the screen. Then click on the Sort button and select Custom Sort from the popup menu.
When the Sort window appears, select the first column that you wish to sort by. In this example, we want to sort by the Product column (column B) in alphabetical order (A to Z). Then click on the + sign at the bottom left of the window.
Enter the second column that you wish to sort by. In this example, we want to sort next by the Quantity column (column D) in Smallest to Largest. Then click on the OK button.
![Manually group rows in excel Manually group rows in excel](https://www.techonthenet.com/excel/cells/images/merge_cells2011_001.gif)
Now when you return to the spreadsheet, the data should be sorted first by Product and then by Quantity.