Add or move columns & cells


               

Want advanced Google Workspace features for your business?

Try Google Workspace today!

 

 

You can add, change, move, or delete your spreadsheet's columns, row, or cells.

Add one row, column, or cell

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select a row, column, or cell.
  3. Right-click the row, column, or cell.
  4. From the menu that appears, select Insert 1 left, right, above or below.

Add more than one row, column, or cell

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Highlight the number of rows, columns, or cells you want to add. To highlight multiple items:
    • Mac: ⌘ + click the rows or columns. 
    • Windows: Ctrl + click the rows or columns
  3. Right-click the rows, columns, or cells.
  4. From the menu that appears, select Insert [Number] or Insert cells.
    For example:
    1. Highlight 5 rows.
    2. Right-click anywhere on those rows.
    3. Select Insert 5 rows above or below.

To add 100+ rows to your spreadsheet:

  1. On your spreadsheet, scroll to the bottom.
  2. Next to "more rows at the bottom," enter the number of rows you’d like to add.
  3. Click Add.
Change row height or column width
  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select a row or column to resize. To highlight multiple rows or columns:
    • Mac: + click the rows or columns
    • Windows: Ctrl + click the rows or columns
  3. Right-click the row number or column letter.
  4. Click Resize row or Resize column. Then, choose an option:
    • Enter a custom height or width
    • Fit to data
  5. Click OK.

You can also drag the edge of a row or column to resize it or double-click the row or column edge to fit to data.

Move rows, columns, or cells

Move rows or columns

Add more than one row, column, or cell gif

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Select the rows or columns to move.
  3. At the top, click Edit.
  4. Select the direction you want to move the row or column, like Move row up.

You can also drag a row or column to a new location.

Move cells

  1. Select the cells to move.
  2. Point your cursor to the top of the selected cells until a hand appears.
  3. Drag the cells to their new location.
Delete rows, columns, or cells
  1. On your computer, open a spreadsheet in Google Sheets.
  2. Right-click a row, column, or cell.
  3. From the menu that appears, choose Delete row, Delete column, or Delete cell.

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
13137038007237924360
true
Search Help Center
true
true
true
true
true
35
false
false