Logo Background

Excel Fill Down

  • Most users of Microsoft Excel are aware of the fill-down handle, allowing you to click and drag on the small square at the bottom right-hand corner of a cell to fill the contents of subsequent cells with the same data or data fitting the pattern of the selected cells. If you would like a quicker way to fill-down, then simply double-click on the fill-down handle (small square) and it will automatically fill-down. Be aware, in order for this to work there must be data in other columns as Excel will determine where that data ends and stop the fill-down at that point.

Leave a Comment
Hi there. If this is the first time you are posting a comment it will not appear immediately, but needs to be approved. This is necessary in order to combat comment spam. However, once you have submitted a comment (which is subsequently approved) you do not need to go through this process again - the site remembers who you are and auto-approves your comments. Nifty eh? Anyway, sorry about the inconvenience that this may cause for your first comment post.