Skip to Content

Masuk/Daftar

Cara Melakukan Pencarian di Kertas Kerja Google Drive

Buku kerja Google Docs dapat digunakan secara gratis dan mudah. Anda dapat menggunakan buku kerja tersebut untuk mengatur data dalam format tabel. Jika Anda memiliki banyak informasi dalam tabel, mengetahui cara mencari kata kunci atau topik tertentu akan sangat mempermudah pekerjaan Anda.

Metode 1

Metode 1 dari 2:

Melalui Peramban

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/d7\/Search-Within-a-Google-Docs-Spreadsheet-Step-1-Version-3.jpg\/v4-460px-Search-Within-a-Google-Docs-Spreadsheet-Step-1-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d7\/Search-Within-a-Google-Docs-Spreadsheet-Step-1-Version-3.jpg\/v4-728px-Search-Within-a-Google-Docs-Spreadsheet-Step-1-Version-3.jpg","smallWidth":460,"smallHeight":343,"bigWidth":728,"bigHeight":543,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/13\/Search-Within-a-Google-Docs-Spreadsheet-Step-2-Version-3.jpg\/v4-460px-Search-Within-a-Google-Docs-Spreadsheet-Step-2-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/13\/Search-Within-a-Google-Docs-Spreadsheet-Step-2-Version-3.jpg\/v4-728px-Search-Within-a-Google-Docs-Spreadsheet-Step-2-Version-3.jpg","smallWidth":460,"smallHeight":343,"bigWidth":728,"bigHeight":543,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/6e\/Search-Within-a-Google-Docs-Spreadsheet-Step-3-Version-2.jpg\/v4-460px-Search-Within-a-Google-Docs-Spreadsheet-Step-3-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6e\/Search-Within-a-Google-Docs-Spreadsheet-Step-3-Version-2.jpg\/v4-728px-Search-Within-a-Google-Docs-Spreadsheet-Step-3-Version-2.jpg","smallWidth":460,"smallHeight":342,"bigWidth":728,"bigHeight":542,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

3
Bukalah opsi "Find and Replace" dengan mengikuti salah satu cara berikut ini:
- Menu drop-down : Klik tab Edit pada menu drop-down , kemudian geser menu untuk menemukan opsi Find and Replace .
- Anda juga dapat menggunakan pintasan Ctrl+H atau Ctrl+F pada papan tik untuk membuka jendela Find and Replace .
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/53\/Search-Within-a-Google-Docs-Spreadsheet-Step-4-Version-3.jpg\/v4-460px-Search-Within-a-Google-Docs-Spreadsheet-Step-4-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/53\/Search-Within-a-Google-Docs-Spreadsheet-Step-4-Version-3.jpg\/v4-728px-Search-Within-a-Google-Docs-Spreadsheet-Step-4-Version-3.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Jangan isi kotak Replace , kecuali Anda ingin melakukan penggantian data.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/e3\/Search-Within-a-Google-Docs-Spreadsheet-Step-5-Version-3.jpg\/v4-460px-Search-Within-a-Google-Docs-Spreadsheet-Step-5-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e3\/Search-Within-a-Google-Docs-Spreadsheet-Step-5-Version-3.jpg\/v4-728px-Search-Within-a-Google-Docs-Spreadsheet-Step-5-Version-3.jpg","smallWidth":460,"smallHeight":342,"bigWidth":728,"bigHeight":541,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

5
Klik Find . Komputer akan melakukan pencarian data. Jika komputer menemukan kata kunci yang Anda masukkan di buku kerja, entri pertama yang ditemukan akan tampil. Entri tersebut akan ditandai dengan kotak biru di buku kerja.
- Anda dapat mengeklik Find kembali untuk menggeser hasil pencarian. Komputer akan menampilkan hasil pencarian selanjutnya (bila ada). Jika komputer tidak menemukan hasil pencarian lain, Anda akan melihat pesan "No more results, looping around" .
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/fb\/Search-Within-a-Google-Docs-Spreadsheet-Step-6-Version-3.jpg\/v4-460px-Search-Within-a-Google-Docs-Spreadsheet-Step-6-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fb\/Search-Within-a-Google-Docs-Spreadsheet-Step-6-Version-3.jpg\/v4-728px-Search-Within-a-Google-Docs-Spreadsheet-Step-6-Version-3.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":548,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Setelah jendela tertutup, Anda akan dibawa kembali ke buku kerja.

Iklan

Metode 2

Metode 2 dari 2:

Melalui Aplikasi Google Sheets

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/48\/Search-Within-a-Google-Docs-Spreadsheet-Step-7-Version-2.jpg\/v4-460px-Search-Within-a-Google-Docs-Spreadsheet-Step-7-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/48\/Search-Within-a-Google-Docs-Spreadsheet-Step-7-Version-2.jpg\/v4-728px-Search-Within-a-Google-Docs-Spreadsheet-Step-7-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

1
Ketuk ikon dokumen hijau atau berkas di ponsel Anda untuk membuka aplikasi Google Sheets.
- Anda tidak perlu masuk ke Google Sheets, kecuali jika Anda baru pertama kali menggunakan aplikasi.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/91\/Search-Within-a-Google-Docs-Spreadsheet-Step-8-Version-2.jpg\/v4-460px-Search-Within-a-Google-Docs-Spreadsheet-Step-8-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/91\/Search-Within-a-Google-Docs-Spreadsheet-Step-8-Version-2.jpg\/v4-728px-Search-Within-a-Google-Docs-Spreadsheet-Step-8-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Seluruh buku kerja yang dapat Anda akses, baik milik sendiri maupun yang dibagikan dengan Anda, akan tampil di layar aplikasi. Geser layar untuk menemukan buku kerja yang Anda maksud.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/0c\/Search-Within-a-Google-Docs-Spreadsheet-Step-9-Version-2.jpg\/v4-460px-Search-Within-a-Google-Docs-Spreadsheet-Step-9-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/0c\/Search-Within-a-Google-Docs-Spreadsheet-Step-9-Version-2.jpg\/v4-728px-Search-Within-a-Google-Docs-Spreadsheet-Step-9-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Buku kerja akan tampil di layar.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/d4\/Search-Within-a-Google-Docs-Spreadsheet-Step-10-Version-3.jpg\/v4-460px-Search-Within-a-Google-Docs-Spreadsheet-Step-10-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d4\/Search-Within-a-Google-Docs-Spreadsheet-Step-10-Version-3.jpg\/v4-728px-Search-Within-a-Google-Docs-Spreadsheet-Step-10-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Ketuk ikon berbentuk tiga titik vertikal di pojok kanan atas layar untuk membuka menu, kemudian ketuk "Find and Replace" . Kotak pencarian akan tampil di bagian atas buku kerja.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/77\/Search-Within-a-Google-Docs-Spreadsheet-Step-11-Version-2.jpg\/v4-460px-Search-Within-a-Google-Docs-Spreadsheet-Step-11-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/77\/Search-Within-a-Google-Docs-Spreadsheet-Step-11-Version-2.jpg\/v4-728px-Search-Within-a-Google-Docs-Spreadsheet-Step-11-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Setelah selesai, ketuk tombol "Search" pada papan tik untuk memulai pencarian.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/1d\/Search-Within-a-Google-Docs-Spreadsheet-Step-12-Version-2.jpg\/v4-460px-Search-Within-a-Google-Docs-Spreadsheet-Step-12-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1d\/Search-Within-a-Google-Docs-Spreadsheet-Step-12-Version-2.jpg\/v4-728px-Search-Within-a-Google-Docs-Spreadsheet-Step-12-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

6
Lihatlah hasil pencarian. Jika kata kunci yang Anda masukkan ditemukan di buku kerja, kata kunci tersebut akan ditandai, dan Anda akan dibawa ke lokasi kata kunci tersebut.
- Anda akan melihat dua tombol arah di bagian kanan bilah pencarian. Untuk menampilkan hasil pencarian sebelumnya, ketuk tombol atas, dan untuk menampilkan hasil pencarian setelahnya, ketuk tombol bawah. Teruslah mengetuk tombol tersebut hingga Anda menemukan data yang diinginkan.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/01\/Search-Within-a-Google-Docs-Spreadsheet-Step-13-Version-2.jpg\/v4-460px-Search-Within-a-Google-Docs-Spreadsheet-Step-13-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/01\/Search-Within-a-Google-Docs-Spreadsheet-Step-13-Version-2.jpg\/v4-728px-Search-Within-a-Google-Docs-Spreadsheet-Step-13-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Setelah bilah pencarian tertutup, Anda akan dibawa kembali ke buku kerja.

Iklan

Tips

Untuk memperbaiki kesalahan eja atau kata kunci tertentu, Anda dapat menggunakan fungsi "Replace" .

Iklan

Hal yang Anda Butuhkan

Buku kerja Google Docs di Google Drive

wikiHow Terkait

Iklan

Tentang wikiHow ini

wikiHow adalah suatu "wiki", yang berarti ada banyak artikel kami yang disusun oleh lebih dari satu orang. Untuk membuat artikel ini, 10 penyusun, beberapa di antaranya anonim, menyunting dan memperbaiki dari waktu ke waktu. Artikel ini telah dilihat 18.691 kali.

Daftar kategori: Komputer dan Elektronik

Cetak

Halaman ini telah diakses sebanyak 18.691 kali.

Apakah artikel ini membantu Anda?

Iklan

-

-

339

.mwimg a.image{display:none}#header_logo{display:none}#cse-search-box{display:none}#cse-search-box-noscript{display:block !important}#cse-search-box-noscript .cse_q{color:#FFF;background-color:#B3CE9C}.wh_search .cse_q{width:88%}#mw-mf-main-menu-button{display:none;visibility:hidden}.header .search{display:none}#search_footer .cse_sa{background-image:url(/extensions/wikihow/mobile/images/white_mag.png);background-size:22px}.related_box{display:block;background:#EEE;border:5px solid #FFF;vertical-align:bottom;width:127px;background-size:180px;float:left;height:120px;position:relative}.related_box p{line-height:15px !important;font-size:13px;background-color:rgba(67,95,44,.4);color:#FFF;font-weight:bold;padding:8px;margin:0 !important;position:absolute;bottom:0}#noscript_header_logo{display:table-cell;vertical-align:middle;background-position:50% 77%;background-repeat:no-repeat;background-image:url(/extensions/wikihow/mobile/images/wikihow_logo_230.png);background-size:105px;width:auto;height:51px;padding:0 14px}.articleinfo{display:none}#iorg_free_data{z-index:50;width:100%;position:fixed}#ara_recommendations{display:none}

Design a Mobile Website

View Site in Mobile | Classic

Share by: