• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to make "fill down" do what you want.

Eloise T

Active Member
You've probably understood this long ago, and I'm likely the last one to figure this out, but I had no need to use "fill down" until recently.

I found myself wanting to "fill down" e.g. January, February, March, etc. in one column and only January in another.

Who knew? Referring to the picture above, you of course knew,

... in order to fill down January through December in column D, type January in the first row, then click an hold the tiny green box in the lower right corner of the cell, drag it down as needed and voilà!upload_2018-9-16_14-33-27.png

... but did you know in order to fill down "January"s in column F, type January in the first row, highlight (in this case January) and the column to the depth you need January to fill and then press Ctrl + D. Done!

This is also true with currency, entire dates, and many other possibilities, of course.
Last edited by a moderator: