Cara Membuat Lembar Lajur Bersama

Lembar lajur merupakan berkas penting di dunia perkantoran. Berkas ini digunakan untuk mengelola data dan membuat laporan. Mungkin Anda perlu membagikan lembar lajur laporan kepada tim atau manajer, baik melalui program pengelola lembar lajur berbasis internet maupun Microsoft Excel. Untungnya, sebagian besar program memiliki fitur bawaan yang memungkinkan Anda untuk membuat lembar lajur agar bisa digunakan oleh banyak orang, selama Anda menggunakan server bersama atau koneksi internet. Artikel ini akan mengajarkan kepada Anda cara membuat lembar lajur bersama pada Google Docs dan Microsoft Excel.

Metode 1

Metode 1 dari 2:

Membuat Lembar Lajur Melalui Microsoft Excel

Unduh PDF

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/8d\/Make-a-Shared-Spreadsheet-Step-1-Version-3.jpg\/v4-460px-Make-a-Shared-Spreadsheet-Step-1-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/8d\/Make-a-Shared-Spreadsheet-Step-1-Version-3.jpg\/v4-728px-Make-a-Shared-Spreadsheet-Step-1-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Buka lembar lajur yang sudah ada, atau buat dokumen baru dengan mengakses menu “ File ” pada bilah peralatan horizontal di atas jendela program dan memilih " New ".
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/bd\/Make-a-Shared-Spreadsheet-Step-2-Version-3.jpg\/v4-460px-Make-a-Shared-Spreadsheet-Step-2-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/bd\/Make-a-Shared-Spreadsheet-Step-2-Version-3.jpg\/v4-728px-Make-a-Shared-Spreadsheet-Step-2-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Perubahan ini mencakup makro, bagan, kotak yang digabungkan, gambar, objek, pranala, garis luar, subtotal, tabel data, laporan tabel pivot, proteksi lembar kerja, dan format bersyarat ( conditional format ).
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/a7\/Make-a-Shared-Spreadsheet-Step-3-Version-3.jpg\/v4-460px-Make-a-Shared-Spreadsheet-Step-3-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a7\/Make-a-Shared-Spreadsheet-Step-3-Version-3.jpg\/v4-728px-Make-a-Shared-Spreadsheet-Step-3-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Pilih " Shared Spreadsheet/Share Workbook " dari daftar opsi di menu drop-down .
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/ad\/Make-a-Shared-Spreadsheet-Step-4-Version-3.jpg\/v4-460px-Make-a-Shared-Spreadsheet-Step-4-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/ad\/Make-a-Shared-Spreadsheet-Step-4-Version-3.jpg\/v4-728px-Make-a-Shared-Spreadsheet-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\/6\/63\/Make-a-Shared-Spreadsheet-Step-5-Version-3.jpg\/v4-460px-Make-a-Shared-Spreadsheet-Step-5-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/63\/Make-a-Shared-Spreadsheet-Step-5-Version-3.jpg\/v4-728px-Make-a-Shared-Spreadsheet-Step-5-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Klik kotak untuk menetapkan perubahan.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/38\/Make-a-Shared-Spreadsheet-Step-6-Version-3.jpg\/v4-460px-Make-a-Shared-Spreadsheet-Step-6-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/38\/Make-a-Shared-Spreadsheet-Step-6-Version-3.jpg\/v4-728px-Make-a-Shared-Spreadsheet-Step-6-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\/0\/0e\/Make-a-Shared-Spreadsheet-Step-7-Version-3.jpg\/v4-460px-Make-a-Shared-Spreadsheet-Step-7-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/0e\/Make-a-Shared-Spreadsheet-Step-7-Version-3.jpg\/v4-728px-Make-a-Shared-Spreadsheet-Step-7-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\/a4\/Make-a-Shared-Spreadsheet-Step-8-Version-3.jpg\/v4-460px-Make-a-Shared-Spreadsheet-Step-8-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a4\/Make-a-Shared-Spreadsheet-Step-8-Version-3.jpg\/v4-728px-Make-a-Shared-Spreadsheet-Step-8-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\/6\/69\/Make-a-Shared-Spreadsheet-Step-9-Version-3.jpg\/v4-460px-Make-a-Shared-Spreadsheet-Step-9-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/69\/Make-a-Shared-Spreadsheet-Step-9-Version-3.jpg\/v4-728px-Make-a-Shared-Spreadsheet-Step-9-Version-3.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Pastikan semua orang yang akan menggunakan dokumen sudah memiliki izin untuk mengakses folder. Jika tidak, simpan berkas di direktori yang dapat diakses oleh semua orang.

Iklan

Metode 2

Metode 2 dari 2:

Membuat Lembar Lajur Melalui Google Docs

Unduh PDF

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/e4\/Make-a-Shared-Spreadsheet-Step-10-Version-3.jpg\/v4-460px-Make-a-Shared-Spreadsheet-Step-10-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e4\/Make-a-Shared-Spreadsheet-Step-10-Version-3.jpg\/v4-728px-Make-a-Shared-Spreadsheet-Step-10-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

1
Masuk ke akun Google Documents.
- Jika belum memiliki akun Google Docs, buat terlebih dahulu dengan mengeklik tombol " Try Google Docs Now " pada halaman log masuk Google.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/32\/Make-a-Shared-Spreadsheet-Step-11-Version-3.jpg\/v4-460px-Make-a-Shared-Spreadsheet-Step-11-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/32\/Make-a-Shared-Spreadsheet-Step-11-Version-3.jpg\/v4-728px-Make-a-Shared-Spreadsheet-Step-11-Version-3.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/87\/Make-a-Shared-Spreadsheet-Step-12-Version-3.jpg\/v4-460px-Make-a-Shared-Spreadsheet-Step-12-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/87\/Make-a-Shared-Spreadsheet-Step-12-Version-3.jpg\/v4-728px-Make-a-Shared-Spreadsheet-Step-12-Version-3.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/47\/Make-a-Shared-Spreadsheet-Step-13-Version-3.jpg\/v4-460px-Make-a-Shared-Spreadsheet-Step-13-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/47\/Make-a-Shared-Spreadsheet-Step-13-Version-3.jpg\/v4-728px-Make-a-Shared-Spreadsheet-Step-13-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\/e\/e2\/Make-a-Shared-Spreadsheet-Step-14-Version-3.jpg\/v4-460px-Make-a-Shared-Spreadsheet-Step-14-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e2\/Make-a-Shared-Spreadsheet-Step-14-Version-3.jpg\/v4-728px-Make-a-Shared-Spreadsheet-Step-14-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\/e\/e4\/Make-a-Shared-Spreadsheet-Step-15-Version-3.jpg\/v4-460px-Make-a-Shared-Spreadsheet-Step-15-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e4\/Make-a-Shared-Spreadsheet-Step-15-Version-3.jpg\/v4-728px-Make-a-Shared-Spreadsheet-Step-15-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Klik kotak drop-down di samping kanan nama pengguna.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/50\/Make-a-Shared-Spreadsheet-Step-16-Version-3.jpg\/v4-460px-Make-a-Shared-Spreadsheet-Step-16-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/50\/Make-a-Shared-Spreadsheet-Step-16-Version-3.jpg\/v4-728px-Make-a-Shared-Spreadsheet-Step-16-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Iklan

Tips

Saat membagikan lembar lajur melalui Google Docs, pengguna lain harus memiliki atau membuat akun Google terlebih dahulu.
Ketika menyimpan dokumen Excel di folder bersama, periksa tautan ke buku kerja lain untuk memastikan tautan tidak sampai mati saat berkas disimpan ke lokasi baru.

Hal yang Anda Butuhkan

Folder bersama
Jaringan bersama
Akun Google

Masuk

Cara Membuat Lembar Lajur Bersama

Langkah

Membuat Lembar Lajur Melalui Microsoft Excel

Membuat Lembar Lajur Melalui Google Docs

Tips

Hal yang Anda Butuhkan

wikiHow Terkait

Referensi

Tentang wikiHow ini

Apakah artikel ini membantu Anda?

Artikel Terkait

Ikuti kami

Bagikan

Explore Categories