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).
Select a table to sort, or select just specific rows in a column to sort. In the Organize sidebar, click the Sort tab. Click the pop-up menu in the sidebar and choose Sort Entire Table or Sort Selected Rows. Click Add a Column. Choose a column to sort by, then click the pop-up menu in the rule and choose Ascending or Descending.
See solution in other versions of Excel:
- May 15, 2018 Click Sort range on the Data menu. This option will open a new pop-up window, and allow you to customize your sorting settings. This option will sort the selected column, and won't affect any other data. If you want to sort all the rows in your spreadsheet according to the data in the selected column, click Sort sheet by column on the Data menu.
- 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. In this example, we want to sort by the Product column (column B) in alphabetical order (A to Z).
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.
How To Sort By Date In Excel 2011 For Mac Torrent
Now when you return to the spreadsheet, the data should be sorted first by Product and then by Quantity.