[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.