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. Image: Aajan, Getty Images/iStockphoto Must-read Windows coverageĭefend your network with Microsoft outside-in security services For more info, visit our Terms of Use page. This may influence how and where their products appear on our site, but vendors cannot pay to influence the content of our reviews. We may be compensated by vendors who appear on this page through methods such as affiliate links or sponsored partnerships. 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

Excel shortcut keys for color fill