In MyOffice Spreadsheet, you can sort and filter data within the sheet you are working on.
To select a range for sorting and filtering, do the following: 1.Select a range of cells which contains all data to be sorted and filtered. The range cannot consist of one line.
2.On the Toolbar, click . Or, in the Command menu, select and click .
The active Sort and Filter range on the sheet looks as follows: •Headings of rows and columns are highlighted in green. •A green frame appears around the range. The upper line of the range marked as is not involved in the Sort and Filter.
|
MyOffice Spreadsheet can automatically detect the range if the cells adjacent to the selected one contain data. Data in adjacent cells can be of any format. To automatically detect the range: 1.Select an empty cell bordering the range. 2.On the Toolbar, click . Or, in the Command menu, select and click . |
Using filtering, you can hide or unhide the selected cells in the column. You can use different filters for different columns. If your spreadsheet was created using third-party editors and exported to MyOffice Spreadsheet, select the elements with the mouse to enable filters.
To filter data, do the following: 1.Click in the upper cell of the column to be filtered. 2.In the opened window, check the boxes with values to be displayed in the column. 3.Click to apply the filter or . To quickly select or deselect all items in the range, use the . When you copy a range of cells, the data hidden by filters is not copied.
|
When sorting, the selected values in the column are arranged in the ascending (from A to Z) or descending (from Z to A) order. You can set different sorting criteria for each column. To sort data in a column, do the following: 1.Click in the upper cell of the column. 2.In the opened setting window, select the sorting mode: •Sort the data in ascending order. • Sort the data in descending order. To sort data in a cell range, do the following: 1.Select a cell range which will contain all the data to be sorted. The range should consist of more than one line. 2.On the Toolbar, click . Or select of the Command menu and click . 3.In the opened window, select the columns to which the sorting order will be applied and set the desired sorting mode for each of the columns:
4.By default, sorting is performed on the rightmost column. To add other columns, click. 5.To sort according to the selected parameters, click . To cancel the selection and close the window, click . |
To quickly select values to be used for filtering, use the box: 1.Select in the upper cell of the column that you want to filter. 2.In the opened window, enter the value that you want to find in the box. 3.Click in front of the values that you want to display in the column. 4.Click to apply the filter or to cancel the selection and close the window. |
If the values in the selected range have changed, you can reapply a filter to the data without reconfiguring the filter itself. For this purpose: 1.On the Toolbar, click the . Or, in the Command menu, select . 2.Select the command from the drop-down menu. |
To clear all the filters applied to the table, do the following: 1.Click on the Toolbar. Or, in the Command menu, select . 2.Select the command from the drop-down menu. |
To remove the current range, on the Toolbar, click Filter. When you are done working with a range, only the sorting results will be displayed in the spreadsheet.
|