In this tutorial, you will learn how to shift cells down in Google Sheets.
How To Shift Cells Down In Google Sheets
Quick Navigation
When working with data in Google Sheets, you may want to shift the contents of cells down.This can be helpful if you are adding a new row to the top of your spreadsheet, and you want the existing data to move down.
You may also want to shift cells down if you want to insert a new row somewhere within an existing table.
In this guide, we will show you how to shift cells down in Google Sheets.
How to Move Cells Down When Inserting Values in Google Sheets
Here’s how to move cells down when inserting values in Google Sheets.
Step 1
Select the range of cells you want to insert blank cells to.
In this example, we want to insert blank cells into the range A4:F4. We want the values in the original range of A4:F12 to shift down during the insertion.
Step 2
Right-click on the selection and click Insert cells > Insert cells and shift down.
Step 3
You have now successfully shifted cells down after inserting blank cells in the target cell range.
If we try to add blank cells to the cell range A4:B4, we will only move values in column A and B.
Step 4
Alternatively, you may also shift cells down using the menu bar. Simply click Insert > Cells > Insert cells and shift down.
Step 5
Another way to shift cells down is by adding a row above the range of cells you want to shift down.
Start by selecting the target row.
Step 6
Next, right-click on the selection and select ‘Insert 1 row above”.
Step 7
Your target cells should now be shifted down since we’ve effectively inserted a new row above the range.
Summary
This guide should be everything you need to shift cells down in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.