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.

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

The active sort and filter range on the sheet is displayed 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 with is not involved in the sorting and filtering.

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 the empty cell that is adjacent to the range.

2.On the Toolbar, in the Data section, 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.

If a sorting and filtering range is defined on the sheet and the user selects in the table:

•A column or a cell: The entire sorting and filtering range is sorted by that column.

•A range of cells in different columns: The entire sorting and filtering range is sorted by the left-most column of the selected range.

If the user selects a range of cells both inside and outside the sort and filter range at the same time, the data is sorted only in the sort and filter range according to the rule described above.

If no sort and filter range is defined on the sheet and the user selects a range of cells, filtering is automatically enabled for that range and sorting is performed on the leftmost column of the range.

To sort the data, follow these steps:

1.Select the column or cell of the column you want to sort by.

2.On the Toolbar, in the Data section, click the arrow to the right of the button and select the Sort in Ascending Order / Sort in Descending Order command from the drop-down list.

Or do the following:

1.Click the button in the upper cell of the column you want to sort by.

2.In the opened Sort and Filter window, select the sorting method: In Ascending Order or In Descending Order.

Using filtering, you can hide or display cells in a column with selected values, with a selected fill color or date matching conditions.

To filter cells by value, follow these steps:

1.Select the range to filter.

2.Click the button in the upper cell of the column where you want to filter the data.

3.In the window that opens, make sure that By value filtering method is selected and clear the Select All checkbox.

4.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.

5.Select the checkboxes next to the values you want to display in the column.

6.If the selected filter range has cells in the Date or Date and Time format, their values are grouped in the list by year and month. To expand a grouped list row, click the button.

7.If the list contains a large number of values, use the search bar:

•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 bar.

•You can search for dates by entering all or part of a numeric value (for year, month, and number), the name of a month, or the entire date in the format “DD.MM.YYYY” or “DD.MM.YY”. In this case, if you enter “01” in the search, the year 2001, January, 1st day will be displayed, and if you enter “1”, January will not be included in the search results (the month corresponds to “01”, but not to “1”).

•In the search results, select the checkboxes next to the values you want to display in the column.

•If necessary, repeat the steps to find and select other values.

8.Click Apply.

To display all cells in a column again, reopen the Sort and Filter window and select the Select All checkbox. Or click Clear Filter.

To filter cells by fill color, follow these steps:

1.Select the range to filter.

2.Click the button in the upper cell of the column where you want to filter the data.

3.In the window that opens, select By color filtering method. Filtering by color is available if the range has filled cells.

4.In the palette of colors available for filtering, select a fill color.

5.Click Apply.

To display all cells in a column again, reopen the Sort and Filter window and click Clear Filter.

To filter cells by date, follow these steps:

1.Select the range to filter.

2.Click the button in the upper cell of the column where you want to filter the data.

3.In the window that opens, select the By date filtering method. Filter by date is available if the range has cells in Date or Date and Time format.

4.In the drop-down list, select the condition to filter:

•Exact date: The date in the cell should match the date entered.

•Before: The date in the cell should precede the entered date.

•After: The date in the cell should follow the entered date.

•Between: The date in the cell should be within the specified range, including its outermost values.

5.In the field below the drop-down list, enter the date or dates (for the Between condition) manually or click the button and select a date in the calendar. If you type an incorrect data entry, the field can be quickly cleared by clicking the button.
The following date input formats are supported for manual entry: “dd.mm.yyyy”; “dd.mm.yy”; “d.m.yy”; “dd month yyyy” (month can be entered in Russian only); “dd mmm yy” (for example, “mmm” = “ноя”); “mmm-yy”; “dd-mmm” (the current year will be used); “yy.mm.dd”; “yyyy.mm.dd”; “y.m.dd”; “y.m.d”; “y.mm.dd”; “dd month yy”; “yy mmm dd”; “dd mmm yyyy”; “mmm yyy”; “mmm-yyyy”; “mmm yyyy”; “yy mmm”; “yymmm”.

6.Click Apply.

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

You can copy and paste data using standard methods. The copied data can be pasted anywhere in the current or another MyOffice Spreadsheet document.

If the values in the selected range have changed during work, you can re-filter the data without changing the filter settings. To do this, proceed as follows:

1.On the Toolbar, select the Data section and click the arrow to the right of the  Sort and Filter button.

2.In the drop-down menu, select Refresh.

To finish working with the current sorting and filtering range, on the Toolbar, in the Data section, click  Sort and Filter.