Exceljet

Quick, clean, and to the point

Extend the selection to the last cell down

Windows shortcut 
CtrlShift
Mac shortcut 

If the active cell is empty, Excel will extend the selection to the first non-empty cell below the active cell. If the active cell is non-empty, Excel will extend the selection on the last non-empty cell below the active cell. 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 build a simple summary table
Although Pivot Tables are fantastic tools for summarizing data, sometimes you just want a simple, lightweight solution based on formulas. The good news is you can build your own summaries using functions like COUNTIF and SUMIF. See how in this 3 minute video.
Tip: How to clean text with TRIM and CLEAN
When you bring data into Excel you sometimes end up with extra spaces and line breaks. This short video shows you how to clean things up with TRIM and CLEAN.
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 compare two lists and highlight differences
In this video, we look at how to compare two lists using conditional formatting. This is a great way to visually highlight different or missing items in a list.
Tip: How to create a 3D formula reference
With 3D referencing you build a reference that refers to a range of worksheets. It's an elegant way way to analyze a large number of identical worksheets with simple formulas.
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 find missing values with COUNTIF
In this video, we use COUNTIF to compare lists and count values that belong to both lists. We also "flip" the formula to count values in one list that are missing on the other.
Tip: How to generate random values
In this video, we'll look at a few ways to generate random values with the RANDBETWEEN function. You can use this approach to generate random numbers, random prices, random dates, and even random text values. This is a great way to create dummy data to test formulas and worksheets.
Tip: How to rank values with the RANK function
The RANK function gives you a way to rank values with a simple function that will dynamically calculate rank. If any value changes, you'll get a new rank automatically.
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 the CHOOSE function
In this video, we'll look at how you can use the CHOOSE function for simple lookups. The CHOOSE function doesn't need an external table, and can sometimes replace more complicated formulas based on VLOOKUP, INDEX and MATCH, or nested IFs.
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.
I needed a quick restart of my knowledge and your courses are exactly what I needed: Short, focused, systematic and high quality.
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