On the Home tab, you can click Sort & Filter in the Editing group. Click anywhere inside the column you want to sort by and click one of the Sort options in the Sort & Filter on group on the Data tab. How to do a single-column sort in ExcelĮven the newest of users can run a simple ascending or descending sort on a single column. This article isn’t appropriate for the browser version. You can work with your own data or download the demonstration. I’m using Microsoft 365 on a Windows 10 64-bit system, but you can use older versions. SEE: 60 Excel tips every user should master Then, we’ll look at a macro that runs a two-column sort. First, I’ll show you how to find some keyboard shortcuts for one-column sorts. It’s still easy, but it can stop you in your tracks and some users don’t like to slow down that much. However, once you get into sorting multiple columns, a sort requires more clicks and choices. For the most part, we run so many simple sorts that we think nothing of it. Sorting data is easy and for the most part, Microsoft Excel offers a number of ways, including keyboard shortcuts, to get the job done. How to reset your Windows 10 password when you forget it Image: Aajan, Getty Images/iStockphoto Must-read Windows coverageĭefend your network with Microsoft outside-in security services Here are some ways to make your sorting life easier. If you run sorts in Excel a lot, you might benefit from shortcuts or even a macro. How to use shortcuts to sort in Microsoft Excel
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |