From the course: Excel 2016: Tips and Tricks

Unlock the full course today

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

Sort data with single buttons

Sort data with single buttons

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

Sort data with single buttons

“

- [Voiceover] There are a lot of different way to sort data in Excel, and the standard way is to go to the Data tab in the ribbon, and use either of the single AZ or ZA sort buttons or the larger button that leads us into the Sort dialogue box. Sorting can be a lot faster, sometimes just with keystroke shortcuts or a simple click on the AZ or ZA button. Now before sorting data, you should always have a sense or know that your data is in one solid cluster. No empty rows within the data, no empty columns. If you have converted your data to a table, you don't worry about that very much, so I'd highly recommend exploring that option if you haven't already. This list has no empty rows or columns within it and I might wanna sort it quickly, simply by employee name. I can click anywhere in column A, click the AZ button, there it is, simple, fast. At a later time, maybe I wanna sort by building. I'll click there, click AZ. Now, what's important to remember is that when you use these button…

Contents