From the course: Excel 2019 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Sorting data

Sorting data

From the course: Excel 2019 Essential Training

Start my 1-month free trial

Sorting data

- [Instructor] If you work with lists in Excel, it's quite likely you want to sort the list. And sorting typically means rearranging the order of rows within a list. Looking at a worksheet called Sorting, it's in the Workbook Ten, Data Management Features. As you look at the list, you can probably see that the data appears to be in descending order based on what's in either column H or J, not necessarily sure, but we might want to rearrange it, for example, sort by Department. Now, although there is that rare occasion where you might wanna sort by moving columns left and right, for most people most of the time, sorting means, what? Moving a row, or this part of a row, up and down within a list. If you have other data on the worksheet, and I do to the right, if you don't want that to be part of the sorting process, make sure it's isolated from your data, at least one empty column. It's unlikely that you'd have any data below it, but if that's the case, keep it separated, as well. When…

Contents