Sort and filter

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 is not involved in the sorting and filtering. The sort and filter range cannot consist of one line.

2.On the Toolbar, select the Data section and click Sort and Filter.

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 Sort and Filter.

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 in the upper cell of the column.

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 in the upper cell of the column to be filtered.

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.

After filtering, only visible data is copied from the table. Hidden data is not copied.

Data can be copied and paste using standard methods. The copied data can be pasted in any place of the current or other MyOffice Spreadsheet document.

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 Sort and Filter button.

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 Sort and Filter.