To jump to a specific row in Excel for Microsoft 365 on Windows, press Ctrl+G, type a cell reference in that row such as A5000, and press Enter. You can also click the Name Box to the left of the formula bar, enter A5000, and press Enter; Excel selects that cell and scrolls the worksheet to row 5000.
What Excel Means by Jumping to a Row
Excel navigation works with cell references, which combine a column letter and a row number. The reference A5000 means column A, row 5000. Excel does not need data in that cell to navigate there: you can jump to an empty cell just as easily as to one containing a value. The row headings along the worksheet’s left edge show the row numbers, and the active cell’s row heading is highlighted when you arrive.
This distinction matters because a row number is a position in the worksheet, not necessarily a record number in your data. If you sort a list, insert rows, or delete rows, the information associated with a particular row can move. If you need to find a particular customer or transaction, use a stable identifier or search for its contents rather than assuming it will always remain on the same numbered row.
A worksheet can contain up to 1,048,576 rows. That makes direct navigation useful in large sheets, but it does not mean every row contains data. A jump to row 5000 changes the active position; it does not add rows or fill gaps.
Use Go To for a Direct Jump
The Go To dialog is a reliable way to enter a destination without scrolling. In Excel for Windows, press Ctrl+G or F5 to open it. Type a cell reference such as A5000 in the Reference box, then press Enter or select OK. Excel closes the dialog, selects the cell, and brings it into view.
- Click anywhere in the worksheet you want to navigate.
- Press Ctrl+G. F5 opens the same Go To dialog in Excel for Windows.
- Enter a cell address in the target row, for example
D25000. - Press Enter. The active cell is now D25000, on row 25000.
You can choose any column in the target row. Entering A25000 is a convenient convention because column A is easy to recognize, but it is not required. If your data starts in column C, you could enter C25000 instead. For a destination on another worksheet, use a sheet-qualified reference such as Summary!A500. If the sheet name contains a space, put it in single quotation marks: 'Quarter 1'!A500.
Go To is especially helpful when you know the exact row number, are far from the destination, or need to navigate to a cell on another sheet. It selects a cell, not just a row heading. If you want to select the entire row, use the row-selection method below.
Jump with the Name Box
The Name Box sits at the left end of the formula bar and usually displays the active cell address, such as A1. Click inside it, replace the displayed address with the destination, and press Enter. Typing G12000 selects cell G12000 and moves the view to row 12000. This method is quick because it avoids opening a dialog and is convenient when the Name Box is already visible.
Take care to press Enter after typing. Until you confirm the reference, you are editing the Name Box rather than moving the active cell. If the box is difficult to locate, look directly above the worksheet grid, to the left of the formula bar. The Name Box may be narrow, but you can click in it and type a longer address.
You can also enter a row range such as 12000:12000 in the Name Box to select the entire worksheet row. For everyday navigation, a single-cell reference is usually clearer: selecting A12000 gets you to the row without selecting more than a million cells across it.
Select the Whole Row Instead of One Cell
If your next task is to format, copy, clear, or inspect every cell in a row, select the row itself. One option is to enter a row range such as 12000:12000 in the Name Box and press Enter. Another is to jump to a cell in the row, then click its row heading at the left of the grid. The row heading is the numbered box beside the cells.
In Excel for Windows, you can also select the active cell’s entire row with Shift+Space. For example, first jump to B12000, then press Shift+Space to select row 12000. On a Mac, the equivalent is generally Shift+Space as well; if the shortcut is intercepted by macOS or a keyboard setting, use the row heading or Name Box instead. A full-row selection can affect cells far beyond the visible data, so check that you truly intend to format or edit the entire worksheet row.
To select several consecutive rows, enter a range such as 12000:12005 in the Name Box. That selects rows 12000 through 12005. It is different from entering A12000:A12005, which selects only six cells in column A.
When You Do Not Know the Exact Row
If you know a word, number, or phrase in the target row but not its row number, use Find rather than guessing. Press Ctrl+F on Windows, enter the text, and choose the relevant search result or use Find Next. After Excel selects a matching cell, its row number is visible in the row heading and in the cell reference shown in the Name Box. If there are several matches, continue through them until you reach the right record.
For a large structured list, filters can be more useful than direct row navigation. Select a cell in the list and use Data > Filter to show records matching a column value. Sorting or filtering helps locate a record by its meaning; Go To helps you reach a known physical position. These solve different problems.
Keyboard navigation can also help when the destination is near the current cell. On Windows, Ctrl+Up Arrow or Ctrl+Down Arrow moves between the edges of data regions in the current column. It does not mean jump to the previous or next numbered row, and blank cells can change where it stops. Use Go To or the Name Box when you need an exact row number.
Hidden Rows, Filters, and Frozen Panes
A direct reference can point to a row that is hidden manually or hidden by a filter. Excel may select the referenced cell, but the row’s contents will not appear in the grid while it remains hidden. Clear the filter or unhide the row if you need to see it. A row number missing from the headings is a clue that one or more rows are hidden; filtered lists can also leave gaps in the visible row numbers.
Worksheet row numbers always describe worksheet positions. Filtering does not renumber visible records from 1 onward. For example, if the visible headings show rows 12, 19, and 35, those records are still on worksheet rows 12, 19, and 35. A jump to row 19 refers to physical row 19, whether or not a filter is active.
Freeze Panes can make a jump look as if it did not work because a frozen area stays in place while the scrollable part moves. Check which pane contains the selected cell, and look for the highlighted row heading. You can temporarily remove the freeze using View > Freeze Panes > Unfreeze Panes if the layout is confusing. The active-cell reference in the Name Box is another way to confirm your destination.
Excel for Mac and Excel for the Web
In Excel for Mac, the Name Box method works the same way: enter a reference such as A5000 and press Return. The Go To shortcut is commonly Control+G; keyboard mappings and function-key settings can vary, so use the Name Box if the shortcut does not open the dialog. On some Mac keyboards, function keys may require the Fn key. The Windows shortcut Ctrl+G should not be assumed to work identically on a Mac.
In Excel for the web, click the Name Box above the grid, enter the destination reference, and press Enter. This is a dependable option when browser shortcuts conflict with Excel shortcuts. The exact placement of controls can vary with the browser window size, but the Name Box is associated with the formula bar above the worksheet.
Go To, the Name Box, and worksheet row headings all navigate within the workbook; none of these methods changes the contents of a cell. If you are working in a shared workbook, a navigation action changes your current selection, not the worksheet for other people.
Common Mistakes and Quick Fixes
- Entering only a row number: A cell reference such as A5000 is the simplest target. If you want the full row, use the explicit range 5000:5000 in the Name Box.
- Typing in the grid instead of the Name Box: Clicking a cell and typing A5000 replaces or edits that cell’s contents. Click the Name Box or open Go To before entering the reference.
- Using the wrong sheet: Go To works in the active workbook, but confirm the destination sheet. Include a sheet name in the reference when appropriate, for example ‘Sales Data’!A500.
- Expecting Ctrl+Down to reach a specific number: That shortcut follows data-region boundaries, so it may stop at a blank or skip to a distant block. Use a direct address for an exact destination.
- Thinking the data vanished: The target row may be hidden, filtered out, or outside the scrollable pane. Check filters, hidden row headings, and frozen panes before assuming the reference is wrong.
Also check that the address is valid for the worksheet. A row number above 1,048,576 is outside Excel’s worksheet limit. If a workbook contains multiple sheets, confirm the active sheet or explicitly specify the sheet in the reference. These checks usually resolve the problem without needing to scroll manually.
Frequently Asked Questions
What is the fastest way to go to row 1000 in Excel?
Press Ctrl+G in Excel for Windows, type A1000, and press Enter. You can also type A1000 in the Name Box and press Enter.
Can I jump to a row without choosing a column?
To select the whole row, enter a range such as 1000:1000 in the Name Box. To navigate without selecting the whole row, use a cell address such as A1000.
How do I jump to a row on another worksheet?
Use a sheet-qualified reference in Go To or the Name Box, such as Summary!A500. If the sheet name contains spaces, wrap it in single quotation marks, as in ‘Quarter 1’!A500.
Why does Excel not show the row after I jump to it?
The row may be hidden or excluded by a filter, or it may be in a pane affected by Freeze Panes. Check the row headings, clear relevant filters, or unfreeze panes to inspect the area.
Does Ctrl+Down Arrow jump to a particular row number?
No. It moves to the edge of a data region, and blank cells affect where it stops. For a precise destination, enter a cell reference such as A25000 using Go To or the Name Box.
Related
- How to Ungroup Excel Windows on the Windows 11 Taskbar
- How to Ungroup Rows in Excel With a Keyboard Shortcut
- How to Undo in Excel With a Keyboard Shortcut on Windows
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Merge Cells and Keep All Text Without Data LossExcel’s Merge Cells command does not combine the contents of multiple cells: it keeps the value in the…
- Excel Find and Replace: Search and Edit CellsIn Excel for Microsoft 365 on Windows, open Find and Replace with Ctrl+H, enter the text to look…
- How to Insert an Image in an Excel Cell CommentTo put a picture in an Excel cell comment, create a legacy note, right-click its border, open its…
- Freeze Panes in Excel Online: Keep Rows and ColumnsTo freeze panes in Excel Online, select the cell just below the row or rows and just to…
- A0 Poster in PowerPoint: Set Up and Print at Full SizeTo make an A0 poster in PowerPoint, set the slide to 84.1 cm wide by 118.9 cm high…
- Excel Data Analysis ANOVA: Run and Interpret TestsTo run an ANOVA in Microsoft Excel for Microsoft 365 on Windows, enable the Analysis ToolPak, select Data…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.