See all How-To Articles

How to Add Rows to a Table in Excel & Google Sheets

This tutorial demonstrates how to add rows to a table in Excel and Google Sheets.

 

addrowstotable intro

 

Add Rows to the Bottom of a Table

If your data is formatted as an Excel table, it is easy to add extra rows.

Add Rows With the Tab Key

  1. Click in the bottom right-hand corner of your formatted table, in the last available cell.

 

addrowstotable select

 

  1. Press TAB to add another row to your table.

 

addrowstotable press tab

 

Add Rows by Typing in the Next Row

A row is also added to a formatted Excel table when you type in the first cell of the first blank row at the end of your table.

  1. Click in the first cell of the row below your table.

 

addrowstotable click below

 

  1. Type in a value, and then press TAB.

 

addrowstotable type

 

  1. When you do this, a menu button appears. Click on the menu to see the options available.

 

addrowstotable options

 

  • If you DO NOT want the new row to be automatically included in the table, click Undo Table AutoExpansion.
  • If you want to stop this table, and any future tables from automatically expanding, click Stop Automatically Expanding Tables.
  • To view more AutoCorrect options, click Control AutoCorrect Options.

Add Rows in the Middle of a Table

Add Rows With the Ribbon

  1. Click in the row of your Excel table where you want the new row to be inserted.

 

addrowstotable select cell

 

  1. In the Ribbon, select Home > Insert > Insert Table Rows Above.

 

addrowtotable ribbon insert row

 

  1. A new row is added above the row that is currently selected in your table.

 

addrowstotable row added

 

Add Rows With the Keyboard

  1. Click in the row of your Excel table where you want the new row to be inserted.
  2. Press and hold CTRL, then press the + sign to insert a row above your selected row.

Resize a Table

You can also add rows to an existing table by resizing the table.

  1. Position your mouse at the small handle in the bottom right-hand corner of the table. Your mouse pointer changes to a small double-headed black arrow.

 

addrowstotable black arrow

 

  1. Drag the mouse down the number of rows to be inserted.

 

addrowstotable drag down

 

  1. Release the mouse to add the rows to your table.

 

addrowstotable new rows

 

Note: You can also drag back up again to delete the rows!

 

Add Rows to a Table in Google Sheets

Add a Row to the Bottom of a Table

If your table in Google Sheets has been formatted with alternating colors (Menu > Format > Alternating Colors), you can automatically add rows to the formatted table.

  1. Click in the cell below the last row of your table.

 

addrowstotable gs select

 

  1. Type in your data, and then press TAB.

 

addrowstotable gs row added

 

  1. A new row is added formatted in the style you have chosen for your table.

Add a Row in the Middle of a Table

  1. Click in the middle of your table where you want the row inserted.

 

addrowstotable gs select row

 

  1. On the row header, right click to obtain the quick menu.

 

addrowtotable gs insert row

 

Tip: By selecting more than one row in your table, the quick menu changes accordingly. So, if you select two rows, the menu is shown as in the picture below:

 

addrowstotable gs select multiple rows

 

  1. Select the option to add the row or rows to your table.

 

addrowstotable gs rows added