Windows Mac
CtrlShift↓ ⌘⇧↓

About This 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.

Demo 

Extend the selection to the last cell down

Related videos

Excel How to generate random times

How to generate random times

In this video, we'll look at how to create a list of random times. In this worksheet, let's generate 20 random times between 7:00 AM and 6:00 PM. To do this, we'll use the RANDARRAY function. Now, RANDARRAY can generate both integers and decimal values. For Times, we want decimal values, because …
Excel How to chart generations with floating bars

How to chart generations with floating bars

In this video, we'll plot American generations in a chart with floating bars. In this worksheet we have a list of six generations. Each generation has a start year and end year, which represent birth years. How can we plot these generations in an easy-to-read bar chart? This seems like a simple …
Excel How to generate random values

How to generate random values

In this video we'll look at a few ways to generate random values with the RANDBETWEEN function. The RANDBETWEEN function is a simple function you can use to generate random numbers. For example, I can enter RANDBETWEEN with a bottom value of 1 and a top value of 100. When I press Enter, I get a …
Excel Shade groups of rows with conditional formatting

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. Here we have a table with 3 rows of data …
Excel How to use VLOOKUP to merge tables

How to use VLOOKUP to merge tables

In this video I'll demonstrate how you can use VLOOKUP to join data in separate tables. In this worksheet we have two tables. In the first table, we have order data. You can see that we've got a date, customer id, product, and total. In a second sheet we have customer data. We've got first and last …
Excel Why pivot tables?

Why pivot tables?

Hi, Dave here from Exceljet So, today we're going to tackle the question Why Pivot Tables? And this question comes up a lot when people first run into Pivot Tables, because they're wondering...why should they care? And you're trying to explain that pivot tables are really fast, that you can …
Excel Conditional formatting based on a different cell

Conditional formatting based on a different cell

In this video, we'll look at how to apply conditional formatting to one cell based on values in another, using a formula. Let's take a look. The easiest way to apply conditional formatting is to apply rules directly to the cells you want to format. For example, if I want to highlight the average …
Excel How to rank values with the RANK function

How to rank values with the RANK function

In this video we'll look at how to rank values in ascending or descending order using the RANK function. Here we have a table that contains five test scores for a group of students and an average score in Column I. How can we rank these students from highest to lowest scores? Well, one option is to …
Excel How to convert formulas to values

How to convert formulas to values

As you start to work with more formulas in Excel, you'll find you often want to replace formulas with the values they generate. One common situation is that your formula has calculated a result, and you want to stop Excel from calculating a new result. Let's take a look. To illustrate converting …
Excel How to check line length with conditional formatting

How to check line length with conditional formatting

How to use conditional formatting with the LEN function to highlight text that is too long. Have you ever had to check to make sure certain lines of text aren't too long? For example, maybe you need to check values being imported to a database or website that only allows a certain number of …

Support Exceljet

Many websites (including Exceljet) have lost over half their traffic in the past year because of the crushing impact of AI on web searches. Exceljet is still at it, publishing free content each week. If you find Exceljet helpful, you can support the site and go ad-free with the Exceljet Lifetime Pass. One payment, no subscription, and ads are gone forever. Plus, you get our Excel Shortcuts video course as a thank you.

Get the Lifetime Pass

Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.