Loncat ke daftar isi utama

Bagaimana cara menonaktifkan klik dua kali pada batas sel di Excel?

Biasanya, kami mengklik dua kali pada sel untuk mengedit konten sel, namun, kursor melompat ke bawah data lembar kerja karena Anda dapat mengklik batas sel secara tidak sengaja seperti gambar berikut yang ditampilkan. Ini mungkin mengganggu jika ada beberapa baris, Anda harus menggulir ke atas ke sel yang diklik. Artikel ini, saya akan berbicara tentang cara menonaktifkan klik dua kali pada batas sel di Excel.

doc nonaktifkan klik dua kali 1

Nonaktifkan klik dua kali pada batas sel untuk melompat ke bawah

panah gelembung kanan biru Nonaktifkan klik dua kali pada batas sel untuk melompat ke bawah

Untuk menonaktifkan klik dua kali pada fitur batas sel, Anda dapat pergi ke Opsi Excel untuk mengkonfigurasi opsi, lakukan seperti ini:

1. Klik File > Opsi untuk pergi ke Opsi Excel kotak dialog.

2. di Opsi Excel kotak dialog, klik Advanced opsi dari panel kiri, lalu hapus centang file Aktifkan gagang isian dan seret-dan-lepas sel pilihan di bawah Mengedit pilihan, lihat tangkapan layar:

doc nonaktifkan klik dua kali 2

3. Lalu klik OK untuk menutup kotak dialog ini, dan sekarang, klik dua kali pada fitur batas sel dinonaktifkan sekaligus.

Alat Produktivitas Kantor Terbaik

Fitur Populer: Temukan, Sorot, atau Identifikasi Duplikat   |  Hapus Baris Kosong   |  Gabungkan Kolom atau Sel tanpa Kehilangan Data   |   Putaran tanpa Formula ...
Pencarian Super: VLookup Beberapa Kriteria  |   VLookup Nilai Berganda  |   VLookup di Beberapa Lembar   |   Pencarian Fuzzy ....
Daftar Drop-down Lanjutan: Buat Daftar Drop Down dengan Cepat   |  Daftar Drop Down yang Bergantung   |  Multi-pilih Drop Down List ....
Manajer Kolom: Tambahkan Jumlah Kolom Tertentu  |  Pindahkan Kolom  |  Alihkan Status Visibilitas Kolom Tersembunyi  |  Bandingkan Rentang & Kolom ...
Fitur Unggulan: Fokus Kisi   |  Tampilan Desain   |   Bar Formula Besar   |  Manajer Buku Kerja & Lembar   |  Perpustakaan Sumberdaya (Teks otomatis)   |  Pemetik tanggal   |  Gabungkan Lembar Kerja   |  Enkripsi/Dekripsi Sel   |  Kirim Email berdasarkan Daftar   |  Filter Super   |   Filter Khusus (filter tebal/miring/coret...) ...
15 Perangkat Teratas:  12 Teks Tools (Tambahkan Teks, Hapus Karakter, ...)   |   50 + Grafik jenis (Gantt Chart, ...)   |   40+ Praktis Rumus (Hitung usia berdasarkan ulang tahun, ...)   |   19 Insersi Tools (Masukkan Kode QR, Sisipkan Gambar dari Jalur, ...)   |   12 Konversi Tools (Angka ke Kata, Konversi Mata Uang, ...)   |   7 Gabungkan & Pisahkan Tools (Lanjutan Gabungkan Baris, Pisahkan Sel, ...)   |   ... dan banyak lagi

Tingkatkan Keterampilan Excel Anda dengan Kutools for Excel, dan Rasakan Efisiensi yang Belum Pernah Ada Sebelumnya. Kutools for Excel Menawarkan Lebih dari 300 Fitur Canggih untuk Meningkatkan Produktivitas dan Menghemat Waktu.  Klik Di Sini untuk Mendapatkan Fitur yang Paling Anda Butuhkan...

tab kte 201905

Office Tab Menghadirkan antarmuka Tab ke Office, dan Membuat Pekerjaan Anda Lebih Mudah

  • Aktifkan pengeditan dan pembacaan tab di Word, Excel, PowerPoint, Publisher, Access, Visio, dan Project.
  • Buka dan buat banyak dokumen di tab baru di jendela yang sama, bukan di jendela baru.
  • Meningkatkan produktivitas Anda sebesar 50%, dan mengurangi ratusan klik mouse untuk Anda setiap hari!
Comments (22)
Rated 5 out of 5 · 1 ratings
peterthegreate
peterthegreate
This comment was minimized by the moderator on the site
This is why i use LibreOffice whenever possible!

#Linuxforever
Reply
0
0
Rated 5 out of 5
aa
aa
This comment was minimized by the moderator on the site
goooddddddddd
Reply
0
0
wtf
wtf
This comment was minimized by the moderator on the site
This feature was brought to you by a dedicated Microsoft excel developer called Mr. Inconvenience
Reply
0
0
James
James
This comment was minimized by the moderator on the site
I'd like to echo the comments here. I have this problem but I cant use this solution without it stopping me doing very useful things. It should be a simple task to decouple these options so we could turn the individual function off, and it feels like only laziness is stopping MS from fixing it.
Reply
0
0
Ashley
Ashley
This comment was minimized by the moderator on the site
The only solution I know of is using F2 instead of double clicking.
Reply
0
0
MandyZhou
MandyZhou     Ashley
This comment was minimized by the moderator on the site
Hello Ashley,

Thanks for your comment. You are right. When you want to edit in an Excel cell, you can simply press the F2 to edit the cell. But for some users like me, we are used to double-click the cell to edit. Different habits, I guess. Have a nice day.

Sincerely,
Mandy
Reply
Report
0
0
BÁRBARA
BÁRBARA
This comment was minimized by the moderator on the site
MIL GRACIAS ME TENIA ENFERMA ESA PORQUERIA!!!
Reply
0
0
Jim Deveau
Jim Deveau
This comment was minimized by the moderator on the site
The description of the concern is exactly what I want to fix, but the solution they give fixes something else.
Reply
0
0
Congratulations
Congratulations
This comment was minimized by the moderator on the site
Hi Microsoft, It's 2021-11-20 and this problem still exists. To put these two different functions under the same tap is irresponsible. This is very basic things...
Reply
0
0
skyyang
skyyang     Congratulations
This comment was minimized by the moderator on the site
Hello,This is indeed inconvenient for most of users, if you have any other good solution, please comment and share here.Thank you!
Reply
Report
0
0
wtf is this
wtf is this
This comment was minimized by the moderator on the site
wtf is this? why? why do you have to couple a completely useless feature with a super useful one so you can only enable or disable them both at the same time?
Reply
0
0
skyyang
skyyang     wtf is this
This comment was minimized by the moderator on the site
Hello, Yes, as you said, this is very inconvenient for most of users. But, there seems to be no other good solution for dealing with this problem.Thanks for your comment.
Reply
Report
0
0
ben
ben
This comment was minimized by the moderator on the site
Could agree with the other comments, why Microsoft are making there programs worse and worse and worse consistently these days I have no idea. Windows and Office is the only MS software I use now but I think that is going to change very soon.
Reply
0
0
There are no comments posted here yet
Load More
Please leave your comments in English
Guest
Posting as Guest
×
Rate this post:
Reset
0   Characters
Suggested Locations