Filtering Cell Ranges
You can use several filters to filter cell ranges in spreadsheets. A standard filter uses the options that you specify to filter the data. An AutoFilter filters data according to a specific value or string. An advanced filter uses filter criteria from specified cells.
To Apply a Standard Filter to a Cell Range
-
Click in a cell range.
-
Choose
. -
In the Standard Filter dialog, specify the filter options that you want.
-
Click OK.
рд░реЗрдХреЙрд░реНрдб рдЬреЛ рдлрд╝рд┐рд▓реНрдЯрд░ рдорд╛рдкрджрдгреНрдб рд╕реЗ рдореЗрд▓ рдЦрд╛рддреЗ рд╣реИрдВ рдЬреЛ рдЖрдкрдиреЗ рдЪреБрдиреЗ рд╣реИрдВ рд╡реЗ рджрд┐рдЦрд╛рдП рдЧрдП рд╣реИрдВ.
To Apply an AutoFilter to a Cell Range
-
Click in a cell range or a database range.
If you want to apply multiple AutoFilters to the same sheet, you must first define database ranges, then apply the AutoFilters to the database ranges.
-
Choose
.An arrow button is added to the head of each column in the database range.
-
Click the arrow button in the column that contains the value or string that you want to set as the filter criteria.
-
рдореВрд▓реНрдп рдпрд╛ рд╕реНрдЯреНрд░рд┐рдВрдЧ рдЪреБрдиреЗрдВ рдЬрд┐рд╕реЗ рдЖрдк рдлрд╝рд┐рд▓реНрдЯрд░ рдорд╛рдкрджрдгреНрдб рдХреЗ рд░реВрдк рдореЗрдВ рдЗрд╕реНрддреЗрдорд╛рд▓ рдХрд░рдирд╛ рдЪрд╛рд╣рддреЗ рд╣реИрдВ.
рд░реЗрдХреЙрд░реНрдб рдЬреЛ рдлрд╝рд┐рд▓реНрдЯрд░ рдорд╛рдкрджрдгреНрдб рд╕реЗ рдореЗрд▓ рдЦрд╛рддреЗ рд╣реИрдВ рдЬреЛ рдЖрдкрдиреЗ рдЪреБрдиреЗ рд╣реИрдВ рд╡реЗ рджрд┐рдЦрд╛рдП рдЧрдП рд╣реИрдВ.
To Remove a Filter From a Cell Range
-
Click in a filtered cell range.
-
Choose
.