onlineprograms.blogg.se

Can i sort table columns together in excel for mac

The above steps would sort the data just like it did in the first method.

In the Sort Warning dialog box pop-up, make sure ‘Expand the selection’ is selected.

In the Data tab, click on the A to Z sort icon.

This makes sure the entire dataset is sorted, and not just data in the Sales column. Make sure ‘Expand the selection’ is selected.

The above step would make a Sort Warning dialog box pop-up.

This will sort the sales data from largest to smallest.

In the Sort and Filter group, click on the Z to A sorting icon.

Select the column that you want to be sorted last (in this case, select the Sales data first – C1:C13).

This technique works the same way with a minor difference – you sort the second level first and then move to the first level sorting column.

Not many people know this way of doing a multiple level data sorting in Excel. Note: While this method is longer and takes a few more steps (as compared with the multi-sorting method covered next), I recommend using this as it is less confusing. All you need to do is add these sorting levels and specify the details.

You can have more than two-column sorting as well. In this example, I have sorted the data for two columns. Note that since it sorts the Region column first when the Sales column is sorted, the Region column remains unchanged. This sorts the data first by Region and then by Sales column. The above steps would give you the result as shown below. In the second level of sorting, make the following selections:.Click on Add Level (this will add another level of sorting options).If your data has headers, ensure that ‘My data has headers’ option is checked.Sort by (Column): Region (this is the first level of sorting).In the Sort Dialogue box, make the following selections.Click on the Sort Icon (the one shown below).Select the entire data set that you want to sort.Here are the steps to do multi-level sorting using the dialog box: When you sort data using the sort dialog box, you get an option to add multiple levels to it.