Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.
Worth $20, Absolutely Free
Have you ever wondered that you can horizontally sort data in Excel? I mean, you can sort columns like you sort rows.
This is a useful option to streamline columns or if you want to arrange them in alphabetic order.
Want to know the best part?
You just need 5 seconds for this.
So today, in this post, I’d like to share with you simple step to horizontally sort data. And apart from this, I ‘d also like to share a simple tweak which you can do to sort columns in custom order.
So let’s get started.
Congratulations! you have horizontally sort your data.
Important Note: With Excel tables your are not able to use this technique.
In real life, there is more need to sort your columns in a custom order rather than using an alphabetic order.
Follow these simple steps.
It’s the biggest time saver when you have large data sets, 50-100 column. Once you sort all of them, it’s easy to find a column from an alphabetic order.
And, the best thing is you can sort columns in custom order using this method instead of copy-pasting them one by one.
I hope this tip will help you to get better at Excel.
Now tell me one thing. Have you ever tried this method before? Please share with me in the comment section.
And, please don’t forget to share this tip with your friends.