In Excel for Microsoft 365 on Windows, press Ctrl+Home to jump to the beginning of the worksheet, normally cell A1. If you mean the top of the current block of data in a column, press Ctrl+Up Arrow instead.
The shortcut for the top of a worksheet
Ctrl+Home is the direct shortcut for returning to the worksheet’s starting point. It selects A1 and normally scrolls the sheet so its upper-left corner is in view. This is useful after scrolling far down or across a large worksheet, and it does not depend on the worksheet having a continuous block of data.
The word “top” can mean different things in a spreadsheet. It might mean the first cell in the entire worksheet, the first filled cell in a column, or simply the top edge of the visible screen. Excel has different ways to handle those tasks. For a full return to the worksheet’s beginning, use Ctrl+Home; for movement within a column’s data, use Ctrl+Up Arrow.
- Go to the worksheet beginning: Ctrl+Home.
- Move upward through a column’s data: Ctrl+Up Arrow.
- Go to a particular address: Ctrl+G, enter a cell reference such as A1, and press Enter.
How Ctrl+Home differs from Ctrl+Up Arrow
Ctrl+Home targets the beginning of the worksheet, not the beginning of the data block around the active cell. It is predictable even when the current selection is in a distant column or row: the destination is A1. That makes it the better choice when you want to reset your position in the sheet.
Ctrl+Up Arrow is contextual. It moves upward to the edge of the current region of data in the active column. For example, if B2 through B25 contain uninterrupted entries and B25 is selected, Ctrl+Up Arrow moves to B2. If there is a blank at B10, the blank divides the run: starting at B25, the shortcut can stop at B11, and another press can move to the next boundary above. The exact destination depends on which cells are filled and where the selection starts.
This distinction explains a common surprise: Ctrl+Up Arrow does not always go to row 1. It is designed for navigating data boundaries, so it may stop at a filled cell below the top of the worksheet. Ctrl+Home is the appropriate shortcut when row 1, column A is the destination.
Using the shortcut step by step
- Click a cell in the worksheet, or use the arrow keys to make the worksheet grid active.
- Press and hold Ctrl, then press Home.
- Confirm that A1 is selected. If the worksheet has frozen panes, the frozen section stays in place while the selection moves.
If Excel is currently editing a cell, first decide whether to keep the edit. Press Enter to commit it or Esc to cancel it, then use Ctrl+Home. While a cell is in edit mode, keystrokes can act on the text or formula being edited instead of navigating around the worksheet.
You do not need to select the first column or scroll manually before using the shortcut. It works from a cell anywhere on the sheet. If the shortcut appears to do nothing, check whether Excel has focus, whether a cell is being edited, and whether a dialog or another window is active.
What happens with frozen panes and hidden rows
Freeze Panes keeps designated rows or columns visible while you scroll. Ctrl+Home still takes the selection to A1, but the frozen area does not move like the scrollable part of the sheet. If the top row or first column is frozen, that area remains visible as Excel navigates. This can make the screen’s movement look different from a sheet with no frozen panes, even though the shortcut’s destination is still the worksheet’s beginning.
Hidden rows and columns also affect what you see, not the basic purpose of the shortcut. If row 1 or column A is hidden, the selected cell may not look like the first visible cell on screen. A filter can hide data rows as well. In those cases, distinguish the active cell address from the first row or column currently displayed; Excel’s Name Box, to the left of the formula bar, shows the selected cell reference.
For example, if a worksheet has frozen header rows and the active cell is far down in the data, Ctrl+Home returns the selection to A1 while preserving the frozen headers. It does not remove filters, unhide rows, or change the worksheet’s freeze settings.
Windows, Mac, and Excel for the web
On Excel for Microsoft 365 for Windows, the shortcut is Ctrl+Home. On Excel for Mac, Microsoft’s shortcut is also Control+Home. Some Mac keyboards do not have a dedicated Home key; on many MacBook keyboards, use Fn+Control+Left Arrow to produce the equivalent beginning-of-worksheet navigation. Keyboard layouts and system settings can affect how the Home key is available.
Excel for the web also supports Ctrl+Home when the worksheet grid has focus. A browser may use some keyboard shortcuts for its own controls, so if the sheet does not respond, click a worksheet cell and try again. The exact behavior can also depend on the browser and keyboard. The Go To command is a practical alternative in the web app: use Ctrl+G, enter A1, and confirm.
On a Mac, use Control rather than assuming that the Command key is interchangeable. Excel uses different modifier keys for different commands; Command+Home is not the standard Windows shortcut merely translated to a Mac keyboard.
Other ways to return to A1
The keyboard shortcut is usually quickest, but other navigation methods can help when a key is missing, a shortcut is intercepted, or you need to go somewhere other than the top-left cell.
- Go To: Press Ctrl+G, type A1 in the Reference box, and press Enter. You can enter another address, such as D250, to jump directly there.
- Name Box: Click the Name Box beside the formula bar, type A1, and press Enter. This is convenient when you can see the box but cannot use the shortcut.
- Scroll bars: Drag the vertical and horizontal scroll bars toward their upper or left ends. This changes the view, but it may not move the active selection to A1.
- Worksheet navigation: If you have multiple sheets, first activate the intended sheet using its tab. Ctrl+Home then goes to the beginning of that active worksheet, not to a different sheet.
Using Go To or the Name Box is also more explicit when you want a specific cell rather than a general destination. A1 is the top-left cell, but an imported report may have its actual headings in row 4 or column B. In that case, enter the heading cell’s address instead of assuming the data begins at A1.
Common reasons the shortcut seems not to work
Most problems come from focus or from expecting a different kind of movement. Check these points before changing Excel settings:
- A cell is being edited: Finish or cancel the edit with Enter or Esc, then try the shortcut.
- The worksheet is not active: Click a cell in the grid. A selected chart, dialog box, formula bar, or browser control may receive the keystroke instead.
- You expected the top of a data block: Ctrl+Home goes to the sheet beginning. Use Ctrl+Up Arrow for movement to a data boundary.
- You expected only the screen to scroll: Ctrl+Home changes the active selection as well as moving the view. To scroll without deliberately selecting A1, use the scroll bar or mouse wheel.
- The visible area looks unchanged: Frozen panes or hidden rows and columns can keep parts of the worksheet in place or conceal the destination. Check the active address in the Name Box.
- You are using a compact keyboard: Try the keyboard’s Fn combination for Home, or use Ctrl+G and enter A1.
Scroll Lock is often blamed when worksheet navigation feels unusual. It changes how arrow keys behave in Excel, making them scroll the worksheet rather than move the active cell. If arrow keys are scrolling, turn off Scroll Lock using the keyboard’s Scroll Lock key or the available on-screen keyboard controls. Ctrl+Home is still the direct command for returning to the worksheet beginning; the Scroll Lock issue is especially relevant when using the arrows.
Frequently Asked Questions
What is the Excel shortcut to go to cell A1?
Press Ctrl+Home on Windows. In Excel for Mac, use Control+Home, or Fn+Control+Left Arrow on many MacBook keyboards without a dedicated Home key.
How do I jump to the top of a column in Excel?
Press Ctrl+Up Arrow to move to an edge of the current data region in that column. If your goal is specifically to select A1 regardless of the data layout, use Ctrl+Home.
Does Ctrl+Home go to the first sheet in a workbook?
No. It goes to the beginning of the active worksheet. Select the sheet tab you want first if you need to navigate within another worksheet.
Why does Ctrl+Home not seem to move the screen?
The worksheet may have frozen panes, the destination may be hidden, or Excel may not have focus. Check the selected address in the Name Box and click a worksheet cell before trying again.
Can I jump to the top without using the Home key?
Yes. Press Ctrl+G, enter A1, and press Enter, or type A1 in the Name Box and confirm. These methods also let you jump directly to a different cell.
Is Ctrl+Up the same as Ctrl+Home?
No. Ctrl+Up Arrow navigates to a data-region boundary in the current column and can stop below row 1. Ctrl+Home returns to the beginning of the worksheet, normally A1.
Related
- Excel Turn Off Circular Reference Warning?
- Excel Circular Reference Warning: Causes and Fixes
- Absolute Reference in Excel Without F4: Manual Methods
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Freeze Multiple Columns in Excel: A Step-by-Step GuideTo freeze multiple columns in Excel for Microsoft 365 on Windows, select the cell immediately to the right…
- Excel Subtotal Rows in Color: How to Highlight ThemTo color subtotal rows in Excel, use conditional formatting with a rule that recognizes each subtotal row, then…
- Excel Hyperlink Shortcut: How to Add a LinkTo add a hyperlink in Excel for Microsoft 365 on Windows, select a cell and press Ctrl+K. Choose…
- Combine Cells in Excel on a New Line with CHAR(10)To combine values from A2 and B2 in one cell with a line break between them, enter =A2&CHAR(10)&B2…
- Calculate Age in Excel From a Birth Date, Step by StepTo calculate someone’s age in completed years in Excel, put their birth date in A2 and enter =DATEDIF(A2,TODAY(),"Y")…
- Excel Cell Size in CM: What the Measurements MeanExcel does not give every cell a single size in centimeters. A cell’s width comes from its column-width…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.