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

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

It works with columns as well:

Insert multiple columns

Tip: inserted rows and columns will copy the formatting from the selection nearest to the insertion point:

Formatting copied to inserted rows

Originally published at https://dataful.tech on May 22, 2024.