Cara Mengunci Sel di Excel

Unduh PDF
Unduh PDF

Mengunci sel dalam spreadsheet (lembar kerja) Excel berfungsi untuk mencegah perubahan apa pun pada data atau formula dalam suatu sel. Sel yang terkunci dan dilindungi dapat dibuka setiap saat oleh pengguna yang awalnya menguncinya. Ikuti langkah-langkah di bawah ini untuk belajar cara mengunci dan melindungi sel dalam Microsoft Excel versi 2010, 2007, dan 2003.

Metode 1
Metode 1 dari 2:

Excel 2007 dan Excel 2010

Unduh PDF
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/02\/Lock-Cells-in-Excel-Step-1-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-1-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/02\/Lock-Cells-in-Excel-Step-1-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-1-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/e1\/Lock-Cells-in-Excel-Step-2-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-2-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e1\/Lock-Cells-in-Excel-Step-2-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-2-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/87\/Lock-Cells-in-Excel-Step-3-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-3-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/87\/Lock-Cells-in-Excel-Step-3-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-3-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/82\/Lock-Cells-in-Excel-Step-4-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-4-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/82\/Lock-Cells-in-Excel-Step-4-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-4-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/47\/Lock-Cells-in-Excel-Step-5-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-5-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/47\/Lock-Cells-in-Excel-Step-5-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-5-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/70\/Lock-Cells-in-Excel-Step-6-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-6-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/70\/Lock-Cells-in-Excel-Step-6-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-6-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/9a\/Lock-Cells-in-Excel-Step-7-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-7-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9a\/Lock-Cells-in-Excel-Step-7-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-7-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/48\/Lock-Cells-in-Excel-Step-8-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-8-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/48\/Lock-Cells-in-Excel-Step-8-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-8-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/35\/Lock-Cells-in-Excel-Step-9-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-9-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/35\/Lock-Cells-in-Excel-Step-9-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-9-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  10. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/d5\/Lock-Cells-in-Excel-Step-10-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-10-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d5\/Lock-Cells-in-Excel-Step-10-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-10-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  11. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/3f\/Lock-Cells-in-Excel-Step-11-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-11-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3f\/Lock-Cells-in-Excel-Step-11-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-11-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  12. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/a4\/Lock-Cells-in-Excel-Step-12-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-12-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a4\/Lock-Cells-in-Excel-Step-12-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-12-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  13. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/05\/Lock-Cells-in-Excel-Step-13-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-13-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/05\/Lock-Cells-in-Excel-Step-13-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-13-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Sel-sel yang dipilih kini akan terkunci dan dilindungi, dan hanya dapat dibuka dengan memilih sel tersebut sekali lagi, lalu memasukkan kata sandi yang dipilih.
    Iklan
Metode 2
Metode 2 dari 2:

Excel 2003

Unduh PDF
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/4a\/Lock-Cells-in-Excel-Step-14-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-14-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4a\/Lock-Cells-in-Excel-Step-14-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-14-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/eb\/Lock-Cells-in-Excel-Step-15-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-15-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/eb\/Lock-Cells-in-Excel-Step-15-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-15-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/d2\/Lock-Cells-in-Excel-Step-16-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-16-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d2\/Lock-Cells-in-Excel-Step-16-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-16-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c9\/Lock-Cells-in-Excel-Step-17-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-17-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c9\/Lock-Cells-in-Excel-Step-17-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-17-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/da\/Lock-Cells-in-Excel-Step-18-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-18-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/da\/Lock-Cells-in-Excel-Step-18-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-18-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/50\/Lock-Cells-in-Excel-Step-19-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-19-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/50\/Lock-Cells-in-Excel-Step-19-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-19-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/42\/Lock-Cells-in-Excel-Step-20-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-20-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/42\/Lock-Cells-in-Excel-Step-20-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-20-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/91\/Lock-Cells-in-Excel-Step-21-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-21-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/91\/Lock-Cells-in-Excel-Step-21-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-21-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/33\/Lock-Cells-in-Excel-Step-22-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-22-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/33\/Lock-Cells-in-Excel-Step-22-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-22-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  10. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/84\/Lock-Cells-in-Excel-Step-23-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-23-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/84\/Lock-Cells-in-Excel-Step-23-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-23-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  11. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/40\/Lock-Cells-in-Excel-Step-24-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-24-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/40\/Lock-Cells-in-Excel-Step-24-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-24-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  12. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/88\/Lock-Cells-in-Excel-Step-25-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-25-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/88\/Lock-Cells-in-Excel-Step-25-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-25-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  13. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/ae\/Lock-Cells-in-Excel-Step-26-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-26-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/ae\/Lock-Cells-in-Excel-Step-26-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-26-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Semua sel yang dipilih kini akan terkunci dan dilindungi, dan hanya dapat dibuka nantinya dengan memilih sel yang terkunci, dan memasukkan kata sandi yang awalnya telah Anda atur.
    Iklan


Tips

  • Jika beberapa pengguna memiliki akses ke dokumen Excel, kunci semua sel yang berisi data penting atau formula kompleks untuk mencegah sel-sel tak sengaja berubah.
  • Jika sebagian besar sel dalam dokumen Excel Anda berisi data berharga atau formula yang kompleks, sebaiknya kunci atau lindungi seluruh dokumen, lalu buka beberapa sel yang boleh diubah.
Iklan

wikiHow Terkait

Cara
Menambah Tanda Centang ke Dokumen Word
Cara
Membuka Proteksi Lembar Kerja Excel
Cara
Membuat Teks Rata Tengah di Microsoft Word
Cara
Menghapus Halaman Kosong di Word
Cara
Mengubah Koma Menjadi Titik pada Microsoft Excel
Cara
Menampilkan Baris Tersembunyi di Excel
Cara
Menyisipkan Gambar di Excel yang Bisa Menyesuaikan Ukuran Sel secara Otomatis
Cara
Mengubah Huruf Kecil Menjadi Huruf Besar di Excel
Cara
Mengubah Dokumen Hasil Scan Ke File Microsoft Word
Cara
Menampilkan Kembali Kolom Tersembunyi di Excel
Cara
Menghilangkan Status 'Read Only' pada Dokumen MS Word
Cara
Menambahkan Nomor Halaman di Microsoft Word
Cara
Membuat Simbol X Garis Atas di Microsoft Word
Cara
Membulatkan Angka di Excel
Iklan

Referensi

  1. http://answers.vt.edu/kb/entry/1913/
  2. http://www.dummies.com/how-to/content/how-to-protect-cell-data-in-excel-2010.html

Tentang wikiHow ini

Bahasa lain
Halaman ini telah diakses sebanyak 90.705 kali.

Apakah artikel ini membantu Anda?

Iklan