How to Insert Multiple Rows and Columns in Google Sheets
You can easily insert one row in Google Sheets by right-clicking on the header and choosing Insert 1 row above / below
:
![Insert one row](/google-sheets/insert-multiple-rows-and-columns/insert-one-row.png)
But do you insert multiple rows? Easy: select the necessary number of columns and click the header again. It will suggest inserting as many rows as you selected:
![Insert multiple rows](/google-sheets/insert-multiple-rows-and-columns/insert-multiple-rows.png)
It works with columns as well:
![Insert multiple columns](/google-sheets/insert-multiple-rows-and-columns/insert-multiple-columns.png)
TIP: Inserted rows and columns will copy the formatting from the selection nearest to the insertion point:
![Formatting copied to inserted rows](/google-sheets/insert-multiple-rows-and-columns/inserted-rows-with-formatting.png)