Safequip Member Jun 14, 2013 #1 instead of dragging a formula down a column which takes forever how do I autofill I can't work it out thanks
instead of dragging a formula down a column which takes forever how do I autofill I can't work it out thanks
oldchippy Active Member Jun 14, 2013 #3 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
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