The simplest way to move down one row

Press the Down arrow key on your keyboard. Your cursor moves to the cell directly below. That is the fastest method for moving down a single row, and it works in every version of Excel.

If you are working with a mouse, you can also click the cell below your current position. Both methods do the same thing — they move your active cell down one row while keeping you in the same column.

Key Takeaways

  • The Down arrow key moves your cursor down one row at a time, and works in every version of Excel.
  • Pressing Ctrl+Down jumps to the last filled cell in a column, which saves time when you have many rows of data.
  • Pressing Enter moves down one row and is useful when you are entering data across multiple cells in the same column.
  • Page Down moves down ten to twenty rows depending on your screen size, helpful for scrolling through large spreadsheets without changing which column you are in.

Moving down multiple rows at once

If you need to jump several rows down without stopping at each one, hold Ctrl and press Down. Excel skips to the last cell with data in that column, or to the bottom of the spreadsheet if the column is empty. This is much faster than pressing the Down arrow key ten or twenty times.

For example, if you have data in cells A1 through A50, pressing Ctrl+Down from A1 takes you straight to A50. If you press it again from A50, it jumps to the very bottom of the spreadsheet (row 1,048,576 in modern Excel). This command is especially useful when you are working with large datasets and need to navigate quickly.

Using Enter to move down while entering data

When you are typing data into cells, pressing Enter moves you down one row automatically. This is the standard way to enter information into a column — type your data, press Enter, and your cursor lands in the cell below, ready for the next entry.

You can change this behavior in Excel settings if you prefer. Go to File, then Options, then Advanced. Look for "After pressing Enter, move selection" and choose which direction you want (down, up, left, or right). Most people leave it set to down because it matches how we read — top to bottom.

Scrolling down without changing your active cell

Sometimes you want to see rows below without actually moving your cursor. Press Page Down to scroll down ten to twenty rows (the exact number depends on your screen size and zoom level). Your active cell stays where it is — you are just viewing a different part of the spreadsheet.

This is different from the Down arrow key, which moves your cursor. Page Down is useful when you want to look at data further down the sheet but keep working in your current location. You can also use the scroll wheel on your mouse to move down without changing which cell is active.

Moving down in filtered or hidden rows

If your spreadsheet has hidden rows or filtered data, the Down arrow key still moves down one row — but it skips the hidden rows and only lands on visible cells. This is usually what you want, because hidden rows are typically hidden for a reason and you do not need to interact with them.

If you want to move down and include hidden rows, you have to unhide them first. Right-click on the row numbers on the left side of the spreadsheet, select "Unhide", and choose which rows to show. After that, the Down arrow key will move through all rows, hidden or not.

Using Go To for jumping to a specific row

If you know exactly which row you want to reach, use the Go To feature. Press Ctrl+G (or F5 in some versions), and a dialog box opens. Type the cell address — for example, A100 — and press Enter. Excel takes you directly to that cell.

This is faster than scrolling or pressing Down repeatedly when you need to jump to a row far away. You can also use the Name Box (the field that shows your current cell address, usually in the top left) to type a cell address and press Enter to go there when ready.

Moving down in merged cells

Merged cells — cells that span multiple rows or columns — behave differently. When you press the Down arrow key on a merged cell, you move to the first cell below the merged area, not to the next row. This can feel unexpected if you are not used to it.

If merged cells are causing confusion in your workflow, consider unmerging them. Select the merged cell, go to the Home tab, find the Merge & Center button, and click it to unmerge. After that, the Down arrow key behaves predictably again, moving one row at a time.

Frequently Asked Questions

What is the difference between Down arrow and Enter?

The Down arrow key moves your cursor down one row without changing anything in the cell. Enter moves down one row but also confirms whatever you typed in the current cell. Use Down arrow when you are navigating; use Enter when you are entering data.

How do I move down without using the keyboard?

Click the cell below your current position with your mouse. You can also use the scroll wheel to view lower rows, then click the cell you want. For jumping many rows at once, the Go To feature (Ctrl+G) is faster than scrolling.

Why does Ctrl+Down sometimes take me to the bottom of the spreadsheet?

Ctrl+Down jumps to the last filled cell in your column. If the column is empty below your current position, it skips all the way to the bottom. If you have gaps in your data (empty rows between filled rows), Ctrl+Down stops at the first gap, not at the end of your data.

Can I move down multiple rows at once without using Ctrl?

Yes. Click a cell, then hold Shift and click a cell further down. This selects all rows between them. You can also click a cell and drag down to select multiple rows, then press Down arrow to move the selection down together.

What happens if I press Down arrow at the very bottom row?

Nothing. Your cursor stays in the last row (row 1,048,576). Excel does not wrap around to the top. If you want to go back to the beginning of your data, press Ctrl+Home to jump to cell A1.