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:

  • 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 :-)

Popular posts from this blog

Google Script - Create a Drop-Down List from Spreadsheet Column

Google Calendar - How to Share Your Calendar Via Link

2019 MACUL Conference Tipsheet #1 - Food Tips & Special Events

Google Contacts - Newest Area to Get Some "Google Love"

Google Slides - Rulers & Guides