InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What data can microsoft excel sort |
|
Answer» You can sort your Excel DATA on one column or multiple columns. You can sort in ascending or descending order.One ColumnTo sort on one column, execute the following steps.1. CLICK any CELL in the column you want to sort.Note: to sort in descending order, click ZA.Multiple ColumnsTo sort on multiple columns, execute the following steps.1. On the Data tab, in the Sort & Filter group, click SortThe Sort dialog box appears.2. Select Last Name from the 'Sort by' drop-down list.Sort by3. Click on Add Level.4. Select Sales from the 'Then by' drop-down list.Then by5. Click OK.Result. Records are sorted by Last Name first and Sales second. |
|