Note: Google has added this functionality to Sheets, so this Add-on isn’t necessary anymore.
Note #2: if you get the error “We’re sorry, a server error occurred…” you probably have merged cells that need to be split for this Add-on to work. Please see this post.
This Add-on provides the ability to:
- Insert a cell or block of cells, shifting the existing cell contents down or to the right
- Delete a cell or block of cells, shifting in content from below or the right
Here’s a link to the Add-on in the Google store. Or just search for “insert cells” when browsing Add-ons from Sheets.
After you install the Add-on, the Add-on menu will contain a new “Insert and Delete Cells” menu with the following items:
- Insert – Shift Down
- Insert – Shift Right
- Delete – Shift Up
- Delete – Shift Left
The following video demonstrates this functionality:
The code for this add-on is available in github.