To select cells in Excel without dragging the scrollbar, type a cell reference or range into the Name Box and press Enter. You can also press Ctrl+G or F5 to open Go To, or use keyboard shortcuts such as Ctrl+Shift+Arrow to select a block of data. These methods jump directly to distant cells and ranges in Excel for Microsoft 365 on Windows.
They are useful when a worksheet has thousands of rows, when you need to highlight an exact range, or when scrolling would make it easy to lose your place. The selection does not change or move any data; it simply marks the cells so you can format, copy, edit, or inspect them.
What You’ll Need
- A workbook open in Excel for Microsoft 365. The steps below are for Windows; the Name Box and Go To work on Mac and Excel for the web too.
- The cell address or range you want to select, if you know it. For example, A500 identifies one cell and A2:D500 identifies a rectangular range.
- If you plan to use keyboard shortcuts, click a worksheet cell first so Excel receives the keystrokes.
Step-by-Step
- Select a specific cell with the Name Box. Find the Name Box at the left end of the formula bar, above the worksheet grid. It normally displays the address of the active cell, such as A1. Click inside it, type the address you want, such as G850, and press Enter. Excel moves the active cell to G850 and brings it into view; you do not need to scroll there manually. If you cannot see the Name Box, check that the formula bar is shown using View > Show > Formula Bar.
- Select an exact range with the Name Box. Click the Name Box, type the first and last cell separated by a colon, and press Enter. For example, entering B3:F75 selects every cell in that rectangle, including its interior cells. The range can be much larger than the visible area. You can also enter a whole-column reference such as C:C or a whole-row reference such as 12:12 when you want to select an entire worksheet column or row.
- Use Go To when you want a dialog box. Press Ctrl+G or F5 on Windows to open the Go To dialog. Type a reference such as M1200, or a range such as A10:C40, in the Reference field, then press Enter or choose OK. Excel selects the specified cells and moves the view to show the selection. Go To is particularly handy when you are already working with the keyboard or want to select a distant range without replacing the current entry in the Name Box.
- Jump to a cell and extend the selection. First use the Name Box or Go To to move to the starting cell. Then hold Ctrl and press an arrow key to jump to the edge of the adjacent block of nonblank cells in that direction. To select cells while making the jump, hold Ctrl+Shift and press the arrow key. For example, if A2:A300 contains uninterrupted entries, click A2 and press Ctrl+Shift+Down to select through the bottom of that block. This shortcut follows the data boundary; it does not always select to the last row of the worksheet.
- Select from the active cell to the last used cell. Press Ctrl+Shift+End to extend the selection from the active cell to Excel’s last used cell on the worksheet. This is useful for selecting a large used area, but the last used cell may be farther down or to the right than your actual data because of old formatting or previously entered content. If you need an exact rectangle, enter its addresses in the Name Box instead.
- Select a whole row or column. Click any cell in the row and press Shift+Space to select the entire row. Click a cell in a column and press Ctrl+Space to select that entire column. You can also enter a row or column reference in the Name Box, such as 20:20 or D:D. These methods select the complete worksheet row or column, not only the cells currently visible on screen.
- Select a nearby data block without scrolling. Click a cell inside a contiguous block of data and press Ctrl+A to select the current region around that cell. A current region is a rectangle of cells bounded by blank rows or columns. If you are inside an Excel table, Ctrl+A may select table portions in stages, so check the highlighted area before copying or applying changes. Use a typed range when you need a specific, predictable boundary.
- Check the selection before you act. Look at the highlighted cells and the Name Box before deleting, pasting, filling, or formatting. A single-cell reference should show one active cell; a range reference should highlight the intended rectangle. For a large selection, use the worksheet’s row and column headings to confirm its edges. If it is wrong, press Esc or click elsewhere and enter the correct reference.
On Mac, the Name Box and Go To are reliable alternatives to scrolling; Control+G opens Go To in Excel for Mac, though function-key behavior can depend on your keyboard settings. Many selection shortcuts use the same Control-based keys, but macOS settings or a laptop’s function-key configuration can affect them. Excel for the web also supports the Name Box and Go To, although some keyboard shortcuts may be intercepted by the browser. When a shortcut does not work, use the Name Box or the Go To command from Excel’s interface.
Common Mistakes
- Typing a reference into a worksheet cell. If you type A500 while a cell is active, Excel may enter that text into the cell instead of navigating. Click the Name Box first, or open Go To with Ctrl+G.
- Using the wrong separator. A range uses a colon, as in A1:D20. A comma separates separate references in some Go To entries, but it does not mean the same thing as one continuous rectangular range. If you need one block, enter its top-left and bottom-right cells with a colon.
- Assuming Ctrl+Shift+Arrow always reaches the worksheet edge. It usually stops at the edge of a continuous run of data, or jumps to another boundary when there are blanks. Use an explicit reference if the exact endpoint matters.
- Confusing a selection with a scroll position. Excel can move the view to display the active cell while leaving the rest of the worksheet unchanged. Selecting a range does not automatically copy, delete, or format it.
- Including more cells than intended. Ctrl+Shift+End can include cells affected by old formatting or past edits. Confirm the selection, or use the Name Box to define a smaller range.
Tips
- Use the Name Box for exact work. It is usually the quickest choice when you know the address, especially for ranges that cross many screens. It also avoids uncertainty about blank rows or columns.
- Use Go To for repeated jumps. Press Ctrl+G, enter a cell or range, and confirm. Go To can also list named ranges and previously used references in the dialog, which can save typing during repeated navigation.
- Name important areas. If you regularly select the same range, select it once and enter a descriptive name in the Name Box, then press Enter. Later, type that name into the Name Box and press Enter to return to the named cells. Choose a name that follows Excel’s naming rules and does not look like a cell address.
- Use the Name Box with whole columns carefully. Selecting D:D highlights over a million cells. That can be appropriate for setting a column-wide format, but copying or processing a full column may take longer than working with the data rows only.
- Keep the active cell in mind. Shift-based shortcuts extend from the active cell, which may not be the corner you expect after a previous selection. Click the intended starting cell before using Ctrl+Shift+Arrow or Ctrl+Shift+End.
- Separate navigation from editing. If you are in the middle of editing a cell, press Enter or Esc first. Otherwise, a shortcut may affect the text being edited instead of selecting worksheet cells.
Troubleshooting
The Name Box is missing. In Excel for Windows, open View and, in the Show group, enable Formula Bar. The Name Box appears beside the formula bar when that bar is displayed. If the ribbon is collapsed, expand it or use the View tab to find the setting.
Excel selects the wrong range or does not move. Check that the reference has no accidental spaces or typos, and that the range uses a colon between its endpoints. Click the Name Box, replace its contents completely, and press Enter. For a named range, confirm that the name exists and is spelled correctly; if Excel does not recognize it, use cell addresses instead.
Ctrl+Shift+Arrow stops too early. Look for blank cells in the column or row: a blank can divide the data into separate blocks. If blanks are intentional, select the exact start and end addresses through the Name Box or Go To. If the shortcut stops at an unexpected distant boundary, check for additional data farther along the row or column.
Ctrl+Shift+End selects too much. Excel’s used range can include cells that once held content or still have formatting. Avoid using this shortcut for an exact data-only selection. Enter the correct final row and column in the Name Box, and, if appropriate, remove unwanted formatting or content from unused cells before saving the workbook.
A keyboard shortcut does nothing. Click a worksheet cell and make sure you are not editing a cell or a text box. On laptops, try the function-key combination your keyboard requires if using F5. In Excel for the web, a browser may intercept some keys; use the Name Box, or choose the available Go To command in Excel’s interface.
Frequently Asked Questions
How do I select a faraway cell without scrolling?
Click the Name Box, type its address, such as X1200, and press Enter. Ctrl+G or F5 followed by the same reference also works in Excel for Windows.
How do I select a large range quickly?
Enter the range in the Name Box, such as A2:H900, and press Enter. This is more precise than dragging across the worksheet and works even when most of the range is off screen.
Can I select non-adjacent cells without scrolling?
Yes. In Go To, enter separate cell or range references separated by commas, such as A1,A5,C10, and confirm. Excel selects the separate areas. You can also hold Ctrl while clicking visible cells, but Go To is more practical when they are far apart.
What is the difference between Ctrl+G and Ctrl+Shift+Arrow?
Ctrl+G opens Go To so you can enter an exact address. Ctrl+Shift+Arrow extends a selection from the active cell to a data boundary, so its endpoint depends on the contents and blank cells in the worksheet.
Can I select a whole worksheet without scrolling?
Yes. Click the Select All button at the top-left corner where the row and column headings meet, or press Ctrl+A when Excel is not editing a cell. If you are in a data region or table, Ctrl+A may select that region first; press it again if you intend to select the whole sheet, and verify the highlighted area.
Do these methods work in Excel for Mac and the web?
The Name Box and Go To are available in both. On Mac, Control+G opens Go To; function keys and some shortcuts can vary with keyboard settings. In a web browser, the browser may use a shortcut before Excel does, so use the Name Box when a key combination is intercepted.
Related
- Repair Excel in Windows 11: Practical Fixes and Steps
- How to Replace a Picture in an Excel Header
- How to Repair an Excel File in Windows 11
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Double Space a Paper in Word on Windows and MacTo double space a paper in Microsoft Word, select the text you want to change, then choose Home…
- Outlook Signature: Create and Set Up an Email Sign-offTo create an email signature in Outlook, open the signature settings for your version, make a new signature,…
- Excel Group Rows Together for Sorting: What Actually WorksTo keep related rows together when sorting in Excel, give every row in a group the same value…
- Excel Date as Number: Excel Serial Dates ExplainedYes. Excel stores dates as serial numbers: the whole-number part counts days, and any decimal part represents a…
- Making a Template in Word: Steps, Styles, and SetupTo make a template in Microsoft Word for Microsoft 365 on Windows, create or open a document with…
- Excel Column Grouping: How to Collapse ColumnsTo group columns in Excel for Microsoft 365 on Windows, select the column letters you want to fold…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.