How to add or delete rows and columns in Google Sheets

Google Sheets lets you add rows or columns to existing spreadsheets. If you want to add one or more rows above or to the right, follow the instructions below.

1. How to set the right to edit spreadsheets on Google Sheets
2. How to link data between spreadsheets in Google Sheets
3. How to create Google Spredsheet automatically updates data

How to add columns or rows

Open the browser, go to the Google Sheets homepage. Open the worksheet you want to insert the column or row.

Picture 1 of How to add or delete rows and columns in Google Sheets

Next, click on the cell you want to insert the next column or row. Then choose Insert from the toolbar.

Picture 2 of How to add or delete rows and columns in Google Sheets

From the Insert menu, you will see several options for inserting rows or columns into spreadsheets. You can insert rows up or down and columns to the left or right of the selected cell.

Picture 3 of How to add or delete rows and columns in Google Sheets

If you want to insert more than one column or row, highlight the number of cells you want to add. For example, highlight two vertical cells to insert two rows or bold two horizontal cells to insert two columns.

Picture 4 of How to add or delete rows and columns in Google Sheets

You can insert columns and rows from the right-clicking menu. Highlight the cell you want to insert next to, right-click the selection, and then choose Insert Rows or Insert Columns .

Picture 5 of How to add or delete rows and columns in Google Sheets

By default, when using the right click method, the row will be inserted above and the column will be inserted to the left of the selection.

Google Sheets even has a few keyboard shortcuts you can add rows or columns without lifting your hands off the keyboard. Select the cell and then press the shortcut key to insert the row or column.

Because Google likes to make things complicated, there are a number of browser-specific shortcuts. If you use Chrome on Windows, Linux or Chrome OS use keyboard shortcuts for Chrome. If using a different browser, execute the command for another browser.

Insert row above Alt + I , then press R Alt + Shift + I , then press R Insert row below Alt + I , then press W Alt + Shift + I , then press W Insert column to the left Alt + I , then press C Alt + Shift + I , then press C Insert right column Alt + I , then press O Alt + Shift + I , then press O

If you use macOS, follow these keyboard shortcuts to add rows or columns to spreadsheets:

Insert row above Ctrl + Option + I , then press R Insert row below Ctrl + Option + I , then press W Insert left column Ctrl + Option + I , then press C Insert right column Ctrl + Option + I , then press O

Picture 6 of How to add or delete rows and columns in Google Sheets

1. List of common keyboard shortcuts for Google Sheets on your computer (Part 1)

How to delete rows and columns

Open Google Sheets in the browser and open the spreadsheet you want to delete rows and columns.

Highlight a cell in the row or column you want to delete, right-click and then choose Delete Row or Delete Column .

Picture 7 of How to add or delete rows and columns in Google Sheets

If you want to delete multiple rows or columns, highlight the number of cells you want to delete and then right-click and delete them.

Picture 8 of How to add or delete rows and columns in Google Sheets

When deleting columns and rows in Google Sheets, you can use these shortcuts if you want. Highlight the number of cells from the column or row you want to delete, then press the keyboard shortcut for the command you want to use.

Google also divides keyboard shortcuts for Chrome and other browsers for Windows, Linux and Chrome OS.

Alt + E, then press D (Chrome) or Alt + Shift + E, then press D (Other browsers): Delete row
Alt + E, then E (Chrome) or Alt + Shift + E, then E (Other browsers): Delete column

If you use macOS, you can use the following keyboard shortcuts to delete columns and rows.

Ctrl + Option + E, then press D: Delete row
Ctrl + Option + E, then press E: Delete column

I wish you successful implementation!