How to Add/Remove Rows and Columns in Google Sheets [2020 Tutorial]

Step-by-step tutorials of 7 ways you add/remove rows and columns on Google Sheets, including Insert tab, right-click, PC and Mac keyboard shortcuts, and more!

Table of Contents
  1. Add a row or column via Insert tab
  2. Add multiple rows or columns via Insert tab
  3. Add/remove a row or column via right-click
  4. Add/remove multiple rows or columns via right-click
  5. Add rows at the bottom of the Google Sheet
  6. Add/remove row(s) or column(s) via PC keyboard shortcuts
  7. Add/remove row(s) or column(s) via Mac keyboard shortcuts
Table of contents
Chapter 1
Chapter 2
Chapter 3
  1. Add a row or column via Insert tab
  2. Add multiple rows or columns via Insert tab
  3. Add/remove a row or column via right-click
  4. Add/remove multiple rows or columns via right-click
  5. Add rows at the bottom of the Google Sheet
  6. Add/remove row(s) or column(s) via PC keyboard shortcuts
  7. Add/remove row(s) or column(s) via Mac keyboard shortcuts

If you create a new workbook on Google Sheets, you’ll see that a Google Sheet, by default, contains 26,000 cells, organized in 1,000 rows and 26 columns (labeled A-Z). For some, 26,000 cells can be overwhelming, especially if you’re only looking to create a small pivot table or run some quick calculations. For others, 26,000 cells is not enough, as you may be working with large amounts of internal data or tracking a variety of metrics.

Either way, it’s important to know how to adjust the number of cells of your Google Sheet, whether that be adding rows or removing columns (or vice versa!). 

We’ll go through several ways to get this done, so you can decide the best method for you and your situation!

Using the Insert tab for a single row or column

  1. Open spreadsheet on Google Sheets.
  2. Select the row (or column) where you’d like to add another.
  3. Click Insert tab > Select Row above or Row below (for columns, Column left or Column right).
  4. Voila! You should now have a blank row (or column) in your desired position.
Spreadsheet named "Pixar Movies" with movies and information in corresponding columns. Row 3 is highlighted and Insert tab is open with Row above highlighted.
How the Insert tab will look with a row selected
Spreadsheet named "Pixar Movies" with movies and information in corresponding columns. Column C is highlighted and Insert tab is open with Column left highlighted.
How the Insert tab will look with a column selected


Using the Insert tab for multiple rows or columns

  1. Open spreadsheet on Google Sheets.
  2. For the N rows (or columns) you want to add, select N vertical cells (or horizontal cells) where you’d like to add that set. For instance, below I want to add 3 rows, so I selected 3 vertical cells:
Spreadsheet named "Pixar Movies" with movies and information in corresponding columns. Cells A2:A4 are selected.


  1. Click Insert tab > Select N Rows above or N Rows below (for columns, N Columns left or N Columns right). 
Spreadsheet named "Pixar Movies" with movies and information in corresponding columns. Cells A2:A4 are selected with Insert tab open and 3 Rows above highlighted.
Google Sheets will automatically generate the number of rows (or columns) based on your selected cells!


Right-clicking to add/remove a single row or column

  1. Open spreadsheet on Google Sheets.
  2. Select the row (or column) where you’d like to add another.
  3. Right-click on the selection > Choose your desired action among Insert 1 above, Insert 1 below, and Delete row (for columns, the options are Insert 1 left, Insert 1 right, and Delete row).
Spreadsheet named "Pixar Movies" with movies and information in corresponding columns. Row 2 is selected and right-click menu is open with Insert 1 above highlighted


Right-clicking to add/remove multiple rows or columns

  1. Open spreadsheet on Google Sheets.
  2. For the N rows (or columns) you want to add/remove, select N vertical cells (or horizontal cells) where you’d like to add that set. For instance, below I want to add 3 rows, so I selected 3 vertical cells:
Spreadsheet named "Pixar Movies" with movies and information in corresponding columns. Cells A2:A4 are selected.

  1. Right-click on the selection > Choose your desired action among Insert N rows, which will add above, and Delete rows (for columns, the options are Insert N columns, which will insert left, and Delete columns).
Spreadsheet named "Pixar Movies" with movies and information in corresponding columns. Cells A2:A4 are selected and right-click menu is open with Insert 3 rows highlighted

Adding rows at the bottom of the sheet

  1. Open spreadsheet on Google Sheets.
  2. Scroll to the bottom of the sheet > Locate Add N more rows at bottom box.
  3. Enter desired number in text field > Press Add.
Bottom of a Google Sheet spreadsheet with Add button, a number text field, and "more rows at bottom." underneath row 1000


Using PC keyboard shortcuts to add/remove rows or columns

In Google Chrome, select desired rows (or columns), then press… 

  • Alt + i, then r to add row above
  • Alt + i, then w to add row below
  • Alt + i, then c to add column left
  • Alt + i, then o to add column right
  • Alt + e, then d to remove row
  • Alt + e, then e to remove column
  • F4 key to repeat previous action (good for adding/removing multiple rows and columns)

In other browsers, select desired rows (or columns), then press… 

  • Alt + Shift + i, then r to add row above
  • Alt + Shift + i, then w to add row below
  • Alt + Shift + i, then c to add column left
  • Alt + Shift + i, then o to add column right
  • Alt + Shift + e, then d to remove row
  • Alt + Shift + e, then e to remove column
  • F4 key to repeat previous action (good for adding/removing multiple rows and columns)

Using Mac keyboard shortcuts to add/remove rows or columns

In any browser, select desired rows (or columns), then press… 

  • Ctrl + Option + i, then r to add row above
  • Ctrl + Option + i, then b to add row below
  • Ctrl + Option + i, then c to add column left
  • Ctrl + Option + i, then o to add column right
  • Ctrl + Option + e, then d to remove row
  • Ctrl + Option + e, then e to remove column
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

September 15, 2020

How to Add/Remove Rows and Columns in Google Sheets [2020 Tutorial]

Google Sheet spreadsheet

If you create a new workbook on Google Sheets, you’ll see that a Google Sheet, by default, contains 26,000 cells, organized in 1,000 rows and 26 columns (labeled A-Z). For some, 26,000 cells can be overwhelming, especially if you’re only looking to create a small pivot table or run some quick calculations. For others, 26,000 cells is not enough, as you may be working with large amounts of internal data or tracking a variety of metrics.

Either way, it’s important to know how to adjust the number of cells of your Google Sheet, whether that be adding rows or removing columns (or vice versa!). 

We’ll go through several ways to get this done, so you can decide the best method for you and your situation!

Using the Insert tab for a single row or column

  1. Open spreadsheet on Google Sheets.
  2. Select the row (or column) where you’d like to add another.
  3. Click Insert tab > Select Row above or Row below (for columns, Column left or Column right).
  4. Voila! You should now have a blank row (or column) in your desired position.
Spreadsheet named "Pixar Movies" with movies and information in corresponding columns. Row 3 is highlighted and Insert tab is open with Row above highlighted.
How the Insert tab will look with a row selected
Spreadsheet named "Pixar Movies" with movies and information in corresponding columns. Column C is highlighted and Insert tab is open with Column left highlighted.
How the Insert tab will look with a column selected


Using the Insert tab for multiple rows or columns

  1. Open spreadsheet on Google Sheets.
  2. For the N rows (or columns) you want to add, select N vertical cells (or horizontal cells) where you’d like to add that set. For instance, below I want to add 3 rows, so I selected 3 vertical cells:
Spreadsheet named "Pixar Movies" with movies and information in corresponding columns. Cells A2:A4 are selected.


  1. Click Insert tab > Select N Rows above or N Rows below (for columns, N Columns left or N Columns right). 
Spreadsheet named "Pixar Movies" with movies and information in corresponding columns. Cells A2:A4 are selected with Insert tab open and 3 Rows above highlighted.
Google Sheets will automatically generate the number of rows (or columns) based on your selected cells!


Right-clicking to add/remove a single row or column

  1. Open spreadsheet on Google Sheets.
  2. Select the row (or column) where you’d like to add another.
  3. Right-click on the selection > Choose your desired action among Insert 1 above, Insert 1 below, and Delete row (for columns, the options are Insert 1 left, Insert 1 right, and Delete row).
Spreadsheet named "Pixar Movies" with movies and information in corresponding columns. Row 2 is selected and right-click menu is open with Insert 1 above highlighted


Right-clicking to add/remove multiple rows or columns

  1. Open spreadsheet on Google Sheets.
  2. For the N rows (or columns) you want to add/remove, select N vertical cells (or horizontal cells) where you’d like to add that set. For instance, below I want to add 3 rows, so I selected 3 vertical cells:
Spreadsheet named "Pixar Movies" with movies and information in corresponding columns. Cells A2:A4 are selected.

  1. Right-click on the selection > Choose your desired action among Insert N rows, which will add above, and Delete rows (for columns, the options are Insert N columns, which will insert left, and Delete columns).
Spreadsheet named "Pixar Movies" with movies and information in corresponding columns. Cells A2:A4 are selected and right-click menu is open with Insert 3 rows highlighted

Adding rows at the bottom of the sheet

  1. Open spreadsheet on Google Sheets.
  2. Scroll to the bottom of the sheet > Locate Add N more rows at bottom box.
  3. Enter desired number in text field > Press Add.
Bottom of a Google Sheet spreadsheet with Add button, a number text field, and "more rows at bottom." underneath row 1000


Using PC keyboard shortcuts to add/remove rows or columns

In Google Chrome, select desired rows (or columns), then press… 

  • Alt + i, then r to add row above
  • Alt + i, then w to add row below
  • Alt + i, then c to add column left
  • Alt + i, then o to add column right
  • Alt + e, then d to remove row
  • Alt + e, then e to remove column
  • F4 key to repeat previous action (good for adding/removing multiple rows and columns)

In other browsers, select desired rows (or columns), then press… 

  • Alt + Shift + i, then r to add row above
  • Alt + Shift + i, then w to add row below
  • Alt + Shift + i, then c to add column left
  • Alt + Shift + i, then o to add column right
  • Alt + Shift + e, then d to remove row
  • Alt + Shift + e, then e to remove column
  • F4 key to repeat previous action (good for adding/removing multiple rows and columns)

Using Mac keyboard shortcuts to add/remove rows or columns

In any browser, select desired rows (or columns), then press… 

  • Ctrl + Option + i, then r to add row above
  • Ctrl + Option + i, then b to add row below
  • Ctrl + Option + i, then c to add column left
  • Ctrl + Option + i, then o to add column right
  • Ctrl + Option + e, then d to remove row
  • Ctrl + Option + e, then e to remove column

Suscribe to get more data and analytics tips!

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.