Sort cells in excel mac

How To Sort Data In Rows In Excel In columns containing both text and numbers, ascending order sorts numbers before text for example, 1a, 1b, 2a, a1, b1. To sort only a subset of rows, select the range, Control-click the selected cells in the column by which you want to sort, then choose Sort Rows Ascending or Sort Rows Descending.

Excel for Mac 2011: Sort and Filter in Tables and Worksheets

You can sort a table by creating sorting rules, which allow you to specify multiple criteria for sorting and their order of importance. For example, you can sort a list of swimmers by age and then by their time in an event. The result will order the swimmers at each age level according to their speed. Choose a column to sort by, then click the pop-up menu in the rule and choose Ascending or Descending.

How to Sort Data in Excel for Mac 2011

To reorder the rules, move the pointer over the rule, drag , then click Sort Now. Alphabetize or sort by ascending or descending values To sort the whole table, select the table. If you do, the sort will be applied only to the contents of the column, not the entire table or data range. After 27 years, Microsoft changed the name of this feature from AutoFilter to just Filter? The Filter feature places a button to the right of each cell in the header row of a table or data range. Filter is turned on by default when you make a table, and you can see these buttons in the header row of a table.

You can toggle Filter on or off by pressing Command-Shift-F. When you click the Filter button in a column header, the Filter dialog displays. The column header label is the title of the dialog. Filter lets you sort and filter. Click this button to sort the column from lowest to highest or alphabetically. You can also sort by an icon set that was created by using a conditional format.

Because there is no default sort order for cell color, font color, or icons, you must define your own order for each sort operation. Under Column , click the blank space next to Then by , and then on the shortcut menu, click the column that you want to sort by.

Numbers for Mac: Alphabetize or sort data in a table in Numbers

Under Order , choose whether the selected color or icon should be at the top or bottom of the list. Be careful when you use this feature. Sorting by one column in a range can produce results that you don't want, such as moving cells in that column away from other cells in the same row.

Create a sorting rule

In Excel, you can sort numbers, text, weekdays, months, or items from custom lists that you create. You can also sort by font color, cell color, or icon sets. This Excel tutorial explains how to sort data in alphabetical order based on two columns in Excel for Mac (with screenshots and step-by-step instructions).

To remove table formatting so that you can sort one column, on the Table tab, select Convert to Range. In the Sort Warning that appears, select Continue with the current selection , and then click Sort.

Office 2011 for Mac All-in-One For Dummies

If the results are not what you want, click Undo. Data analysis begins with sorting. You can sort text A to Z or Z to A , numbers smallest to largest or largest to smallest , and dates and times oldest to newest and newest to oldest in one or more columns. You can also sort by a custom list that you create such as Large, Medium, and Small. Or you can sort by format, including cell color, font color, or icon set. Most frequently, you will sort by column, but you can also sort by rows. When you sort, you rearrange data into some order.

In contrast, when you filter, you hide extraneous data. For more information about filtering, see Filter a list of data. When you sort on a range of cells, the sort criteria aren't saved with your workbook. If you want to save sort criteria so that you can reapply it the next time that you open the workbook, you can save the data as a Excel table. Save your data in a table when you are sorting multiple columns or if you create complex sorting criteria that takes a long time to create.

When you reapply a sorting criteria, you may see different results. This can occur if values that are returned by a formula have changed and the sheet is recalculated. It can also occur if the range of cells or table column has had data added, changed, or deleted.


Excel sorts data by using the following ascending sort order: Click Add Level. If the table has a header row, select the My list has headers check box. But if the table does not have a header row, clear the My list has headers check box. Under Row , click the blank space next to Then by , and then on the shortcut menu, click the row that you want to sort next.

How To Auto-Refresh Filtered Data In Excel When It Is Updated

At the top of the dialog box, select Add Level to add the second sort level. When Excel finds cell icons in the selected data, it adds those icons to the options listed under the Order heading in the dialog box. When you are finished, click OK. The previous window will show you three columns; Row, Sort On, and Order. Once your custom list is created, to use it, in the Sort box, under Order , select Custom List. At the top of the dialog box, click on select Add Level to add the second sort level. Choose One:

Type your list entries in the order that you want them sorted. When you are finished, click OK. If the results are not what you expected, the column might contain dates or times that are stored as text or numbers, instead of as dates or times.

To store the numbers in date or time format, select the column, and on the Home tab, under Number , point to Number Format , and then click Date or Time. This procedure cannot be performed in a table. You can sort Chinese text by Chinese character pronunciation or Chinese character stroke numbers. To complete this procedure, you must first turn on Chinese language features. For more information, see Turn on Chinese language features.

To add another sorting criteria, click Add Level.