[update on 9/24/2014: This has now been published as a Google Add-on. Please see this page. To install the Add-on, just search for “insert cells” when browsing for Add-ons from Google Sheets]
I haven’t been able to find a way in Google Spreadsheets to insert a cell (or cells) in the middle of a spreadsheet and tell the existing content to shift down or to the right. Similarly, I’d like to be able to select cells to delete, and have them fill in by content shifting up or from the right.
So, I created a Google Apps script to add “Insert Cells” and “Delete Cells” menus to Google Spreadsheets. Right now, you need to copy the code from github and paste it into the Script Editor in Google Spreadsheets (see the Tools menu). Hopefully I’ll get the code cleaned up enough to have Google approve it as an Add-on soon!
Watch the video for a demonstration.