# 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

The videos below demonstrate this shortcut.

In this video, we'll look at how to apply conditional formatting to one cell based on values in another, using a formula.

Pivot Tables are fantastic tools for summarizing data, but you can also use formulas to build your own summaries using functions like COUNTIF and SUMIF. See how in this 3 minute video.

In this video, we'll look at a few ways to generate random values with the RANDBETWEEN function, including random dates, random prices, and random workdays.

In this video, we'll look at how to create a line chart in Excel to plot historical, 30-year mortgage interest rates.

In this video, we'll look at how to create 3D references, an elegant way to analyze multiple worksheets with simple formulas.