Hiding Rows and Columns in Google Sheets

In this post I described how to freeze rows or columns in a Google Sheets spreadsheet. Sometimes, though, it’s more useful to be able to hide certain rows or columns from view altogether. You can hide both rows and columns in your Google Sheets spreadsheets.

To hide a row, right-click the row number, highlighting the whole row, and select Hide row from the menu that appears.

Click image to enlarge

Click image to enlarge

An icon will be visible over the hidden row. To unhide a row, click the icon and the row reappears.

Click image to enlarge

Click image to enlarge

To hide a column, right-click the column’s letter, highlighting the whole column. and select Hide column from the menu. Again an icon appears, showing the letter of the column that’s been hidden.

To hide multiple, adjacent rows or columns all at once, first (left-)click the row number/column letter of the first row/column you want to hide (which highlights the row/column), then hold down the Shift key and (left-)click the last row number/column letter of those you want hidden (which now highlights all rows or columns in the range). Alternatively, click and hold the mouse button on the first number/letter required and drag across to include the last row/column before releasing the button.

Right-click inside the highlighted range, and select Hide rows from the menu.

Click image to enlarge

Click image to enlarge

A little trick to unhide several hidden rows/columns at once is to highlight a larger range that encompasses the hidden rows/columns, then select Unhide rows/columns. For example, if you have rows 7 and 11 hidden, you can highlight rows 6 through 12, right-click anywhere in that range and select Unhide rows. All hidden rows in the range will be unhidden. The same process works for columns, of course.