Exceljet

Quick, clean, and to the point

Extend the selection to the last cell right

Windows shortcut 
CtrlShift
Mac shortcut 

If the active cell is empty, Excel will extend the selection to the first non-empty cell to the right. If the active cell is non-empty, Excel will extend the selection on the last non-empty cell to the right. On a Mac, the command key (⌘) can be used instead of the control key.

Related videos

Tip: How to build a search box to highlight data
In this video, we use conditional formatting to create an interactive search box to highlight data. This is a nice alternative to filtering, because the information you're looking is highlighted in context, and the search box checks multiple columns at the same time (using concatenation).
Tip: How to clone a pivot table
Once you have one pivot table set up, you might want to see a different view of the same data. In this video, I'll show you how to quickly base one pivot table on another.
Tip: How to create zebra stripes with conditional formatting
In this video, we look at how to use conditional formatting, with a formula, to shade every other row in a table. This is sometimes called "zebra striping", and it's a cool trick.
Tip: How to do a two-way lookup with INDEX and MATCH
In this video, we use use MATCH to find the position of an item in a table, and we use INDEX to retrieve the value at that position. We work step-by-step so you can see how both functions work.
Tip: How to select cells with your keyboard
Excel Pros use keyboard shortcuts to power though big worksheets with blazing speed. In this video, we look at some key shortcuts for selecting cells.
Tip: How to use conditional formatting to check line length
A short video that shows you how to use conditional formatting with the LEN function to highlight text that is too long.
Tip: How to use VLOOKUP
In this video, learn how to use VLOOKUP to build a simple form to extract employee information from a table, in about 3 minutes.
Tip: How to use VLOOKUP to merge tables
VLOOKUP is a great way to merge data in two tables based on a common ID. This video shows you how in 3 minutes. You can even use this technique to reorder the columns you retrieve.
Tip: Shade groups of rows with conditional formatting
In this video, we'll look at how to use conditional formatting to shade alternating groups of rows. For example, you can use this approach to shade groups of 3 rows, groups of 4 rows, and so on. This can be a nice way to make certain tables easier to read.
Just wanted to thank you for your fantastic site. I use the site many times a week and it has helped me to solve many reporting problems and needs I have in my daily work. I have learned many new ways to use excel thanks to you. -Sanna
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course