Sorting and filtering data
Spreadsheet is an amazing tool for analyzing data. Sort and Filter are some of the most commonly used features to help you. To change the order of your data, you’ll want to sort it. Sorting within Calc arranges the cells in a sheet using the sort criteria that you specify. Several criteria can be used and a sort applies each criteria consecutively. Sorts are useful when you are searching for a particular item and become even more useful after you have filtered data. Also, sorting is useful when you add new information to a spreadsheet. When a spreadsheet is long, it is usually easier to add new information at the bottom of the sheet, rather than adding rows in their correct place. After you have added information, you can then sort the records to update the spreadsheet.
Sorting can be done through two ways - using the sort icon or using sort dialog.
Sorting using sort icon:
For a quick sort, especially when only one level of sorting is to be done, the sort icon can be used. To do this,
Select the data to be sorted
Click on sort icon ascending/descending based on the need.
The data gets sort accordingly. For example, if ascending order icon is selected, the data gets sorted as shown below.
In case, if there are more than one column which has data related to the selected column, then when the icon is clicked a new window opens up asking whether the sorting has to be extended to all the data with respect to the selected one. For example, if the data is as below:
For example, if you want the data to be arranged such that the name is in ascending order, then select the name column and click ascending order icon. This displays a new window as shown below:
If you select ‘extended selection’, all the data related to the selected column will also gets rearranged simultaneously as below:
But if the ‘current selection’ is clicked, then the selected data alone gets ordered as shown below. But this will give a wrong information about each person (For example, gender of Ajith is shown as female). So whenever the data is related to each other, always select ‘extend selection’.
For a more complex sort i.e., when you want multiple levels of data, then use the sort dialogue. For example, if you want to sort the data based on gender and then want to order them based on ascending order of the names. To sort cells in a spreadsheet using the Sort dialog:
Select the cells to be sorted.
Select Data→Sort from the menu bar
Sort dialog window opens as shown below
Select the sort criteria from the drop-down lists. Sort key is to list the level of sorting. The selected lists are populated from the selected cells. For example, in the below image, the first level of ordering is gender and second level is based on the name of student is selected.
Select either ascending order (A-Z, 1-9) or descending order (Z-A, 9-1).
For example, here descending order is selected for gender and ascending for name of student
Click OK and the sort is carried out on your spreadsheet. After sorting, the data in the spreadsheet is rearranged as shown below
Spreadsheet is an amazing tool for analyzing data. Sort and Filter are some of the most commonly used features to help you. To change the order of your data, you’ll want to sort it. Sorting within Calc arranges the cells in a sheet using the sort criteria that you specify. Several criteria can be used and a sort applies each criteria consecutively. Sorts are useful when you are searching for a particular item and become even more useful after you have filtered data. Also, sorting is useful when you add new information to a spreadsheet. When a spreadsheet is long, it is usually easier to add new information at the bottom of the sheet, rather than adding rows in their correct place. After you have added information, you can then sort the records to update the spreadsheet.
Sorting can be done through two ways - using the sort icon or using sort dialog.
Sorting using sort icon:
For a quick sort, especially when only one level of sorting is to be done, the sort icon can be used. To do this,
Select the data to be sorted
Click on sort icon ascending/descending based on the need.
The data gets sort accordingly. For example, if ascending order icon is selected, the data gets sorted as shown below.
In case, if there are more than one column which has data related to the selected column, then when the icon is clicked a new window opens up asking whether the sorting has to be extended to all the data with respect to the selected one. For example, if the data is as below:
For example, if you want the data to be arranged such that the name is in ascending order, then select the name column and click ascending order icon. This displays a new window as shown below:
If you select ‘extended selection’, all the data related to the selected column will also gets rearranged simultaneously as below:
But if the ‘current selection’ is clicked, then the selected data alone gets ordered as shown below. But this will give a wrong information about each person (For example, gender of Ajith is shown as female). So whenever the data is related to each other, always select ‘extend selection’.
For a more complex sort i.e., when you want multiple levels of data, then use the sort dialogue. For example, if you want to sort the data based on gender and then want to order them based on ascending order of the names. To sort cells in a spreadsheet using the Sort dialog:
Select the cells to be sorted.
Select Data→Sort from the menu bar
Sort dialog window opens as shown below
Select the sort criteria from the drop-down lists. Sort key is to list the level of sorting. The selected lists are populated from the selected cells. For example, in the below image, the first level of ordering is gender and second level is based on the name of student is selected.
Select either ascending order (A-Z, 1-9) or descending order (Z-A, 9-1).
For example, here descending order is selected for gender and ascending for name of student
Click OK and the sort is carried out on your spreadsheet. After sorting, the data in the spreadsheet is rearranged as shown below
No comments:
Post a Comment