Freeze, group, hide, or merge rows & columns

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.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select a row or column you want to freeze or unfreeze.
  3. At the top, click View  and then Freeze.
  4. Select how many rows or columns to freeze.

To unfreeze, select a row or column. Then, at the top, click View  and then Freeze  and then No rows or No columns.

Group or ungroup rows or columns

You can organize and summarize related data by grouping rows and columns.

  1. On your computer, open a spreadsheet in Google Sheets
  2. Select the rows or columns you want to group or ungroup.
  3. At the top, click View and then 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 (-).

Hide rows or columns
  1. On your computer, open a spreadsheet in Google Sheets.
  2. 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.
  3. 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.

Merge rows or columns
  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select the rows, columns, or cells to merge.
  3. At the top, click Format  and then Merge cells, then select how you want your cells to be merged.

Related articles

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
9221319247659286286
true
Search Help Center
true
true
true
true
true
35
false
false