Excel fill down keyboard shortcut (Ctrl + D)

• Release Jan 25, 2022Update Aug 24, 2022
• Written in Excel for Microsoft 365 version 2202

When you want to copy data contained in a cell downward, most people probably use Ctrl + C to copy and Ctrl + V to paste. However, with the fill down shortcut, you can copy not only the data itself, but also fonts, fills, and other formatting in one shot. Once you learn it, it will make your work much easier, save you time, and improve your productivity, so please give it a try.

Shortcut for performing fill down

Windows
Ctrl + D

Mac
command + D or control + D

Fill down with shortcut

See below for instructions on how to use shortcuts to perform fill down. Note that this shortcut allows you to copy not only the data itself, but also the formatting, such as text color and fill.

Total Time: 1 minute

Select a Cell

Select one cell down from the cell you want to copy.

Fill down completion

Press Ctrl + D. This shortcut allows you to copy not only the data itself, but also the formatting, such as text color and fill.