{"id":268,"date":"2014-12-27T11:39:13","date_gmt":"2014-12-27T03:39:13","guid":{"rendered":"http:\/\/excelchamp.net\/?p=268"},"modified":"2022-07-11T06:27:40","modified_gmt":"2022-07-10T22:27:40","slug":"re-sorting-a-list-or-table-in-excel","status":"publish","type":"post","link":"https:\/\/www.excelchamp.net\/re-sorting-a-list-or-table-in-excel\/","title":{"rendered":"Quick Tip: Re-Sorting a List or Table in Excel"},"content":{"rendered":"

Of course you know how to sort data in Excel! Simply click on the Sort<\/em> button, or click on the mini A-Z<\/em> or Z-A<\/em> chicklet buttons, and voila! the list is sorted. And if you want more control, you can try Custom Sorting, and Advanced Sorting with this Method<\/a>.<\/p>\n

The problem is that a sorted list often gets out of sync, if you keep adding or editing data in the table.<\/strong> And if you use a Custom Sorting sequence, you can’t simply click on the single column sorting chicklets any longer\u00a0 \ud83d\ude41<\/p>\n

So you have to go to Custom Sort<\/em>, and click it again to get the list sorted one more time.
\n\t\t

\n\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

Want to Improve Your Excel Skills?<\/strong><\/span><\/p>

Learn the Key Features of Excel Quickly & Easily, by <\/span>Joining the
Online Training<\/strong> on <\/u>Basic \/ Intermediate Excel<\/u>.<\/strong><\/a><\/span><\/p>

To Get Most out of Excel, Learn the\u00a0 Pivot Table techniques in our
Pivot Table Masterclass Training<\/a><\/u><\/b>!<\/strong><\/a><\/span><\/p><\/div>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t
\nA Quick Way to Sort Your Custom Sorted Table in Excel<\/strong>
\nFortunately, there is a quicker and shorter way. All you need to do is to click on the Reapply<\/strong> button, which shows up once you click on the Sort<\/strong> menu on the Home<\/strong> Tab.<\/p>\n

\"Reapply<\/a>
Reapply Sorting in Excel<\/figcaption><\/figure>\n

There’s a shortcut – Ctrl + Alt + L<\/strong><\/em><\/p>\n

This makes the current list or table sorted again. Even if you had multiple columns in the custom sorted list.<\/p>\n

What I have done is to put this Reapply<\/strong> button on my Quick Access Toolbar<\/strong> in Excel. This makes it much snappier to apply it anytime, anywhere in Excel.<\/p>\n

\"Reapply<\/a>
Reapply Sorting Button in the Quick Access Toolbar<\/figcaption><\/figure>\n

Hope you like this quick tip. It has saved me quite a few clicks, and a lot of time searching for something in a not so sorted table…<\/p>\n

Cheers,
\nVinai Prakash<\/p>\n

PS: Check out how to sort in a unique manner – not ascending , not descending<\/a>. Sorting it Your Way!<\/p>\n

Also, let me know if there is anything in Excel that bothers you…. anything where you could get some help. Simply post it into a comment or email it to me, and I’ll see what I can do to help you out \ud83d\ude42 – Vinai
\n\t\t

\n\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

Are you facing any problem in using Excel? Any Question?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

You have come to the right place<\/span>. Tell us your needs. We’ll be glad to help you!<\/span><\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\n\t\t\t\n\t\t\t\n\n\t\t\t\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t