Experience all of the benefits of the classic spreadsheet with much more powerful features that save users time! Show
If you don’t want people to change the content in a spreadsheet, you can protect it. This shouldn’t be used as a security measure. People can print, copy, paste, and import and export copies of a protected spreadsheet. Only share spreadsheets with people you trust. Tip: If "Protected sheets and ranges" isn't visible, you're likely in Microsoft Office editing. To use sheets and ranges protection, convert your file to Google Sheets. Learn about Microsoft Office editing and how to convert Microsoft Office files. Protect a range or sheet Important: When you protect a sheet, you can’t:
To see protected cells, click View Protected ranges. A striped background will appear over the cells.Who can protect a range or sheet
Edit a copy of a protected sheet
Remove protection
Hide sheets from viewYou can hide sheets that are old or are placeholders for calculations used by other sheets. Hiding a sheet is not the same as protecting a sheet.
Hide or unhide a sheet To hide a sheet:
To unhide a sheet:
Import and export spreadsheets with hidden sheets Hidden sheets will stay hidden if you:
Edit sheetsTip: You can perform bulk actions on multiple tabs in a Sheet, such as:
For bulk actions, on your keyboard press Shift, select the tabs click the action you want to perform.Copy a sheet You can copy a sheet in a spreadsheet. Copies can be made within the same spreadsheet or into a separate spreadsheet. To copy a sheet to another spreadsheet:
To copy a sheet within a spreadsheet:
Reorder sheets To change the order of the sheets in a spreadsheet, click and drag a sheet tab until it is in the order you want. Rename a sheet To change the name of a sheet in a spreadsheet, double-click the text on the sheet tab and type in the new name. Bagaimana cara hide kolom di Google sheet?Memisahkan kolom. Di komputer, buka spreadsheet di Google Spreadsheet.. Klik baris atau kolom untuk menandainya. ... . Klik kanan dan pilih Sembunyikan baris atau Sembunyikan kolom dari menu yang muncul.. 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.
|