How to insert, move, and delete rows and columns

Published June 12, 2022

As you work with the Google sheets spreadsheets, you will find that you want to insert a new column or rows, delete specific rows and columns and lastly, move them to another location in the spreadsheets. This will help you to organize your data properly or more professionally. In this article, we are going to discuss the following:

How to insert a new column or row in a Google sheet
How to delete an existing row or column
How to move a row or column from one location to another

How to insert a new column or row in a Google sheet

First and foremost, we will learn how to add a new row or column to a Google Sheet. It's simple to add a new row or column to a Google Sheet. Simply follow the easy steps outlined here.

Step 1: Open an existing Google sheet with some data filled in.

How to insert, move, and delete rows and columns

Step 2: Let us begin by adding a row. To insert a row in the table, right-click on the row header and pick "insert 1 row above" or "insert 1 row below" from the dropdown menu that appears, depending on where you want your row to appear.

How to insert, move, and delete rows and columns-2

A new row is successfully added. Now, add the data to the newly created row.

How to insert, move, and delete rows and columns-3

Step 3: Let's add a new column now. It is also simple to add a new column. Simply right-click on the column header and choose "+Insert 1 column to the left" or "+Insert 1 column to the left" from the menu that displays.

How to insert, move, and delete rows and columns-4

A new column will be added to your table depending on the option you choose.

How to insert, move, and delete rows and columns-5

Now enter data to the new column created:

How to insert, move, and delete rows and columns-6

How to delete an existing row or column

We learned how to insert a new row and a new column. Now let's look at how you may get rid of them.

Step 1: let's first delete a row. Right-click on the row header of the row you wish to delete. A menu with different options will appear on your screen. Now, click on the "Delete row" option.