Excel fill down keyboard shortcut (Ctrl + D)
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.