How to shift cells down in Google Sheets
Learn how to shift cells down in Google Sheets using the right-click menu, Insert menu, or keyboard shortcuts to make space for new rows.
Quick answer
Select the cell range where you want to insert space, right-click the selection, and choose Insert cells, then pick Shift down. Google Sheets moves the selected cells and everything below them downward, leaving blank cells in place. You can also use the Insert menu or keyboard shortcut Ctrl+Alt+= (Cmd+Option+= on Mac) for the same result.
Steps at a glance
- Select the cells or range you want to shift
- Right-click the selection to open the context menu
- Choose Insert cells from the menu
- Select Shift down in the dialog box
- Click OK to move data downward
- Alternatively, use the Insert menu at the top
- Or press Ctrl+Alt+= for a quick shortcut
Summary
Shifting cells down in Google Sheets lets you insert blank space above existing data without deleting or overwriting anything. This built-in feature is essential for reorganizing spreadsheets, inserting missed rows, or making room for new entries mid-table.
Step-by-step guide
Step 1
Select the range you want to shift
Click and drag to highlight the cell or range of cells where you want new blank space to appear. This selection determines exactly which cells move down and how many rows shift, so only select the area that needs adjusting.
Step 2
Open the right-click context menu
Right-click anywhere inside your selected range. A context menu will appear with several options, including Insert cells near the top of the list.
Step 3
Choose Insert cells
Hover over or click Insert cells to reveal a small dialog box with directional options. This is the core command that creates space without deleting your existing data.
Step 4
Select Shift down
In the dialog box, choose the option labeled Shift down (it may also appear as Shift cells down depending on your view). Click OK to confirm, and Google Sheets will push your selected cells and everything below them one or more rows downward.
Step 5
Use the Insert menu as an alternative
If you prefer menus over right-clicking, select your range, then go to the Insert menu at the top of the screen and choose Cells, then Shift down. This produces the same result and is useful if you're already working in the menu bar to add columns or adjust other layout elements.
Step 6
Try the keyboard shortcut for speed
For faster repeated shifts, select your range and press Ctrl+Alt+= on Windows or Cmd+Option+= on Mac. This opens the same Insert cells dialog instantly, letting you confirm Shift down without touching your mouse.
Step 7
Verify your data moved correctly
Scroll down to check that formulas, formatting, and values below your insertion point shifted properly and no data was overwritten. If you also need to reposition entire rows rather than just cells, see how to move or swap rows for a related technique.
Why this matters
You're halfway through a spreadsheet and realize you forgot to add a row of data in the middle. Instead of manually retyping everything below, shifting cells down instantly pushes existing values out of the way so you can insert new information cleanly.
Frequently asked questions
Does shifting cells down delete any data?
No, shifting cells down does not delete data. It moves the selected cells and everything below them further down the sheet, creating blank rows in the space you selected.
Is there a keyboard shortcut to shift cells down?
Yes, select the cells you want to shift and press Ctrl+Alt+= on Windows or Cmd+Option+= on Mac. This opens the Insert cells dialog where you can confirm the Shift down option.
Can I shift an entire row down instead of just a few cells?
Yes, right-click the row number and choose Insert 1 row above or below, which shifts all cells in that row and below it down automatically without needing the Insert cells dialog.
Is this feature available on the free version of Google Sheets?
Yes, shifting cells down is a standard built-in feature available to every Google Sheets user with a free Google account, with no premium upgrade required.
Create interactive demos like this one — free, no coding required.
Start for free →