Hide or show rows or columnsExcel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel 2010 Excel 2007 Excel for Mac 2011 More...Less Show
Hide or unhide columns in your spreadsheet to show just the data that you need to see or print.
Hide columns
Note: The double line between two columns is an indicator that you've hidden a column. Unhide columns
Or double-click the double line between the two columns where hidden columns exist. Need more help?You can always ask an expert in the Excel Tech Community or get support in the Answers community. See AlsoUnhide the first column or row in a worksheet Need more help?Updated on November 8, 2021 What to Know
This article explains how to hide or unhide rows in the desktop version of Google Sheets, which is accessed through a web browser. This instructions do not apply to the Google Sheets mobile app. Spreadsheets can help you examine information in various configurations to consider different possibilities. If you use Google Sheets, hiding rows is one of the features that help you do this. In this example, the salespeople are listed from the longest to the shortest time with the company. We want to see sales figures without those of the two most recent hires, Allison and Mike. Here's how to do it.
How to Unhide Rows in Google SheetsWhen you're done viewing information with some of the rows hidden, it's easy to see them again.
How to Find Hidden Information in Google SheetsAnother way data can be hidden in Google Sheets is with filters. Say your boss shares a Google Sheets file with you and asks you to run an analysis on information that you just can’t find, even by using the search function. In this example, we’re missing the "Tom" row. It's possible this is happening because there's a filter in place. If you see different coloring (usually dark gray) and filter information above the columns, and different coloring in the numbered column to the left of the rows, you're dealing with a filter. To reverse this condition, click the X on the right side of the bar with the filter information. Now you should be able to find your "missing" data with no problem. Tara Moore/Getty ImagesAnother Trick to Try: Freezing Rows in Google Docs Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe 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.. Bagaimana Cara Mengunci Kolom di spreadsheet?Melindungi sheet atau rentang. Buka spreadsheet di Google Spreadsheet.. Klik Data. ... . Klik Tambahkan sheet atau rentang atau klik perlindungan yang ada untuk mengeditnya.. Untuk melindungi rentang, klik Rentang. ... . Klik Setel izin atau Ubah izin.. Pilih cara yang diinginkan untuk membatasi pengeditan: ... . Klik Simpan atau Selesai.. Bagaimana cara wrap text di spreadsheet?Inilah cara wrap text di google sheet yang harus kamu ikuti :. Buka Dokumen Google Sheets yang sudah kamu buat sebelumnya.. Setelah itu klik dan blok area kolom yang berisi teks dan ingin kamu masukan fitur Wrap Text.. Selanjutnya klik pada icon menu Format.. Kemudian cari dan klik Menu Wrap text.. |