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?
![How to sort excel spreadsheet How to sort excel spreadsheet](/uploads/1/2/5/3/125390705/525702034.png)
March 29, 2018 ziplayanayakkabi.club excel Leave a comment. Data Analysis In Excel For Mac. Sort Excel Columns.
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). Then click on the + sign at the bottom left of the window.
Enter the second column that you wish to sort. In this example, we want to sort next by the Quantity column (column D) in Smallest to Largest.
Then click on the OK button. Now when you return to the spreadsheet, the data should be sorted first by Product and then by Quantity.
. Click Window menu Reference Manager. Click Attach Reference in the Reference Manager palette. In the Select Reference File, select the required Excel file. The New Excel Data Link dialog box appears.
Choose the necessary settings and click OK. A floating table appears along with a prompt to specify the insertion point.
Select a point in the drawing to insert. The table is inserted into the drawing and retains all the formatting details of the excel sheet including the background color of the table cells.