Google Sheets have a great number of columns and rows and it can become unmanageable for the user. The best solution to this situation is lowering the number of rows and columns in the Spreadsheet. This could be done by hiding rows or columns.
Also, learn how to add Rows & Columns in Google Sheets
In this guide, you will be able to learn how to hide rows and columns in Google Spreadsheet.
Hiding rows in Google Spreadsheet
Sometimes, it becomes really difficult for the user to manage the huge amount of data in spreadsheets. Therefore, if you want to hide certain rows that are currently not in use in your google spreadsheet, you can temporarily hide them. As the data in the row won’t be deleted permanently, you can archive it later when prerequisite. Learn how to hide rows in Google Spreadsheet by following the steps mentioned below:
- Launch Google Chrome and open Google Spreadsheet in which you want to hide a row in.
- Now click on the row header that you want to hide and right-click. A menu will appear with a number of options in it.
- Select “Hide Row” from the menu.
The row that you wanted would be hidden. You will find two opposite arrows appeared in the header row, click on these arrows to archive the hidden row anytime it is required.
Learn how to Generate Random Numbers in Google Sheets
Hiding Columns in Google Spreadsheet
Here’s how you can hide Columns in Google Spreadsheet:
- Launch Google Chrome and open Google Spreadsheet in which you want to hide a row in.
- Now click on the row header that you want to hide and right-click. A menu will appear with a number of options in it.
- Select “Hide Column” from the menu.
Two opposite arrows will appear in the column header, click on these arrows to un-hide the column when required.
Related: How to Save Microsoft Word Document in “This PC” by Default