Skip to playerSkip to main content
Learn how to short column in Excel without mixing data. You will be able to handle a situation on how do I sort columns in Excel and keep rows together and also answer why I can't sort all columns in Excel. And how do I sort multiple columns in Excel independently of each other?

Re-Order Columns
1) Assign column sorting order
2) Ctrl + A
3) Data ~ Sort & Filter ~ Sort
4) Options...
5) Select "Sort left to right"
6) OK
7) Set "Sort by" to "Row 1"
8) OK

How do I sort columns in Excel without mixing data?,How do I sort columns in Excel and keep rows together?,Why can't I sort all columns in Excel?,How do I sort multiple columns in Excel independently of each other?,

Check out my complete suite of Microsoft Excel Tips and Tricks.
https://www.youtube.com/@RabiGurungXybernetics/shorts
https://www.tiktok.com/@xybernetics247
https://www.instagram.com/rabi.gurung247/
https://www.pinterest.ca/RabiGurungXybernetics/excel-tips-and-tricks/
https://twitter.com/XyberneticsInc/media
https://www.reddit.com/r/Excel247/
https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks

Category

📚
Learning
Transcript
00:00There are many ways to reorder your column and this is by far the most easiest and the quickest
00:05way. So I'm going to say this is going to be my first column and this is going to be my second
00:09column. This is going to be my third column and I'm going to push this back to say fourth and fifth
00:14column like this. After you have selected your column order you're going to press ctrl a to
00:18highlight your whole data set. Then you go to data under sort and filter, click on sorting.
00:24This pop-up window will appear. Click on options. On your options you're going to select sort left
00:29to right and then click ok. And you sort by here. You're just going to select row one and then click
00:35ok. After that you'll see all your columns has been sorted according to what you have specified in row one.
Be the first to comment
Add your comment

Recommended