In MyOffice Spreadsheet, you can sort and filter data on the sheet you are working on.
To define a sort and filter range, follow these steps: 1.Select the range of cells that will contain all the data to be sorted and filtered. The upper line of the range marked as
![]() 2.On the Toolbar, select the Data section and click The active sort and filter range on the sheet is as follows: •Headings of rows and columns are highlighted in green. •A green frame appears around the range. |
MyOffice Spreadsheet can automatically detect the sort and filter 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, follow these steps: 1.Select an empty cell bordering the range. 2.On the Toolbar, select the Data section and click |
When sorting, the selected values in the column are arranged in the ascending (from A to Z) or descending (from Z to A) order. To sort data in a column, proceed with the following: 1.Click 2.In the opened sort and filter settings window, select the sorting mode: •Ascending: Sort the data in ascending order. •Descending: Sort the data in descending order. |
Using filtering, you can hide or unhide the selected cells in the column. To filter data, proceed with the following: 1.Click 2.In the opened sort and filter setting window, uncheck the Clear All box. 3.If necessary, you can adjust the width and/or height of the window: •To increase or decrease the window width, move its right border to the left or right. •To increase or decrease the window height, move its bottom border up or down. •To adjust the window width and height simultaneously, move its bottom right corner in the desired direction. 4.Check the boxes with values to be displayed in the column. 5.If there are too many values in the list, use the search field: •Enter the value you want to find (in full or partially). For example, to find the number 123, you can enter the numbers 12, 23 or 123 in the search field. •Check the values to be displayed in the column in the search results. •To find and check other values, repeat the procedure. 6.Click ОК. To display all the data in the column again, open the Sort and Filter window once again and check the Select All box. |
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, select the Data section and click the arrow to the right of the 2.Select the Refresh option from the drop-down menu. |
To finish working with the current sorting and filtering range, on the Toolbar, in the Data section, click When you finish working with a range, only the sorting results will be saved in the spreadsheet. Filtering results are not saved.
|