How to Insert Multiple Cells in Google Sheets

Step 1: Select the cells

Select and highlight the number of cells you want to add by clicking on one cell and dragging your mouse over the amount of cells you want to select.

Step 2: Right-click the Cell and Select Insert Cells

Right-click on the cell and in the menu select “Insert cells“. Further, Select from the given two options:

• Insert cells and shift right
• Insert cells and shift down.

Step 3: Select Either Insert Cells and Shift Right or Insert Cells and Shift Down

• If we click on “Insert cells and shift right”, the number of cells we selected will be entered and the coloured cells will be shifted to the right.
• If we click on “Insert cells and shift down“, the number of cells we selected will be entered and the coloured cells will be shifted down.

Preview Inserted Cells at the Right.

Preview Inserted Cells at the Bottom.

Google Sheets is a component of the collaborative Google Suite, designed to work seamlessly in the cloud. It’s a versatile tool for managing and analyzing data, and the best part is that it’s free to use and requires no installation. But sometimes you need to modify your spreadsheet’s structure to fit your needs. Knowing how to insert cells in Google Sheets is essential for tasks like adding new data, creating space for calculations, or reformatting existing information.

Here, we’ll learn to add one cell as well as multiple cells to your Google Sheets on desktop and mobile as well. Whether you need to accommodate new data, create room for more information, or restructure your spreadsheet, you’ll find the guidance you need to master this essential skill.