The Google Sheets logo

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.

To freeze rows or columns in Google Sheets, click View > Freeze

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.

An example of frozen columns and rows in Google Sheets

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.

To unfreeze a column or row in Google Sheets, click View > Freeze then click No Rows or No Columns

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.

Right click a column header, then click Hide Column to hide that column in Google Sheets

Your column will then disappear from view, with arrows appearing in the column headers on either side of your hidden column.

Click the opposite arrows to display a hidden column in Google Sheets

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.

RELATED: All the Best Google Sheets Keyboard Shortcuts

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.

To hide a Google Sheets row, right-click the row header, then click Hide Row

Your selected row will disappear, with opposite arrows appearing in the header rows on either side.

Click the opposite arrows to display a hidden row in Google Sheets

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.

Ben Stockton Ben Stockton
Ben Stockton is a freelance tech writer from the United Kingdom. In a past life, he was a UK college lecturer, training teens and adults. Since leaving the classroom, he's been a tech writer, writing how-to articles and tutorials for MakeUseOf, MakeTechEasier, and Cloudwards.net. He has a degree in History and a postgraduate qualification in Computing.
Read Full Bio »