Skip to content

How to Add Rows and Columns

This article answers the following questions.

  • How to add rows and columns in Excel
  • How to add rows and columns in Google Sheets

Feel free to skip straight to the answer you’re looking for!

Add Columns in Excel

To add a column in Excel, select the column where you want to add a new column.

Next, right-click and select Insert. Excel will insert a new column before the column you selected and push that column to the right.

To insert multiple columns, select the number of columns you would like to insert.

Next, right-click and select Insert. Excel adds the new columns to the left of the selected columns.

You can also add new columns with the keyboard shortcut ALT I > C.

Add Rows in Excel

To add a row in Excel, select the row where you want to add a new row.

Next, right-click and select Insert. Excel will insert the new row above the selected row.

 

To insert multiple rows, first select the number of rows you would like to insert.

Next, right-click and select Insert. Excel adds the new rows above the selected rows.

You can also add new rows with the keyboard shortcut ALT I > R.

Add Columns in Google Sheets

To add a column in Google Sheets, select the column where you want to add a new column.

Next, right-click and select Insert 1 column left or Insert 1 column right. Google Sheets will insert the new column to the left or right of the selected column depending on your choice.

To insert multiple columns, first select the number of columns you would like to insert.

Next, right-click and select Insert # columns left or Insert # columns right. Google Sheets adds the new columns wherever you decide.

Add Rows in Google Sheets

To add a row in Google Sheets, select the row where you want to add a new row.

Next, right-click and select Insert 1 row above or Insert 1 row below. Google Sheets will insert the new row above or below the selected row, depending on your choice.

To insert multiple rows, first select the number of rows you would like to insert.

Next, right-click and select Insert # rows above or Insert # rows below. Google Sheets adds the new rows wherever you decide.

This Post Has 0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top