http://chandoo.org/forums/topic/autofill-along-rows-with-a-mouse-click Ask Excel and Charting Questions, Muse about Visualizations, Learn and Share - Discussion Forums - Chandoo.org en-US Sat, 25 May 2013 23:45:24 +0000 http://bbpress.org/?v=1.0.1 q http://chandoo.org/forums/search.php http://chandoo.org/forums/topic/autofill-along-rows-with-a-mouse-click#post-24785 Thu, 03 May 2012 06:04:08 +0000 SirJB7 24785@http://chandoo.org/forums/ <p>@Austinma<br /> Hi!<br /> In my case, it depends on the day, sometimes I work in "normal" hours (9am thru 6pm), sometimes at night (now it's 3am, I'm GMT-3), and sometimes I don't work for many days (I've been on holiday from Sat thru Tue).<br /> Regards! </p> http://chandoo.org/forums/topic/autofill-along-rows-with-a-mouse-click#post-24783 Thu, 03 May 2012 05:34:27 +0000 Austinma 24783@http://chandoo.org/forums/ <p>Good morning SirJB7 &amp; Hui, </p> <p>Once again thanks for your help with this question. </p> <p>@SirJB7</p> <p>All good suggestions both of which I'm pleased to say I currently do. The beauty of the vertical autofill I highlighted in my original post is that it works really well when you have a large number of cells to fill. Hold and drag methods suffer when you have to drag down through multiple screens of data.</p> <p>@Hui</p> <p>I like this idea - Particularly if it can autofill in other directions too, I'm going to give this a go and let you know how I get on.</p> <p>BTW - do you guys not have to sleep at some point!!</p> <p>Thanks, </p> <p>Austinma </p> http://chandoo.org/forums/topic/autofill-along-rows-with-a-mouse-click#post-24777 Thu, 03 May 2012 00:56:05 +0000 Hui 24777@http://chandoo.org/forums/ <p>Austinma </p> <p>You can add buttons to the Quick Access Toolbar or a Custom Tab which allows you to Fill Right, Left and Up</p> <p>These are all available from the Customise Quick Access Toolbar and Customise the Ribbon menus or by Right click on the Quick Access Toolbar </p> http://chandoo.org/forums/topic/autofill-along-rows-with-a-mouse-click#post-24775 Wed, 02 May 2012 23:26:07 +0000 SirJB7 24775@http://chandoo.org/forums/ <p>Hi, Austinma!</p> <p>I don't know if this is exactly what you're asking for but here are my two cents:</p> <p>1) fast filling by copy<br /> a) enter something in A1:A3<br /> b) select that range<br /> c) click and hold on little black square at bottom right<br /> d) drag vertically<br /> The same can be done horizontally, inputting in A1:C1 and dragging thru A row</p> <p>2) fast filling series<br /> a) enter a number in A1, let's say 1<br /> b) enter a number in A2, let's say 3<br /> c) select A1:A2<br /> d) click and hold on same place<br /> e) drag vertically<br /> The same can be done horizontally, inputting in A1:B1 and dragging thru A row</p> <p>Hope it helps.</p> <p>Regards! </p> http://chandoo.org/forums/topic/autofill-along-rows-with-a-mouse-click#post-24756 Wed, 02 May 2012 18:50:32 +0000 Austinma 24756@http://chandoo.org/forums/ <p>Good evening - should be a quick answer to this.... </p> <p>I stumbled across the genius short cut of clicking on the small box in the bottom right hand side of a highlighted cell to autofill downwards in a column</p> <p><a href="http://chandoo.org/wp/2009/06/12/excel-mouse-tricks/" rel="nofollow">http://chandoo.org/wp/2009/06/12/excel-mouse-tricks/</a></p> <p>Made me think if there was a similar trick for autofilling along a row (from left to right)</p> <p>The more I learn about Excel the more I realise the less I know!!</p> <p>Cheers</p> <p>Austinma </p>