You can freeze, group, hide, or merge your spreadsheet’s columns, rows, or cells.
Freeze, group, hide, or merge rows & columns
To pin data in the same place and see it when you scroll, you can freeze rows or columns.
- On your computer, open a spreadsheet in Google Sheets.
- Select a row or column you want to freeze or unfreeze.
- At the top, click View Freeze.
- Select how many rows or columns to freeze.
To unfreeze, select a row or column. Then, at the top, click View Freeze No rows or No columns.
You can organize and summarize related data by grouping rows and columns.
- On your computer, open a spreadsheet in Google Sheets
- Select the rows or columns you want to group or ungroup.
- At the top, click View Group and choose:
- Group rows
- Group columns
- Ungroup rows
- Ungroup columns
To expand or collapse grouped rows or columns, next to the rows or columns, click Plus (+) or Minus (-).
- On your computer, open a spreadsheet in Google Sheets.
- Click a row or column to highlight it.
- To highlight multiple rows or columns, press and hold the command key on your keyboard and click the rows or columns you want to highlight.
- Right-click and select Hide row or Hide column from the menu that appears. An arrow will appear over the hidden row or column.
To show a row or column again, click the arrow where the row number or column letter used to be.
- On your computer, open a spreadsheet in Google Sheets.
- Select the rows, columns, or cells to merge.
- At the top, click Format Merge cells, then select how you want your cells to be merged.