How to Add More Than One New Row or Column in Google Sheet

0
119

Google Sheet Trick: How to Add More Than One New Row or Column in Google Sheet. This guide is about Add More Than One New Row or Column in Google Sheet quickly.

Usually, you may insert each blank row one by one but today I come with new tips that insert More Than One New Row or Column in Google Sheet.

googlesheet
googlesheet

When you need to quickly insert more than 20 rows between Row 5 and 6 in Google Sheet, how would you do?

it really wastes a lot of time if you need to insert more than one of these by repeating this action X number of times

This article focuses on tricky ways to insert multiple blank rows or columns quickly in Excel.

How to Add More Than One New Row or Column

Step 1. Select X rows or columns

Step 2. Right click the selected rows and choose Insert from the drop down menu. New rows will be inserted above the row or to the left of the column you first selected, see screenshot.

Add More Than One New Row or Column in Google Sheet
Add More Than One New Row or Column in Google Sheet

Then it will insert X blank rows between the Row 5 and Row 6 quickly.

LEAVE A REPLY

Please enter your comment!
Please enter your name here