Google Sheets - Inserting Rows/Columns
(Part of my administrative assistant series on Google Sheets.)
There are several ways to insert rows and/or columns in a spreadsheet in Google Sheets. The easiest way is to highlight the row (or column) you want to add next to by clicking on the row or column name (the letter or number...). Then use one of these methods:
But what about if you want to insert more than one row? Do you have to add one row at a time?
NO - you do not.
You can instead highlight as many rows (or columns) as you wish to add -
Then using one of the two methods above add MULTIPLE rows or columns at one time -
A time saver for those of you that were adding individual rows or columns :-)
There are several ways to insert rows and/or columns in a spreadsheet in Google Sheets. The easiest way is to highlight the row (or column) you want to add next to by clicking on the row or column name (the letter or number...). Then use one of these methods:
- Go to the Insert Menu and select Row above or Row below, as wanted
- Right click on select Row above or Row below, as wanted
But what about if you want to insert more than one row? Do you have to add one row at a time?
NO - you do not.
You can instead highlight as many rows (or columns) as you wish to add -
Then using one of the two methods above add MULTIPLE rows or columns at one time -
A time saver for those of you that were adding individual rows or columns :-)