Home

Autofilling a formula in an excel spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-276327%22%20slang%3D%22en-US%22%3EAutofilling%20a%20formula%20in%20an%20excel%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-276327%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20some%20help%20with%20a%20PTO%20spreadsheet.%26nbsp%3B%20I%20have%20formula%20put%20into%20cell%20F42%20to%20get%20the%20sum%20of%20two%20cells%20%3DSUM(F41%2CD42)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20please%20help%20me%20with%20using%20that%20blanket%20formula%20%3DSUM(F%20next%20number%20down%2C%20D%20next%20number%20down)%20for%20the%20rest%20of%20the%20spreadsheet%20as%20I%20move%20down%20rows%3F%20So%20for%20cell%20F43%20the%20formula%20would%20be%20%3DSUM(F42%2CD43)%2C%20is%20there%20anyway%20to%20autofill%20this%20formula%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMelanie%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-276327%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-277189%22%20slang%3D%22en-US%22%3ERe%3A%20Autofilling%20a%20formula%20in%20an%20excel%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-277189%22%20slang%3D%22en-US%22%3E%3CP%3Eor%3C%2FP%3E%0A%3CP%3E-%20enter%20your%20formula%20in%20F42%3C%2FP%3E%0A%3CP%3E-%20stay%20on%20F42%2C%20press%20and%20hold%20Shift%3C%2FP%3E%0A%3CP%3E-%20scroll%20down%20till%20end%20of%20the%20range%20in%20column%20F%2C%20left%20click%2C%20release%20Shift%3C%2FP%3E%0A%3CP%3E(other%20words%20select%20the%20range%20down%20starting%20from%20F42)%3C%2FP%3E%0A%3CP%3E-%20Ctrl%2BD%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-276497%22%20slang%3D%22en-US%22%3ERe%3A%20Autofilling%20a%20formula%20in%20an%20excel%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-276497%22%20slang%3D%22en-US%22%3EHi%20Melanie%2C%3CBR%20%2F%3E%3CBR%20%2F%3EHaytham's%20reply%20is%20100%25%20correct%20and%20the%20simplest%20way%20to%20copy%20and%20paste%20formulas.%20I%20am%20slightly%20confused%20to%20what%20you%20are%20attempting%20to%20achieve%20would%20you%20be%20able%20to%20post%20a%20sample%20of%20your%20spreadsheet%3F%20Thanks%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-276338%22%20slang%3D%22en-US%22%3ERe%3A%20Autofilling%20a%20formula%20in%20an%20excel%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-276338%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20use%20the%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fdisplay-or-hide-the-fill-handle-80918200-9ae9-4615-93c9-13d4f1496f81%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EFill%20Handle%3C%2FA%3E%20as%20shown%20in%20the%20below%20GIF.%3C%2FP%3E%3CP%3ETo%20find%20the%20Fill%20handle%2C%20hover%20the%20cursor%20over%20the%20lower%20right%20corner%20of%20the%20cell%20until%20you%20see%20the%20crosshair%20(Angry%20Rabbit)%20sign%2C%20then%20click%20and%20drag.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F57921i9B955D12DAD08729%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22UsingTheFillHandleInExcel.gif%22%20title%3D%22UsingTheFillHandleInExcel.gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EHaytham%3C%2FP%3E%3C%2FLINGO-BODY%3E
Quinn Peterson
Occasional Visitor

Hello All!!

 

I need some help with a PTO spreadsheet.  I have formula put into cell F42 to get the sum of two cells =SUM(F41,D42)

 

Can someone please help me with using that blanket formula =SUM(F next number down, D next number down) for the rest of the spreadsheet as I move down rows? So for cell F43 the formula would be =SUM(F42,D43), is there anyway to autofill this formula? 

 

Melanie

3 Replies

Hi,

 

You can use the Fill Handle as shown in the below GIF.

To find the Fill handle, hover the cursor over the lower right corner of the cell until you see the crosshair (Angry Rabbit) sign, then click and drag.

 

UsingTheFillHandleInExcel.gif

 

 

Hope that helps

 

Regards,

Haytham

Hi Melanie,

Haytham's reply is 100% correct and the simplest way to copy and paste formulas. I am slightly confused to what you are attempting to achieve would you be able to post a sample of your spreadsheet? Thanks

or

- enter your formula in F42

- stay on F42, press and hold Shift

- scroll down till end of the range in column F, left click, release Shift

(other words select the range down starting from F42)

- Ctrl+D

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
12 Replies