AutoFilter

Secara otomatis memfilter rentang sel yang dipilih, dan membuat kotak daftar satu baris tempat Anda dapat memilih item yang ingin Anda tampilkan.

Untuk mengakses fungsi ini...

From the menu bar:

Pilih Data - Penyaringan Otomatis.

From the tabbed interface:

Choose Data - AutoFilter.

On the Data menu of the Data tab, choose AutoFilter.

From toolbars:

Icon Autofilter

Saring Otomatis

From the keyboard:

+ Shift + L


tip

Untuk memasukkan Penyaringan Otomatis berbeda ke lembar yang berbeda, pertama anda harus menetapkan sebuah jarak basis data setiap lembar.


Urut Naik

Displays the rows of the cell range in ascending order, based on the values in the cells of the current column.

Urut Turun

Displays the rows of the cell range in descending order, based on the values in the cells of the current column.

Tapis berdasarkan Warna

Warna teks

Displays only the rows of the cell range for which the text color of the cell in the current column matches the color selected.

Warna latar belakang

Displays only the rows of the cell range for which the background color of the cell in the current column matches the color selected.

Tapis berdasarkan Syarat

Kosong

Displays only the rows of the cell range that have an empty cell in the current column.

Tak Kosong

Displays only the rows of the cell range that have a non-empty cell in the current column.

10 Teratas

Displays the 10 rows of the cell range that contain the largest values in the cells of the current column. If these values are unique then no more than 10 rows will be visible, but if the values are not unique then it is possible for more than 10 rows to be shown.

10 Terbawah

Displays the 10 rows of the cell range that contain the lowest values in the cells of the current column. If these values are unique then no more than 10 rows will be visible, but if the values are not unique then it is possible for more than 10 rows to be shown.

Penapis Standar

Opens the Standard Filter dialog.

Search text box

Search for a specific entry in the list of values found in the current column. As characters are typed in the text box, this list is updated to show only matching entries.

Semua

Click once to select to show all rows and click again to select to hide all rows.

Show only current item

Display only rows containing the value highlighted in the Value box.

Hide only current item

Hide all rows containing the value highlighted in the Value box and display all other rows.

Nilai

List of unique values found in the current column.

Mohon dukung kami!