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.
- 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.
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.
When I select Insert above then automatically 6 rows insert after my selection. look bird eye on the screenshot.
When you want to insert rows you can select rows, right click and select insert above or below. Enjoy it…