The greater the number of rows and columns in your Google Sheets spreadsheet, the more unwieldy it can become. Freezing or hiding rows and columns can make your spreadsheet easier to read and navigate. Hereâs how.
Freeze Columns and Rows in Google Sheets
If you freeze columns or rows in Google Sheets, it locks them into place. This is a good option for use with data-heavy spreadsheets, where you can freeze header rows or columns to make it easier to read your data.
In most cases, youâll want to freeze only the first row or column, but you can freeze rows or columns immediately after the first. To begin, select a cell in the column or row youâre looking to freeze and then click View> Freeze from the top menu.
Click â1 Columnâ or â1 Rowâ to freeze the top column A or row 1. Alternatively, click â2 Columnsâ or â2 Rowsâ to freeze the first two columns or rows.
You can also click âUp to Current Columnâ or âUp to Current Rowâ to freeze the columns or rows up to your selected cell.
When you move around your spreadsheet, your frozen cells will remain in place for you to easily refer back to.
A thicker, gray cell border will appear next to a frozen column or row to make the border between your frozen and unfrozen cells clear.
If you want to remove frozen columns or rows, click View> Frozen and select âNo Rowsâ or âNo Columnsâ to return these cells to normal.
Hide Columns and Rows in Google Sheets
If you want to temporarily hide certain rows or columns, but donât want to remove them from your Google Sheets spreadsheet completely, you can hide them instead.
Hide Google Sheets Columns
To hide a column, right-click the column header for your chosen column. In the menu that appears, click the âHide Columnâ button.
Your column will then disappear from view, with arrows appearing in the column headers on either side of your hidden column.
Clicking on these arrows will expose the column and return it to normal. Alternatively, you can use keyboard shortcuts in Google Sheets to hide your column instead.
Click the column header to select it and then press Ctrl+Alt+0 on your keyboard to hide it instead. Selecting the columns on either side of your hidden row and then pressing Ctrl+Shift+0 on your keyboard will unhide your column afterward.
Hide Google Sheets Rows
Similar to the process above, if you want to hide a row in Google Sheets, right-click on the row header for the row youâre looking to hide.
In the menu that appears, click the âHide Rowâ button.
Your selected row will disappear, with opposite arrows appearing in the header rows on either side.
Click on these arrows to display your hidden row and return it to normal at any point.
If youâd prefer to use a keyboard shortcut, click the row header to select it and then press Ctrl+Alt+9 to hide the row instead. Select the rows on either side of your hidden row and press Ctrl+Shift+9 on your keyboard to unhide it afterward.