How apply formula to entire column?
Copying values in tables is very easy. Take a look at the picture below. You should only put cursor in the right bottom of the cell and double click.
Values insert but only in the cells where there are some neighbors.
But what to do when you want to copy entire column or row? There is a Fill option in the Ribbon in Excel.
Put your formula in first row in the entire column. Select whole column and use Fill > Down column.
As you see you copied formula to the every cell in the column. Also below 12 row where don’t have any neighbors in column D.
You can also copy entire row the same way. Use Fill > Right then instead Fill > Down
Template
You can download the Template here – Download
Further reading: How to add text in formula? Monthly installment formula Sumif formula
