Help & Support
Send Feedback
Insert and Delete Cells
Adds menu commands to insert cells (shifting existing contents down or right) and delete cells (shifting up or left).
karl.kranich.org
19,469 users
Works with
Install
Overview
This add-on creates menu items that allow you to easily insert blank cells in the middle of a spreadsheet, shifting the existing content down or to the right.  

It also allows you to delete cells in the middle of a spreadsheet, shifting in content up or left.

Changes can be easily undone with Edit - Undo (Control- or Command-Z).
Reviews
January 4, 2017
I format my sheets with background color and number and date formatting but this add on does not keep the formatting. Am I doing something wrong?
Submit reply
Cancel
October 26, 2016
This is exactly what I needed!
Submit reply
Cancel
October 15, 2016
Works great! Thanks!
Submit reply
Cancel
September 6, 2016
Loving this add on. Eventhough it's something basic..it's a great help
Submit reply
Cancel
September 1, 2016
3* only that the new cell locations seize containing the formula and also somehow the shifted data seizes being part of the formula! Looking forward to the fix.
Submit reply
Cancel
July 27, 2016
How do you know your information stays secure? in the permissions if you click on the "i" button it states that your sheets can be shared. With whom and why?
Submit reply
Cancel
A Google User
October 26, 2016
Agreed! I have information that cannot be public and hate that it doesnt seem secure!
July 2, 2016
YES. THANK YOU!
Submit reply
Cancel
June 22, 2016
This should have been the default feature in Google Sheet!
Submit reply
Cancel
May 24, 2016
This add-on works perfectly. I consider this basic functionality and would have had to abandon google sheets if not for this.
Submit reply
Cancel
January 31, 2016
Is a keyboard shortcut available for this? Also would be great if could right click -> shift cells up, shift cells down etc.
Submit reply
Cancel
1-10 of 22
Additional information
Search
Clear search
Close search
Google apps
Main menu