How To Simply Insert Multiple Rows in Google Sheets

  • April 19, 2019
  • 383 Views
  • 0 0
How To Insert Multiple Rows in Google Sheets

How To Insert Multiple Rows in Google Sheets

How To Insert Multiple Rows in Google Sheets.

In our last google sheets articles, I will guide you about merge cells is google sheets. You can always find any kind of tip about google sheets and docs in HMANCH.  Now we start learning about “how to insert multiple rows in google sheets“. I will guide you each and every step clearly in screenshots you can read, and follow me.

Go to sheets.google.com and select your document where you want to insert multiple rows.

  1. Put your cursor in the heading of rows and columns and drag down or highlight cells and then right click. Same I show you in the screenshot.
Insert rows in google sheets

Insert rows in google sheets

2. Now here is two option you can see in the right click options menu. first one is “Insert above” and second is “Insert below“. 6 is the number of rows I can select. When you select more rows at one its shows more number according to the selection of rows. Now I click on Insert above and seen automatically 6 rows insert before my selection.

insert multiple rows in google sheets

insert multiple rows in google sheets

When I select Insert above then automatically 6 rows insert after my selection. look bird eye on the screenshot.

how to insert new rows in google sheets

how to insert new rows in google sheets

When you want to insert rows you can select rows, right click and select insert above or below. Enjoy it…

Leave a Reply

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