Extend Selection by One Cell Right: Excel Shortcut
This article explains the Excel shortcut for extending a selection by one cell to the right, covering the key combinations for both Windows and Mac, how they work, and common issues you might encounter. You’ll learn the exact keys to press, what they do in different contexts, and how to avoid mistakes that can disrupt your workflow.
What Does “Extend Selection by One Cell Right” Mean?
In Excel, extending a selection by one cell to the right means that if you have a single cell or a range of cells selected, pressing a specific shortcut adds the adjacent cell to the right to your current selection. This is part of Excel’s “extend selection” feature, which allows you to expand a highlighted area without using the mouse. The primary shortcut is Shift + Right Arrow on Windows and Shift + Right Arrow on Mac (the same keys). This action expands the selection from the active cell to include one more column to the right.
How the Shortcut Works
When you press Shift + Right Arrow, Excel moves the selection border one cell to the right while keeping the original active cell (the first cell you selected) anchored. For example, if you start with cell A1 selected and press Shift + Right Arrow once, the selection becomes A1:B1. Pressing it again extends to A1:C1, and so on. If you already have a multi-cell range selected, the shortcut expands the range by one column on the right side, regardless of the direction of the original selection. The active cell (the white cell within the selection) stays the same, and the selection grows to the right.
Keyboard Shortcuts for Different Platforms
- Windows: Shift + Right Arrow
- Mac: Shift + Right Arrow
- Extend by one screen right: Shift + Alt + Page Down (Windows only)
- Extend to the edge of data: Ctrl + Shift + Right Arrow (Windows) / Command + Shift + Right Arrow (Mac) – this extends to the last non-empty cell in the row.
Note that the Shift + Right Arrow shortcut works in all modern versions of Excel (2010, 2013, 2016, 2019, 2021, and Microsoft 365) on both Windows and Mac. On Mac, the Option key is often used instead of Alt for some shortcuts, but the basic extend selection shortcut does not require it.
Extending Selection with the Mouse
If you prefer using the mouse, you can also extend a selection by one cell to the right by holding the Shift key and clicking on the cell to the right of your current selection. Alternatively, you can click on the cell and drag the fill handle (the small square at the bottom-right corner of the selection) to the right, but that copies or fills data, not just extends the selection. For pure selection extension, the keyboard shortcut is the most efficient method.
Common Mistakes and How to Avoid Them
One common mistake is pressing Ctrl + Shift + Right Arrow when you only want to extend by one cell. This shortcut jumps to the edge of the data region, which can select hundreds of columns if your row has data far to the right. To avoid this, use the plain Shift + Right Arrow for single-cell steps. Another mistake is accidentally pressing Shift + Left Arrow when you meant to go right, which shrinks the selection instead of extending it. Always check the selection border to confirm the direction.
Using the Shortcut with Formulas and Data Entry
Extending a selection by one cell right is particularly useful when you want to apply a formula to a range without using the fill handle. For example, if you have a formula in cell A1 and you want to copy it to B1, you can select A1, press Ctrl + C (copy), then press Shift + Right Arrow to select B1, and press Ctrl + V (paste). This method is faster than dragging the fill handle when you need to copy across many columns. However, be aware that if you have data in adjacent cells, the shortcut will extend the selection over that data, which might cause you to overwrite it if you paste.
Frequently Asked Questions
Does Shift+Right Arrow work in Google Sheets?
Yes, the same shortcut works in Google Sheets on both Windows and Mac. The behavior is identical: it extends the selection by one cell to the right. This is a standard spreadsheet shortcut across most applications.
What if my keyboard has a function (Fn) key that interferes?
On some laptops, the right arrow key might be combined with a function key (e.g., Fn+Right Arrow) to control media or brightness. If pressing Shift+Right Arrow doesn’t work, try pressing Fn+Shift+Right Arrow, or check your keyboard settings to see if the Fn key is locked. In most cases, the shortcut works without Fn, but if it doesn’t, you can use the on-screen keyboard or change the function key behavior in your system settings.
Can I extend selection by more than one cell at a time?
Yes, you can hold down the Shift key and press the Right Arrow multiple times to extend by several cells. Alternatively, you can use Shift + Ctrl + Right Arrow to extend to the edge of the data region, or Shift + End + Right Arrow (on Windows) to extend to the last cell in the row (which may be beyond the data).
Why does my selection not extend when I press Shift+Right Arrow?
This can happen if the Scroll Lock key is on. Scroll Lock changes the behavior of the arrow keys from moving the selection to scrolling the worksheet. Press the Scroll Lock key to turn it off, and the shortcut should work again. On some laptops, you may need to press Fn + Scroll Lock or use the on-screen keyboard to toggle it.
Is there a way to extend selection to the right without using the keyboard?
Yes, you can use the mouse: click on the cell to the right of your current selection while holding the Shift key. This will extend the selection to that cell. You can also click and drag from the active cell to the right, but this may be less precise for single-cell extensions.