+4 votes
56 views
in Office by (242k points)
reopened
Excel: Sort rows - that's how it's done

1 Answer

+5 votes
by (1.6m points)
 
Best answer

How to sort the rows in Excel spreadsheets
1st step:
2nd step:
3rd step:
4th step:
5th step:
quick start Guide

Excel can do a lot. Sort your data by lines, among other things. You can find out exactly how this works here..

image image

With Excel from Microsoft Office you can not only create simple tables. It can do a lot, and if you know how to do it, Excel can make your job a lot easier. It is especially useful if you have your table sorted. You can sort by rows or columns and specify different values ​​for sorting.

How to sort the rows in Excel spreadsheets

Follow our step-by-step instructions or take a look at the brief instructions .

1st step:

image
Open your Excel document and switch to the " Data " tab at the top . Now click on the " Sort " button there .

2nd step:

image
Then click on " Options ... " in the new window to see further settings for sorting.

3rd step:

image
Under " Alignment " select " Sort lines ". Then click OK .

4th step:

image
Under " Column ", select a column according to which your rows should be sorted. If necessary, select under " Order " which value is to be used for sorting. Then click OK .

5th step:

image
Your table should now be sorted according to your settings.

quick start Guide

  1. Open your Excel document, switch to the " Data " tab and click on " Sort ".
  2. Now go to " Options ... " and then select " Sort rows ".
  3. Then select a column under " Column " by which you want to sort. If necessary, select a sort value under " Order ".

...