Excel shortcuts

How to Use the Fill Down Shortcut in Excel

If you're like most people, you probably use the fill handle in Excel to fill down a column of data. But did you know that there's a shortcut that can save you even more time?

The fill down shortcut is simple: just select the cell you want to start from, then press Ctrl+D (Windows) or Command+D (Mac). Excel will automatically fill down the column for you.

This shortcut is especially useful when you have a lot of data to fill down. For example, let's say you have a list of 1,000 names in one column, and you want to fill down a second column with the corresponding addresses. Using the fill handle would take a long time, but with the fill down shortcut, it's a breeze.

Here's another tip: you can also use the fill down shortcut to fill across row. Just select the cell you want to start from, then press Ctrl+R (Windows) or Command+R (Mac).

So next time you need to fill down or fill across in Excel, save yourself some time by using the fill down shortcut.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.