NorthStar Analytics
Pricing

HiDocs High-Quality Ghost Documentation Theme

How to Add or Remove Rows and Columns in Google Sheets

How to Add or Remove Rows and Columns in Google Sheets

Adding rows or columns is one of the things often required when working with Google Sheets. Learning to do so is a core skill that makes it easier to create useful spreadsheets.

How to Add a Column?

You can add a column from the menu, as well as by right-clicking and making a shortcut. First, look at how to do it from the menu.

How to Add a Column Using the Menu?

  1. Go to where you want the column to be added
  2. Menu ->Insert -> Insert 1 column to the left or
  3. Menu ->Insert -> Insert 1 column to the right

How to Add Column From Shortcut?

  1. Go to where you want to add a column, select that column.
  2. Right-click -> Insert 1 column to the left.

In this way, a column is added to the left. Let's do the same thing for rows.

How to Add Rows?

It is an application that facilitates our work in also adding columns as well as adding rows. It can be done from the menu or with a right-click. First, let's take a look at how to do it from the menu.

How to Add a Row With The Menu?

  1. Go to where you want to add a row
  2. Menu->Insert -> Rows -> Insert 1 row above or
  3. Menu->Insert -> Rows -> Insert 1 row below

The row is added! Now let's take a quick look at how to add rows by using shortcut.

How to Add a Row From Shortcut?

  1. Go to where you want to add a row.
  2. Right-click -> Insert 1 row above

Up to this point, we have covered how to add 1 row and 1 column. But what to do if we want to add more rows and columns?

How to Add Multiple Rows and Columns?

To add multiple rows:

  1. How many rows do you want to add, select that many rows
  2. Right-click on your selection and insert X rows above

To add multiple columns:

  1. How many rows do you want to add, select that many rows
  2. Right-click -> Insert X columns above (X; You can choose as many as you want. I chose 2 for the example.)

That's it! We learned how to add rows and columns with Google Sheets. I hope the article was helpful.

Make your business data transparent!
  • Subscribe to a package

    Subscribe and explore the limits of your business with data or thinking to expand your agency value proposition with Google Data Studio dashboards?

  • Request unlimited dashboards

    You can request as many dashbaords you might have and as many revisions as you might need. We create a queue of your tasks, the first tasks that come in are the tasks that we’ll deliver first.

  • Your Data Studio Department

    Optimise your business with complete transparency through dashboards or provide value-added Google Data Studio service to your agency clients.

Make your business transparent

The fastest easy-to-use Google Data Studio dashboards without any recurring cost.