Make sure that you have the proper locale setting in Regional Settings or Regional and Language Options in Control Panel on your computer. Before you sort data, it's a good idea to unhide the hidden columns and rows.Ĭheck the locale setting Sort orders vary by locale setting. Unhide rows and columns before you sort Hidden columns are not moved when you sort columns, and hidden rows are not moved when you sort rows. In this case, make sure that you reapply the sort to get up-to-date results. If you get unexpected results when sorting your data, do the following:Ĭheck to see if the values returned by a formula have changed If the data that you have sorted contains one or more formulas, the return values of those formulas might change when the worksheet is recalculated. To delete a column to sort by, select the entry and then click Delete Level. To copy a column to sort by, select the entry and then click Copy Level.
To add another column to sort by, click Add Level, and then repeat steps three through five. To sort based on a custom list, select Custom List. Do one of the following:įor text values, select A to Z or Z to A.įor number values, select Smallest to Largest or Largest to Smallest.įor date or time values, select Oldest to Newest or Newest to Oldest. Under Order, select how you want to sort.
To sort by format, select Cell Color, Font Color, or Cell Icon. To sort by text, number, or date and time, select Values. In the Sort dialog box, under Column, in the Sort by box, select the first column that you want to sort. On the Data tab, in the Sort & Filter group, click Sort.
Note: For best results, the range of cells that you sort should have column headings.