Forum Discussion

KameronPoore's avatar
KameronPoore
Copper Contributor
Apr 09, 2021

Formula for entire column

Hello! I'm making an excel sheet to organize my books. In columns C and D, I have the date I started the book and the day I finished the book. Column E uses the formula =DAYS(D3, C3) to display the amount of days I took to read that book. Is there a simple way to have that formula apply to the whole column without having to modify it manually the whole way down? I don't want to have to enter in a formula on every cell if that makes sense.

2 Replies

  • JMB17's avatar
    JMB17
    Bronze Contributor

    KameronPoore 

     

    Or, when you select the cell and hover over the bottom right corner, the cursor will change to a solid cross and you should be able to double click and it will fill the formula down the column (as long as the fill handle is enabled under File/Options/Advanced):

     

Resources