Insert and delete groups of cells in Google Sheets
February 8, 2017
Google is making it easier to insert cells into sheets without disturbing that content. You can add a rectangular block of cells to any spreadsheet on the web, and it will shift the surrounding cells down or to the right. You can delete chunks of cells in the same way.
You can insert cells from Insert menu and delete cells from the Edit menu. Both features are also accessible when you right-click on a cell. For more information, check out the Help Center.