How to Hide Columns in Google Sheets

How to Hide Rows and Columns in Google Sheets

How to Hide Columns in Google Sheets

You can hide rows and columns in a worksheet from view. Data isn't deleted, but simply hidden until it is unhidden again, which can help you narrow your focus to only on the data needed at the given time.

Hide a Row or Column

You can hide rows and columns in a spreadsheet in order to cut down on visual clutter.

  1. Right-click a row or column header.
  2. Select Hide row or Hide column.
    Hide Rows and Columns

The column is hidden from view. Nothing is deleted, and its values can still be referenced by formulas, but it won't appear on the spreadsheet.

Unhide a Row or Column

When a row or column is hidden, a button with two arrows will appear on the border between the adjacent row or column headers.

  1. Click the (arrows) button between two row or column headers.
    Hide Rows and Columns

The data reappears once again.

You can also select multiple row or column headers that contain hidden data, then right-click and select Unhide rows or Unhide columns.

FREE Quick Reference

Click to Download