filmov
tv
Sort columns in Excel without mixing data... The Easy Way - Excel Tips and Tricks

Показать описание
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
#shorts #short #shortvideo #fyp #excel #microsoft #tiktok #fypシ
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
#shorts #short #shortvideo #fyp #excel #microsoft #tiktok #fypシ