![how to sort excel for mac 2018 how to sort excel for mac 2018](https://cdn.ablebits.com/_img-blog/sort-dates/sort-data-by-date.png)
01:04 So, if we wanted to sort by descending by Max Balance,.01:00 by, and you click the A to Z, or the Z to A icon.00:55 Basically, we go to the Data tab, and you select the column that you want to sort.00:53 Sorting is relatively straight forward.00:50 different, and I'll show you why, in a second here.00:46 While it's not essential, it is helpful to have a nice header row that's a little bit.00:43 So, there's no blank rows, no blank columns, and that's great.00:41 is you can see we have what we call contiguous list of data.00:33 That's like absolute killer to most of Excel's advanced features.00:30 row between the header row of their table, and their actual data.00:27 So, a lot of users are tempted to put a blank.00:24 or columns interrupting the data that you want sorted.00:20 And we need to make sure that there are no blank rows,.00:17 So, something that looks a bit like a table like you see here.00:11 sort data is it's really important to make sure that your data is already in.00:08 Now, the big keys that you really wanna understand before you try and.
HOW TO SORT EXCEL FOR MAC 2018 HOW TO
00:00 In this video, we're gonna look at how to sort data in Excel.You can continue to add as many sorting levels as you need.Configure the secondary sort the way you’d like to sort the ties.Configure the primary sort the way you’d like to see it.Multi-level sorts allow you to sort by one column, then use another column to sort ties.Configure the way you’d like it sorted, then click OK.Select any cell inside your data table (or the entire range you want to sort).While not essential, it is certainly preferable to have a clear header row for your data.
![how to sort excel for mac 2018 how to sort excel for mac 2018](https://imgix.lifehacker.com.au/content/uploads/sites/4/2012/03/ExcelSorting.jpg)
![how to sort excel for mac 2018 how to sort excel for mac 2018](https://garysch.files.wordpress.com/2020/12/excel-consolidate-data-blog.png)
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.