[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Do you need to insert multiple rows in your Google Sheet? If you\u2019re tired of adding them one by one, you\u2019ll be happy to learn there\u2019s another way to do it. In fact, there are a few ways to insert multiple rows in Google Sheets.<\/p>\n
In this post, you will learn how to add new rows using the \u2018Insert\u2019 menu, the right-click menu, and the button on the bottom-left corner of your spreadsheet. Additionally, you will learn how to use shortcuts to add multiple rows even more quickly.<\/p>\n
[\/et_pb_text][et_pb_text module_id=”how-to-insert-multiple-rows-in-google-sh” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
As mentioned above, there are various methods you can use to insert multiple rows in Google Sheets. Below, you have step-by-step instructions on using each method: the \u2018Insert\u2019 menu, the right-click menu, the button on the bottom-left corner of the spreadsheet, and finally, the shortcuts, which will speed up the process even further.<\/p>\n
[\/et_pb_text][et_pb_text module_id=”insert-multiple-rows-in-google-sheets-us” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
To insert new rows via the \u2018Insert\u2019 menu, follow these steps. First, you\u2019ll learn how to insert a single row, then multiple rows.<\/p>\n
Follow these steps to add a single row.<\/p>\n
1.<\/strong> Select the row above or below which you want to insert new rows.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/insert-rows-google-sheets-select-row.webp” alt=”Insert rows in Google Sheets \u2014 row 3 selected in a sales data sheet” title_text=”Row 3 selected in a sales data sheet” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Go to Insert > Rows and choose whether to insert it above or below your selected row. For this example, I will add the new row below my selection.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/insert-rows-google-sheets-insert-menu-one-row.webp” alt=”How to insert multiple rows in Google Sheets \u2014 Insert > Rows menu with Insert 1 row above and Insert 1 row below” title_text=”Insert > Rows menu with Insert 1 row above and Insert 1 row below” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> That\u2019s it. I have my new row.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/insert-rows-google-sheets-row-added.webp” alt=”Insert a row in Google Sheets \u2014 new blank row 4 added below the selected row” title_text=”New blank row 4 added below the selected row” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Inserting multiple rows is just as easy as inserting a single one, but you need to select as many rows as you want to insert. For this example, I want to add three new rows below the fifth row, so I need to start by selecting three rows.<\/p>\n 1.<\/strong> To select multiple rows, click the first row number, then hold down ‘Shift’ and click the last one. Dragging down from the first row number works too.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/select-multiple-rows-google-sheets.webp” alt=”Select multiple rows in Google Sheets \u2014 rows 3 to 5 selected” title_text=”Rows 3 to 5 selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Once you have selected the appropriate number of rows, go to Insert > Rows. As you can see, the options at the top of the menu are now \u2018Insert 3 rows above\u2019 and \u2018Insert 3 rows below\u2019. For this example, I will choose the second option.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/insert-multiple-rows-google-sheets-insert-menu.webp” alt=”Insert multiple rows in Google Sheets \u2014 Insert > Rows menu showing Insert 3 rows above and Insert 3 rows below” title_text=”Insert > Rows menu showing Insert 3 rows above and Insert 3 rows below” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> As you can see, I have three new rows below the fifth row.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/insert-multiple-rows-google-sheets-rows-added-below.webp” alt=”Google Sheets insert multiple rows \u2014 three blank rows, 6 to 8, added below row 5″ title_text=”Three blank rows, 6 to 8, added below row 5″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”insert-multiple-rows-in-google-sheets-us” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n To insert multiple rows using the right-click menu, first select as many rows as you want to add to your spreadsheet. Once selected, right-click on your selection to get the menu. You can choose whether to add the rows above or below your current selection.<\/p>\n Below, you have step-by-step instructions on how to add a single row and multiple rows using the right-click menu.<\/p>\n Adding a row using the right-click menu is even quicker than the previous method.<\/p>\n 1.<\/strong> Select the row below or above which you want to add the new one.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/insert-row-google-sheets-right-click-select-row.webp” alt=”Add a row in Google Sheets \u2014 row 4 selected before opening the right-click menu” title_text=”Row 4 selected before opening the right-click menu” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Right-click on the row number to see the right-click menu. You can choose whether to add it above or below your selection.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/insert-row-google-sheets-right-click-menu.webp” alt=”Insert a row in Google Sheets \u2014 right-click menu with Insert 1 row above and Insert 1 row below” title_text=”Right-click menu with Insert 1 row above and Insert 1 row below” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> That\u2019s it. A new row has been added.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/insert-row-google-sheets-right-click-row-added.webp” alt=”Add a row in Google Sheets \u2014 new blank row 5 added below row 4″ title_text=”New blank row 5 added below row 4″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Now, let\u2019s see how to add multiple rows using the same method. For this example, I will be adding three new rows above the fourth row.<\/p>\n 1.<\/strong> Select as many rows as you want to add. Below, I have selected the fourth, fifth, and sixth rows.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/select-multiple-rows-google-sheets-right-click.webp” alt=”Select multiple rows in Google Sheets \u2014 rows 4 to 6 selected” title_text=”Rows 4 to 6 selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Right-click on the row numbers of your selection to see the menu. In this case, I will add three rows above the fourth row.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/insert-multiple-rows-google-sheets-right-click-menu.webp” alt=”Insert multiple rows in Google Sheets \u2014 right-click menu with Insert 3 rows above and Insert 3 rows below” title_text=”Right-click menu with Insert 3 rows above and Insert 3 rows below” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> That\u2019s it. The new rows have been added above my selection.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/insert-multiple-rows-google-sheets-rows-added-above.webp” alt=”Insert multiple rows in Google Sheets \u2014 three blank rows, 4 to 6, added above the selection” title_text=”Three blank rows, 4 to 6, added above the selection” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”add-multiple-rows-at-the-bottom-of-the-g” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n If you want to add rows at the bottom, go to the bottom-left corner of your spreadsheet.<\/p>\n Type in the number of rows you want to add and click the \u2018Add\u2019 button.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/add-multiple-rows-google-sheets-add-button.webp” alt=”Add multiple rows in Google Sheets \u2014 Add button with 1000 more rows at bottom, under the last row” title_text=”Add button with 1000 more rows at bottom, under the last row” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”how-to-add-rows-in-google-sheets-using-s” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n To insert multiple rows even more quickly, you can use shortcuts. Below, you have the shortcuts you can use in the Google Chrome browser on both Windows and Mac computers.<\/p>\n To insert rows above, use the following shortcut after selecting as many rows as you want to add.<\/p>\n Ctrl + Alt + =<\/p>\n You can also open the Insert menu from the keyboard: Alt + i, then r, then r. In browsers other than Chrome, start with Alt + Shift + i.<\/p>\n<\/blockquote>\n After selecting as many rows as you want to add, use the following shortcut to add the rows below your selection.<\/p>\n Alt + i, then r, then b<\/p>\n<\/blockquote>\n Select as many rows as you want to add and use the following shortcut to insert them above your selection.<\/p>\n Cmd + Option + =<\/p>\n The Insert menu keys work too: Ctrl + Option + i, then r, then r.<\/p>\n<\/blockquote>\n To insert rows below, select the number of rows you want to add and use this shortcut.<\/p>\n Ctrl + Option + i, then r, then b<\/p>\n For other shortcuts, see our Google Sheets keyboard shortcuts guide<\/a>.<\/p>\n<\/blockquote>\n [\/et_pb_text][et_pb_text module_id=”conclusion” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You can use different methods to insert as many rows as you need in Google Sheets. You now know how to add rows using the \u2018Insert\u2019 menu, the right-click menu, and the button on the bottom-left corner of the spreadsheet. You also know how to use shortcuts to speed up the process when using the Google Chrome browser on both Windows and Mac computers.<\/p>\n Once your new rows are in place, you can fill down<\/a> formulas or values into them. As the sheet grows, freeze your header rows<\/a> so they stay visible, or merge cells<\/a> to label a group of rows. If you add rows every week to paste in data from other files, see how to merge Google Sheets<\/a>, or let Sheetgo’s AI automations<\/a> bring that data into your sheet for you.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Aprenda a inserir v\u00e1rias linhas no Google Sheets com o menu Inserir, o menu de contexto, o bot\u00e3o Adicionar e os atalhos de teclado.<\/p>","protected":false},"author":2,"featured_media":266186,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[],"class_list":["post-266172","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/266172","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=266172"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/266172\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/266186"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=266172"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=266172"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=266172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Multiple rows<\/h3>\n
Insert multiple rows in Google Sheets using the right-click menu<\/h2>\n
Single row<\/h3>\n
Multiple rows<\/h3>\n
Add multiple rows at the bottom of the Google Sheet<\/h2>\n
How to add rows in Google Sheets using shortcuts?<\/h2>\n
Windows Chrome shortcuts<\/h3>\n
\n
\n
Mac Chrome shortcuts<\/h3>\n
\n
\n
Conclusion<\/h2>\n