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