How to Press Control Home on Excel
Ctrl+Home jumps the active cell straight to A1, the top-left corner of the worksheet, no matter how far you have scrolled. If you have frozen panes, it instead lands on the first cell of the scrollable area below and to the right of the frozen rows and columns.
If you are looking to navigate quickly through a worksheet in Excel, using the Control Home shortcut key might be the solution you need. This keyboard shortcut allows you to promptly move to the first cell of the worksheet, which can be quite helpful when dealing with large spreadsheets. Knowing this essential shortcut key can help you navigate faster and more efficiently through your documents, making your work easier and less time-consuming. This article will guide you on how to press Control Home on Excel, step-by-step.
What Does Ctrl+Home Do in Excel?
Pressing Ctrl+Home moves the active cell to cell A1 and scrolls the window so that A1 is visible in the top-left corner. It works the same way regardless of which cell you start from, which is why it is one of the fastest ways to get back to the top of a large sheet. For the broader picture, see our wider best Excel keyboard shortcuts roundup.
If you want to control which cell becomes active before or after you jump, our walkthrough on how to make a cell the active cell explains the underlying behavior.
Step 1: Selecting the Worksheet
Before we proceed to press the Control Home shortcut key, we need to ensure that we have already selected the worksheet we are working on. To do this, click on the worksheet’s tab at the bottom of the Excel window.
Step 2: Positioning the Active Cell
After selecting the worksheet, we need to position the active cell to whichever cell we want to start with. To do this, click on the desired cell with your mouse pointer, or use the arrow keys to move to the desired cell.
Step 3: Pressing the Control Home Shortcut Key
Now we are ready to press the Control Home shortcut key. Press and hold the Control key, then press the Home key on your keyboard (labeled as ‘Fn + Left arrow key’ on some compact and laptop keyboards that lack a dedicated Home key). This will move the active cell to the first cell in the worksheet (cell A1). If you have a header row, it will be included.
When to Use the Control Home Shortcut Key
The Control Home shortcut key can be useful in several situations. For instance, when working on large worksheets, it can be challenging to scroll all the way up to the first cell of the worksheet manually. In such a case, you can use this shortcut key to save time and increase efficiency. Besides, the Control Home shortcut key can also be helpful when you need to start data entry from the beginning of the worksheet.
Now that you know how to press Control Home on Excel, navigating through Excel worksheets should be much more natural and efficient. Shortcut keys like this can help you save time and increase productivity, making your work easier and less stressful.
How Freeze Panes Changes Ctrl+Home
Freeze Panes changes where Ctrl+Home lands. On a normal sheet, Ctrl+Home always goes to A1. But once you freeze rows or columns to keep them visible while you scroll, Ctrl+Home instead jumps to the first unfrozen cell — the top-left cell of the scrollable area, just below and to the right of the frozen panes.
For example, if you freeze the top row, Ctrl+Home moves to A2 rather than A1, because row 1 is locked in place. If you freeze both the top row and the first column, Ctrl+Home lands on B2. This is intended behavior, not a bug: Excel assumes the frozen rows and columns are headers you do not need to edit, so it sends you to the start of your actual data.
To learn how to set up frozen panes, see how to freeze the top row and first column. If the behavior is getting in your way, you can unfreeze panes in Excel and Ctrl+Home will return to taking you to A1.
Control + End: The Opposite Shortcut
Ctrl+End is the mirror image of Ctrl+Home. Instead of taking you to the top-left corner, it moves the active cell to the last cell of the worksheet’s used range — the intersection of the bottom-most row and right-most column that contain (or have contained) data. This is helpful when you want to check the full extent of a worksheet or make sure you have not missed any data at the bottom. For more on reaching the end of your data, see how to scroll to the bottom of an Excel sheet.
Control Home on a Mac
Mac keyboards handle this shortcut a little differently because full-size Apple keyboards do not always include a dedicated Home key.
- On a Mac with a full extended keyboard that has a Home key, press Control + Home (or Fn + Control + Home).
- On a MacBook or compact keyboard without a Home key, press Fn + Control + Left Arrow. The Fn + Left Arrow combination acts as Home, and adding Control jumps you to the start of the worksheet.
Either combination moves the active cell to A1 (or to the first unfrozen cell when panes are frozen), exactly as Ctrl+Home does on Windows.
Windows vs. Mac Shortcut Table
| Action | Windows | Mac |
|---|---|---|
| Jump to A1 / first cell | Ctrl + Home | Fn + Control + Left Arrow (or Control + Home) |
| Jump to last used cell | Ctrl + End | Fn + Control + Right Arrow (or Control + End) |
| Move to start of the current row | Home | Fn + Left Arrow |
| Select entire worksheet | Ctrl + A | Command + A |
Other Useful Excel Shortcuts
Knowing keyboard shortcuts in Excel can make your work easier and faster, allowing you to complete tasks quickly and efficiently. Here are a few additional keyboard shortcuts that will be useful to add to your arsenal:
Control + A
Control A is a shortcut key that selects the entire worksheet. This means that every cell in the worksheet will be highlighted and ready for editing. To select just one column instead, see how to select an entire column in Excel.
Control + Z and Control + Y
Control Z is the classic undo action in Excel, allowing you to revert to the last action you took. Control Y, on the other hand, is the ‘redo’ function, which allows you to roll back an undo action.
Keyboard Shortcuts vs. Mouse Clicks
Using shortcut keys in Excel can make you more productive and efficient, but it’s important to strike a balance between mouse clicks and keyboard shortcuts. While using a mouse for everything can be time-consuming, relying entirely on shortcut keys can be overwhelming and challenging if you don’t use them frequently. As such, it’s essential to find a balance between using both the mouse and keyboard shortcuts.
Troubleshooting: Ctrl+Home Not Going to A1
If you press Ctrl+Home and it lands somewhere other than cell A1, the most common cause is frozen panes. When rows or columns are frozen, Excel deliberately sends Ctrl+Home to the first unfrozen cell instead of A1. Check the View tab — if it shows “Unfreeze Panes” as an option, panes are currently frozen.
To get Ctrl+Home jumping to A1 again, go to View → Freeze Panes → Unfreeze Panes, or follow our step-by-step guide to unfreezing panes in Excel. Once panes are unfrozen, the shortcut returns to its standard behavior of moving the active cell to A1.
If panes are not frozen and Ctrl+Home still misbehaves, confirm you are pressing Home and not End, and on a laptop check whether you need the Fn key to access the Home function.
Frequently Asked Questions
What does Ctrl+Home do in Excel?
Ctrl+Home moves the active cell to A1, the top-left cell of the worksheet, and scrolls the window so A1 is visible. If panes are frozen, it instead jumps to the first scrollable (unfrozen) cell.
What is the shortcut to go to cell A1?
On Windows, press Ctrl+Home. On a Mac, press Fn + Control + Left Arrow (or Control + Home on a full keyboard). This works from anywhere in the sheet, as long as no panes are frozen.
Why does Ctrl+Home not go to A1?
The usual reason is frozen panes. With frozen rows or columns, Ctrl+Home goes to the first unfrozen cell rather than A1 by design. Unfreeze the panes from View → Freeze Panes → Unfreeze Panes to restore the jump to A1.
Can I use Control Home on a Mac?
Yes. Use Fn + Control + Left Arrow on a MacBook or compact keyboard, or Control + Home on a full extended keyboard with a dedicated Home key. Both move the active cell to A1.
What is the difference between Control Home and Control End?
Control Home moves the active cell to the first cell (A1) of the worksheet, while Control End moves it to the last cell of the used range — the bottom-right-most cell that contains or has contained data.
Does Control Home work on every version of Excel?
Yes. The Control Home shortcut works across all desktop versions of Excel on both Windows and Mac, and its frozen-panes behavior is consistent throughout.
