Extend Selection to Last Cell Right in Excel
This shortcut allows you to extend the current selection to the last used cell on the right in the same row. It is extremely useful when working with wide datasets or tables.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Ctrl + Shift + → | Cmd + Shift + → |
What Does This Shortcut Do?
When you press this shortcut, Excel extends the selection from the active cell to the last non-empty cell on the right side of the row. It stops at the first blank cell boundary.
How to Use the Shortcut
- Click on the starting cell in a row
- Press and hold Ctrl + Shift (Windows) or Cmd + Shift (Mac)
- Press the Right Arrow key
- The selection will extend to the last used cell on the right
Tips & Best Practices
- Works best when data has no blank cells in between
- Very useful for selecting entire rows of dynamic data
- Combine with copy or formatting shortcuts for faster work
FAQ
- Q: What if there are blank cells in the row?
- The selection will stop at the first blank cell.
- Q: Does this work inside Excel tables?
- Yes, it works perfectly within structured Excel tables.
- Q: Can I use this in Google Sheets?
- Google Sheets supports a similar shortcut, but behavior may vary slightly.