How to Move Down a Line in Excel: Cells, Rows, and Text

In Excel for Microsoft 365 on Windows, press Enter to finish entering a value and move the selection down one cell, or press the Down Arrow to move the selection down without changing a value. To start a new line inside the same cell, press Alt+Enter. If you mean moving existing cells or a whole row down, use Excel’s Insert commands instead; the steps below explain each action.

What You’ll Need

A workbook open in Excel for Microsoft 365 on Windows.
A keyboard and mouse or trackpad. If you are changing the layout of existing data, identify the cells or row you intend to shift before inserting anything.
For a workbook with important data, consider saving a copy before making structural changes. Inserting cells or rows can affect formulas, references, and the layout around the selected area.

Step-by-Step

Move the active selection down one cell. Click a cell, then press the Down Arrow. The highlighted active cell moves to the cell directly below it; its contents are not moved or changed. This is the simplest option when you are navigating a worksheet. You can also click the destination cell directly. If you are currently typing or editing a cell, first press Enter or Esc to finish or cancel the edit, then use the arrow key.
Move down after entering data. Click a cell, type a value, and press Enter. Excel commits the entry and, by default, selects the cell beneath it. Continue typing into the newly selected cell if you are filling a column. Pressing Tab after an entry commits it and moves to the next cell on the right, so use Enter when you want to proceed downward. If you only need to move the selection and do not want to enter anything, use the Down Arrow instead.
Start a new line inside the same cell. Double-click the cell, or select it and press F2 to edit its contents. Place the insertion point where the new line should begin, then press Alt+Enter. Type the next part of the text. Press Enter when you have finished editing the cell. The line break stays within that cell; it does not move the selection to the cell below. If the full text is not visible, select Home > Wrap Text or adjust the row height.
Insert blank cells and shift existing cells down. Select the cell or range where the blank space should be created. On the ribbon, choose Home > Insert > Insert Cells. In the dialog box, choose Shift cells down, then select OK. Excel moves the selected cells and the cells below them down to make room. Use this when only part of a worksheet needs to shift and the neighboring columns should remain where they are. Check the surrounding rows afterward to confirm that related values still line up.
Insert a complete worksheet row. If the new space must extend across the entire worksheet, click the row number at the left edge where the blank row should appear. Choose Home > Insert > Insert Sheet Rows. Excel adds a row above the selected row and shifts existing rows down. To insert several rows at once, select the same number of row headers first, then use Insert Sheet Rows. For example, selecting three row headers inserts three blank rows above the first selected row. Do not select only one cell if you intend to move complete records across many columns.
Move existing contents down rather than creating blanks. If you need to relocate a cell or range, select it and press Ctrl+X. Right-click the cell where the moved content should be inserted, choose Insert Cut Cells, and select Shift cells down if Excel asks how to position them. This inserts the cut cells at the destination and shifts other cells to make room. For an entire record, select its row header before cutting, then use the row-header destination so the record stays together. Avoid pasting over a destination cell when the existing content must be preserved.
Change where Enter moves the selection. If Enter is moving right, up, or nowhere instead of down, open File > Options > Advanced. Under Editing options, find After pressing Enter, move selection. Turn the setting on and choose Down from the Direction list, then select OK. This changes the Enter-key behavior for Excel, not the contents of the active cell. You can still use the arrow keys to navigate in any direction.

Common Mistakes

Confusing a new worksheet row with a new line inside a cell. Enter normally commits an edit and moves the selection. Alt+Enter puts a line break in the cell being edited. If your text has to appear on two lines in one cell, do not insert a worksheet row; if you need a new record, do not add a text line break.

Using the Down Arrow while still editing. When the cell is in edit mode, the arrow keys may move the text cursor rather than the selection. Press Enter to keep the edit or Esc to cancel it, then press the arrow key. Look at the cell border: if the cell remains in edit mode, navigation has not happened yet.

Inserting cells where a whole row is needed. Shift cells down affects only the selected area and can leave adjacent columns out of alignment. For a table of related records, insert a complete sheet row or use the table’s row-insertion options instead.

Overwriting data when trying to move it. A normal paste can replace whatever is already in the destination. Use Insert Cut Cells when the existing cells need to shift out of the way. Before confirming, check the destination and nearby formulas, especially in a shared or formatted worksheet.

Expecting Enter to add a line of text. In a cell, Enter usually confirms the edit and selects another cell. To keep typing in the same cell on a separate line, use Alt+Enter while editing, then make sure Wrap Text is enabled if the full content is not shown.

Tips

Use Enter after typing down a column and Tab after typing across a row. This makes data entry more predictable.
Shift+Enter commits an entry and typically moves the selection up one cell. If your Enter direction has been customized, check File > Options > Advanced before relying on it.
Ctrl+Down is useful for jumping through a column’s data, but it does not move down by just one cell. It jumps to the edge of a continuous data region, or toward the next relevant region when the current cell is blank. Use the Down Arrow for a single-cell move.
For multi-line text, turn on Home > Wrap Text. You may need to increase the row height or use Home > Format > AutoFit Row Height so all lines show.
When you insert rows in a formatted Excel table, use the table’s row controls or right-click a table row and choose Insert. Table behavior can differ from inserting a normal worksheet row, so confirm that the new row remains part of the table and inherits its formatting.
On a Mac, Return generally commits an entry and moves the selection according to the workbook’s direction setting. The shortcut for a line break inside a cell is Control+Option+Return in current Excel for Mac; keyboard layouts and versions may vary. In Excel for the web, use Alt+Enter for a cell line break if supported by your browser and keyboard. If a shortcut is intercepted, use the desktop app or check the keyboard-shortcut help for your version.

Troubleshooting

Enter moves in the wrong direction. In Windows desktop Excel, go to File > Options > Advanced and review After pressing Enter, move selection and its Direction setting. Choose Down if you want the selection to move down after committing entries. If the option is off, Enter may leave the selection in place.

The selection does not move when you press an arrow key. You may still be editing a cell, or the worksheet may be protected. Press Enter or Esc to leave edit mode. If the sheet is protected and selection is restricted, ask the workbook owner to change the protection settings or provide an unlocked area where you can work.

The line break appears but the second line is hidden. Select the cell and choose Home > Wrap Text. If the row still clips the text, use Home > Format > AutoFit Row Height, or drag the row boundary downward. A manually fixed row height can prevent automatic display of all lines.

Insert Cells is unavailable or behaves unexpectedly. Check whether the worksheet is protected, whether you are editing a cell, or whether the selection is inside a structured table. Finish editing first, and review the table’s context-menu insert options. If a protected sheet or workbook policy prevents insertion, you may need permission from its owner.

Rows or formulas look misaligned after an insertion. Undo immediately with Ctrl+Z if the change is still the latest action and no later edits need to be kept. Otherwise, inspect the affected columns and formulas carefully, or restore the saved copy. Before a large change, inserting a full row is usually safer than shifting a partial block when each row represents one complete record.

Frequently Asked Questions

How do I move down one cell without changing anything?
Press the Down Arrow after leaving edit mode. This changes the active selection only; it does not move cell contents.

How do I move down after typing a value?
Type the value and press Enter. Excel normally commits it and selects the cell below. If it moves in another direction, check the Enter setting under File > Options > Advanced.

How do I go to the next line without leaving the cell?
Edit the cell, place the cursor where the next line should start, and press Alt+Enter on Windows. On current Excel for Mac, use Control+Option+Return. Turn on Wrap Text if the lines are not all visible.

How can I add a blank row between existing rows?
Select the row header immediately below where you want the blank row, then choose Home > Insert > Insert Sheet Rows. The new row appears above the selected row, pushing existing rows down.

Can I move only some cells down?
Yes. Select the cells where the gap should be made, choose Home > Insert > Insert Cells, and select Shift cells down. Use this only when shifting those cells will not break the alignment of related data in nearby columns.

Why does pressing Enter not move down?
The selection direction may be set differently, or the option to move the selection after Enter may be off. In Windows desktop Excel, check File > Options > Advanced. Also confirm that you are not still editing the cell.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.