Cara menggunakan google sheets gridlines darker
KOMPAS.com - Perkembangan teknologi semakin memudahkan proses aktivitas manusia. Beragam jenis pekerjaan kantor dan tugas sekolah tak lagi harus dikerjakan di hadapan komputer. Show
Sebagian kegiatan tersebut dapat dikerjakan di smartphone menggunakan aplikasi besutan Google, yang terdiri dari Google Docs, Sheet, dan Slides. Ketiganya dapat digunakan secara gratis via peramban web atau aplikasi di Android dan iOS. Untuk menambah kenyamanan penggunanya, Google turut menghadirkan mode mode gelap (dark mode) pada aplikasi Docs, Sheets, dan Slides. Mode ini bisa diaktifkan bagi pengguna yang ingin mengurangi ketegangan mata di lingkungan yang rendah cahaya. By default, Gridlines are already applied to all the cells in Google Sheets. But sometimes, you may only want to have these gridlines (or borders) on some specific cells or rows/columns and not everywhere. In this tutorial, I will show you how to hide gridlines in Google Sheets and how to make them appear while printing. Table of Contents Hide the Gridlines in Google SheetsBelow are the steps to hide gridlines from the entire worksheet in Google Sheets:
Gridlines option in the View tab is a toggle option. This means that if you want the Gridlines to come back again, you need to go back to this option and click on it. Also, note that when you show or hide gridlines in Google Sheets, it’s only applied to the sheet that is active. If you want this to be applied to all the worksheets, you will have to go to each sheet and hide the gridlines manually. In case you want to show gridlines only in a specific range and not in the entire worksheet, first remove the gridlines using the steps above, and then apply the border to the selected range of cells using the below steps:
Show/Hide Gridlines While PrintingWhen you have gridlines in the worksheet in Google Sheets, and you print that worksheet (or a part of that worksheet), you’ll notice that it also prints the gridlines. If you don’t want the gridlines to be printed, you have an option to disable it. Below are the steps to print a range in Google Sheets while hiding the gridlines:
The above steps would hide the gridlines from the selected range of cells. If you want to show the gridlines, make sure this option is checked. However, in case you have applied a border to the range of cells you want to print, you can’t remove it from the Print screen. If you don’t want the border to be printed, you need to go back to the worksheet and remove it. You may also like the following Google Sheets tutorials:
Most Popular Posts5 Simple Ways to Highlight Duplicates in Google SheetsIF CONTAINS Google Sheets Formulas [2 Clever Options]How to Apply Formula to Entire Column in Google SheetsHow to VLOOKUP From Another Sheet in Google SheetsSumitSumit is a Google Sheets and Microsoft Excel Expert. He provides spreadsheet training to corporates and has been awarded the prestigious Excel MVP award by Microsoft for his contributions in sharing his Excel knowledge and helping people. Bagaimana cara edit Google sheet?Mengedit data dalam sel. Buka spreadsheet di aplikasi Google Spreadsheet.. Di spreadsheet, ketuk dua kali sel yang ingin diedit.. Masukkan data Anda.. Opsional: Untuk memformat teks, sentuh lama teks, lalu pilih salah satu opsi.. Setelah selesai, ketuk Selesai .. Bagaimana cara menghilangkan garis di Google Spreadsheet?Pada ponsel atau tablet Android Anda, buka spreadsheet di aplikasi Google Spreadsheet.. Sentuh lama baris atau kolom yang ingin dihapus.. Di menu yang muncul, ketuk Hapus.. Mengapa kita harus menggunakan Gsheet?Google Sheets memiliki fungsi sama dengan Microsoft Excel yang mana dapat digunakan untuk mengolah data, mengurutkan data, serta memanipulasi data dalam bentuk tabel. Dalam perusahaan, Google Sheets dapat digunakan untuk mengolah data seperti laporan penjualan, laporan keuangan, laporan piutang, dan sejenisnya.
|