Data in spreadsheets isn’t always neatly distributed across entire rows and columns; oftentimes, for instance, sheets contain multiple tables and regions of data that can’t be separated. These new features make it easier to insert cells into sheets without disturbing content. You can add a rectangular block of cells to any spreadsheet on the web, and it will simply shift the surrounding cells down or to the right.
You can delete chunks of cells in the same way.
Both features are also accessible when you right-click on a cell. For more information, check out the Help Center.
The Collaboration Services Team
Tip: Did you know? You can freeze headings and labels in large spreadsheets
Learn more about Google at the G Suite Learning Center