In Excel, it seems easy to sort rows, because there is a button sort & filter button on menu bar. You can sort rows from smallest to largest or largest to smallest one. However, it seems difficult or impossible to sort columns, because any method can't be found on menu bar.
But, It's totally same. By default, it is set to sort rows. To make the change, just follow few steps.
1. Click sort & filter button on right most side of Excel menu bar. Then you can see custom sort sub menu item. (see below). Click the 'Custom Sort' item.
2.You can see a dialog name sort. Click options button, the a small dialog named 'Sort Options' will be opened shown as below. There are two options:
Just select Sort left to right option.
3. Just choose a row you want to sort by.
4. DONE.
But, It's totally same. By default, it is set to sort rows. To make the change, just follow few steps.
1. Click sort & filter button on right most side of Excel menu bar. Then you can see custom sort sub menu item. (see below). Click the 'Custom Sort' item.
2.You can see a dialog name sort. Click options button, the a small dialog named 'Sort Options' will be opened shown as below. There are two options:
- Sort top to bottom : it's default value to to sort rows.
- Sort left to right: it will sort columns.
Just select Sort left to right option.
3. Just choose a row you want to sort by.
Comments
Post a Comment