• 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

    Hui...

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

autofill formula to bottom of column

Safequip

Member
instead of dragging a formula down a column which takes forever how do I autofill I can't work it out


thanks
 
Hi Safequip,


Dave's solution works if there is data in the adjoining column, if you have any blanks in any cells then it will stop at that point and you will then have to drag it down to the next filled cell and double click the little + again
 
Back
Top