--- title: Fill formulas down in seconds description: quick fill formulas in Excel image: https://woodthorpeitsolutions.co.uk/hubfs/Stock%20Images/campaign-creators-pypeCEaJeZY-unsplash.jpg --- [![logo](https://woodthorpeitsolutions.co.uk/hubfs/logo.png)](https://woodthorpeitsolutions.co.uk) - [Home](https://woodthorpeitsolutions.co.uk) - [Private Course](https://woodthorpeitsolutions.co.uk/private-courses) - [Public Course](https://woodthorpeitsolutions.co.uk/public-course-dates) - [Tips](https://woodthorpeitsolutions.co.uk/tips-and-news) - [Contact us](https://woodthorpeitsolutions.co.uk/contact) - [Home](https://woodthorpeitsolutions.co.uk) - [Private Course](https://woodthorpeitsolutions.co.uk/private-courses) - [Public Course](https://woodthorpeitsolutions.co.uk/public-course-dates) - [Tips](https://woodthorpeitsolutions.co.uk/tips-and-news) - [Contact us](https://woodthorpeitsolutions.co.uk/contact) [0800 044 3779](tel://08000443779) [Excel](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/excel) # Fill formulas down in seconds [Woodthorpe IT](https://woodthorpeitsolutions.co.uk/tips-and-news/author/woodthorpe-it) 17 February, 2026 ![](https://woodthorpeitsolutions.co.uk/hubfs/Stock%20Images/campaign-creators-pypeCEaJeZY-unsplash.jpg) If you’ve ever dragged a formula down hundreds (or thousands) of rows, you’ll know how fiddly and time-consuming it can be — especially if you drag too far or not far enough. There’s a much faster way. Once you’ve entered your formula in the first cell: 1. Click on that cell 2. Move your mouse to the small square in the bottom-right corner (the *fill handle*) 3. **Double-click** Excel will automatically copy the formula down as far as the data goes in the column next to it - no dragging required. This works brilliantly for things like: - Calculating totals or percentages - Converting values - Applying the same formula to a long list of rows It’s a tiny trick, but it can turn a slow, repetitive task into a one-second action — exactly the kind of time-saver busy Excel users appreciate. Previous Post ###### [Select text in Word without dragging your mouse](https://woodthorpeitsolutions.co.uk/tips-and-news/select-text-in-word-without-dragging-your-mouse) Next Post ###### [Preview your slideshow from the current slide](https://woodthorpeitsolutions.co.uk/tips-and-news/preview-your-slideshow-from-the-current-slide) ### Similar Blog Posts [![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/AI-Generated%20Media/Images/The%20image%20features%20a%20computer%20screen%20displaying%20an%20Excel%20spreadsheet%20The%20focus%20is%20on%20a%20column%20where%20a%20user%20has%20entered%20a%20few%20full%20names%20and%20next%20to%20it.png?width=352&name=The%20image%20features%20a%20computer%20screen%20displaying%20an%20Excel%20spreadsheet%20The%20focus%20is%20on%20a%20column%20where%20a%20user%20has%20entered%20a%20few%20full%20names%20and%20next%20to%20it.png)](https://woodthorpeitsolutions.co.uk/tips-and-news/flash-fill-magic) #### [Flash Fill Magic (Ctrl + E)](https://woodthorpeitsolutions.co.uk/tips-and-news/flash-fill-magic) [![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/Stock%20Images/hazel-z-FocSgUZ10JM-unsplash.jpg?width=352&name=hazel-z-FocSgUZ10JM-unsplash.jpg)](https://woodthorpeitsolutions.co.uk/tips-and-news/clean-up-data-fast-with-find-replace) #### [Clean up data fast with Find & Replace](https://woodthorpeitsolutions.co.uk/tips-and-news/clean-up-data-fast-with-find-replace) [![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/AI-Generated%20Media/Images/calendar%20maths%20cartoon.jpeg?width=352&name=calendar%20maths%20cartoon.jpeg)](https://woodthorpeitsolutions.co.uk/tips-and-news/the-final-countdown-date-maths-in-excel) #### [The final countdown (Date Maths in Excel)](https://woodthorpeitsolutions.co.uk/tips-and-news/the-final-countdown-date-maths-in-excel) [![Logo 290x70 - white](https://woodthorpeitsolutions.co.uk/hubfs/Logo%20290x70%20-%20white.png)](https://woodthorpeitsolutions.co.uk) Woodthorpe IT Solutions are providers of Microsoft 365 training and consultancy.  Established in 2005 we have trained over 10k people and continue to help learners get the most from their computer. [Want to resell our courses?  Click here to learn more.](https://woodthorpeitsolutions.co.uk/reseller) [Follow us on LinkedIn](https://www.linkedin.com/company/woodthorpe-it-solutions/) [Follow us on YouTube](https://www.youtube.com/@WoodthorpeITSolutionsLtdBlacon) ###### Get In Touch 0800 044 3779 contactus@woodthorpeit.com ##### Company details Co number: 05572129 Vat number: 936 2824 09 ##### Trust [Privacy Notice](https://woodthorpeitsolutions.co.uk/privacy-notice) [Terms](https://woodthorpeitsolutions.co.uk/terms) [Slavery and Human Trafficking Statement](https://woodthorpeitsolutions.co.uk/slavery-and-human-trafficking-statement) Copyright © 2026 Woodthorpe IT Solutions Limited ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Woodthorpe IT", "url" : "https://woodthorpeitsolutions.co.uk/tips-and-news/author/woodthorpe-it" }, "dateModified" : "2026-02-17T11:00:00.969Z", "datePublished" : "2026-02-17T11:00:00.000Z", "headline" : "Fill formulas down in seconds", "image" : [ "https://woodthorpeitsolutions.co.uk/hubfs/Stock%20Images/campaign-creators-pypeCEaJeZY-unsplash.jpg" ], "mainEntityOfPage" : { "@id" : "https://woodthorpeitsolutions.co.uk/tips-and-news/fill-formulas-down-in-seconds", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject" } } } ```