Excel Hack

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 a Cell

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

Fill down completion

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.

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments