Edit rows, columns & cells in a spreadsheet
You can add, delete, group, freeze, move, or hide rows and columns in a spreadsheet in Google Sheets.
Add rows, columns, or cells
- On your computer, open a spreadsheet in Google Sheets.
- Select a row, column, or cell.
- Right-click the row, column, or cell.
- From the menu that appears, select Insert row, Insert column, or Insert cells.
- On your computer, open a spreadsheet in Google Sheets.
- Highlight the number of rows, columns, or cells you want to insert.
- Right-click the rows, columns, or cells.
- From the menu that appears, select Insert [Number] or Insert cells. For example, if you highlight 5 rows, right-click the row header, and select Insert 5 above or Insert 5 below.
To add 100+ rows to your spreadsheet:
- On your spreadsheet, scroll to the bottom.
- Next to "more rows at the bottom," enter the number of rows you’d like to add.
- Click Add.
Change or move rows or columns
- On your computer, open a spreadsheet in Google Sheets.
- Select a row or column to resize. You can also highlight multiple rows, columns, or cells.
- Right-click the row number or column letter, then select Row height
Custom or Resize column.
- In the window that appears, enter a new height or width.
- Click Ok.
You can also click and drag the edge of a row or column to resize it.
To keep some data in the same place and still 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 and, at the top, click View Freeze
No rows or No columns.
Move rows or columns
- On your computer, open a spreadsheet in Google Sheets.
- Select the rows or columns to move.
- At the top, click Edit.
- Select the direction you want to move the row or column, like Move row up.
You can also click and drag a row or column to a new location.
Move cells
- Select the cells to move.
- Point your cursor to the top of the selected cells until a hand icon appears.
- Click and drag the cells to their new location.
- 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.
Delete, group, or hide rows and columns
Delete rows, columns, or cells
- On your computer, open a spreadsheet in Google Sheets.
- Right-click a row, column, or cell.
- From the menu that appears, choose Delete row, Delete column, or Delete cells.
Group or ungroup rows or columns
You can organize and summarize related data by grouping together rows and columns.
- On your computer, open a spreadsheet at sheets.google.com.
- Select the rows or columns you want to group or ungroup.
- At the top, click Data and choose what you want to do:
- Group rows
- Group columns
- Ungroup rows
- Ungroup columns
To expand or collapse grouped rows or columns, click the Plus (+) or Minus (-) sign next to the rows or columns.
Hide rows or columns
- On your computer, open a spreadsheet in Google Sheets.
- Click a row or column to highlight it. You can also select multiple rows or columns.
- 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 unhide a row or column, click the arrow around where the row number or column letter used to be.
Related article
Mary is a Docs & Drive expert and author of this help page. Leave her feedback below about the page.