Cara Menghapus Filter di Microsoft Excel

Unduh PDF
Disusun bersama Staf wikiHow

Unduh PDF

Artikel ini mengajarkan cara menghapus filter data dari sebuah kolom atau seluruh lembar kerja Microsoft Excel.

Metode 1
Metode 1 dari 2:

Menghapus Filter di Satu Kolom

Unduh PDF
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/f9\/Clear-Filters-in-Excel-Step-1.jpg\/v4-460px-Clear-Filters-in-Excel-Step-1.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f9\/Clear-Filters-in-Excel-Step-1.jpg\/v4-728px-Clear-Filters-in-Excel-Step-1.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":544,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Klik ganda nama berkas di komputer Anda.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/19\/Clear-Filters-in-Excel-Step-2.jpg\/v4-460px-Clear-Filters-in-Excel-Step-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/19\/Clear-Filters-in-Excel-Step-2.jpg\/v4-728px-Clear-Filters-in-Excel-Step-2.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Tab lembar kerja berada di bagian bawah lembar yang sedang ditampilkan.
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/ab\/Clear-Filters-in-Excel-Step-3.jpg\/v4-460px-Clear-Filters-in-Excel-Step-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/ab\/Clear-Filters-in-Excel-Step-3.jpg\/v4-728px-Clear-Filters-in-Excel-Step-3.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Di beberapa versi Excel, Anda akan melihat simbol corong kecil di sebelah tanda panah. [1]
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/fa\/Clear-Filters-in-Excel-Step-4.jpg\/v4-460px-Clear-Filters-in-Excel-Step-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fa\/Clear-Filters-in-Excel-Step-4.jpg\/v4-728px-Clear-Filters-in-Excel-Step-4.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Filter akan terhapus dari kolom tersebut.
    Iklan
Metode 2
Metode 2 dari 2:

Menghapus Filter di Seluruh Lembar Kerja

Unduh PDF
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/81\/Clear-Filters-in-Excel-Step-5.jpg\/v4-460px-Clear-Filters-in-Excel-Step-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/81\/Clear-Filters-in-Excel-Step-5.jpg\/v4-728px-Clear-Filters-in-Excel-Step-5.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":544,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Klik ganda nama berkas di komputer.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c9\/Clear-Filters-in-Excel-Step-6.jpg\/v4-460px-Clear-Filters-in-Excel-Step-6.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c9\/Clear-Filters-in-Excel-Step-6.jpg\/v4-728px-Clear-Filters-in-Excel-Step-6.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Tab lembar kerja ada di bagian bawah lembar yang sedang ditampilkan.
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/b4\/Clear-Filters-in-Excel-Step-7.jpg\/v4-460px-Clear-Filters-in-Excel-Step-7.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b4\/Clear-Filters-in-Excel-Step-7.jpg\/v4-728px-Clear-Filters-in-Excel-Step-7.jpg","smallWidth":460,"smallHeight":343,"bigWidth":728,"bigHeight":543,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Pilihan ini berada di bagian atas layar.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/bd\/Clear-Filters-in-Excel-Step-8.jpg\/v4-460px-Clear-Filters-in-Excel-Step-8.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bd\/Clear-Filters-in-Excel-Step-8.jpg\/v4-728px-Clear-Filters-in-Excel-Step-8.jpg","smallWidth":460,"smallHeight":342,"bigWidth":728,"bigHeight":542,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Menu ini ada di tengah toolbar di bagian atas layar. Seluruh filter dalam lembar kerja tersebut akan terhapus.
    Iklan

wikiHow Terkait

Cara
Mengidentifikasi Kabel Positif dan Negatif
Cara
Memperbesar Volume Komputer
Cara
Menemukan Nomor Model Sepatu Nike
Cara
Melakukan Pembagian Bersusun Panjang
Cara
Meniup Balon dengan Permen Karet Bubblegum
Cara
Melacak Permintaan Pertemanan yang Anda Kirimkan di Facebook
Cara
Menggambar Binatang (Untuk Anak Anak)
Cara
Membuat Pasta Gigi Gajah
Cara
Mengatur Feng Shui Kamar Tidur Anda
Cara
Memilih Potongan Rambut yang Sesuai dengan Bentuk Wajah
Cara
Berkomunikasi dengan Kucing Anda
Cara
Menjilid Buku
Cara
Bertinju
Cara
Menyanyi dengan Percaya Diri
Iklan

Referensi

  1. ↑ https://support.office.com/en-us/article/Remove-a-filter-f147ac85-4fd6-4143-b52d-ce153250fed3

Tentang wikiHow ini

Bahasa lain
Halaman ini telah diakses sebanyak 39.856 kali.

Apakah artikel ini membantu Anda?

Iklan