Formula for entire column

Copper Contributor

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

@KameronPoore 

Change your table into an Excel table (CTRL-T). Any formula that is entered will automatically copy down.

 

@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):

JMB17_0-1618012085997.png