Cara Memasukkan Data ke Tabel Pivot

Disusun bersama Staf wikiHow

Artikel ini akan memandu Anda untuk memasukkan data ke tabel pivot di Microsoft Excel. Panduan ini dapat diikuti di Microsoft Excel versi Windows dan Mac.

Langkah

Unduh PDF

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/5c\/Add-Data-to-a-Pivot-Table-Step-1-Version-2.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-1-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/5c\/Add-Data-to-a-Pivot-Table-Step-1-Version-2.jpg\/v4-728px-Add-Data-to-a-Pivot-Table-Step-1-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Dokumen tersebut akan terbuka.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/bd\/Add-Data-to-a-Pivot-Table-Step-2-Version-3.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-2-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bd\/Add-Data-to-a-Pivot-Table-Step-2-Version-3.jpg\/v4-728px-Add-Data-to-a-Pivot-Table-Step-2-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/a0\/Add-Data-to-a-Pivot-Table-Step-3-Version-3.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-3-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a0\/Add-Data-to-a-Pivot-Table-Step-3-Version-3.jpg\/v4-728px-Add-Data-to-a-Pivot-Table-Step-3-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

3
Tambahkan atau ubah data yang ingin dimasukkan ke tabel pivot di sebelah atau bawah data yang sudah ada.
- Misalnya, jika Anda sudah memiliki data di sel A1 hngga E10, Anda dapat memasukkan data di kolom F atau di baris ke-11.
- Jika Anda hanya ingin mengubah data yang tampil di tabel pivot, ubah data tersebut di kertas kerja aktif.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/9d\/Add-Data-to-a-Pivot-Table-Step-4-Version-3.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-4-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9d\/Add-Data-to-a-Pivot-Table-Step-4-Version-3.jpg\/v4-728px-Add-Data-to-a-Pivot-Table-Step-4-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/2a\/Add-Data-to-a-Pivot-Table-Step-5-Version-2.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-5-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2a\/Add-Data-to-a-Pivot-Table-Step-5-Version-2.jpg\/v4-728px-Add-Data-to-a-Pivot-Table-Step-5-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/98\/Add-Data-to-a-Pivot-Table-Step-6-Version-3.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-6-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/98\/Add-Data-to-a-Pivot-Table-Step-6-Version-3.jpg\/v4-728px-Add-Data-to-a-Pivot-Table-Step-6-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

6
Klik tombol Analyze di bagian tengah pita hijau pada jendela Excel. Anda akan melihat bilah alat baru di bawah pita tersebut.
- Jika Anda menggunakan Mac, klik tab PivotTable Analyze .
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/9e\/Add-Data-to-a-Pivot-Table-Step-7-Version-3.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-7-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9e\/Add-Data-to-a-Pivot-Table-Step-7-Version-3.jpg\/v4-728px-Add-Data-to-a-Pivot-Table-Step-7-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Anda akan melihat menu drop-down .
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/d1\/Add-Data-to-a-Pivot-Table-Step-8.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-8.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d1\/Add-Data-to-a-Pivot-Table-Step-8.jpg\/v4-728px-Add-Data-to-a-Pivot-Table-Step-8.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Jendela baru akan terbuka.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c4\/Add-Data-to-a-Pivot-Table-Step-9.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-9.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c4\/Add-Data-to-a-Pivot-Table-Step-9.jpg\/v4-728px-Add-Data-to-a-Pivot-Table-Step-9.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Klik dan tarik kursor dari sel kiri atas hingga kiri bawah. Sel berisi data yang telah Anda masukkan akan ikut terpilih.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/eb\/Add-Data-to-a-Pivot-Table-Step-10.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-10.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/eb\/Add-Data-to-a-Pivot-Table-Step-10.jpg\/v4-728px-Add-Data-to-a-Pivot-Table-Step-10.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/d3\/Add-Data-to-a-Pivot-Table-Step-11.jpg\/v4-460px-Add-Data-to-a-Pivot-Table-Step-11.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d3\/Add-Data-to-a-Pivot-Table-Step-11.jpg\/v4-728px-Add-Data-to-a-Pivot-Table-Step-11.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

11
Pada bagian "Data" di bilah alat, klik Refresh .
- Jika Anda menambahkan kolom baru pada tabel pivot, centang kotak cek di sebelah kanan jendela Excel untuk menampilkannya.
Iklan

Tips

Simpanlah tabel pivot sebelum melakukan perubahan agar Anda dapat memulihkan tabel jika terjadi kesalahan.

Masuk

Cara Memasukkan Data ke Tabel Pivot

Langkah

Tips

wikiHow Terkait

Tentang wikiHow ini

Apakah artikel ini membantu Anda?

Artikel Terkait

Ikuti kami

Bagikan

Explore Categories