You don't need to fill a formula to the whole column. Use array formula instead and remove the need to drag all the way down the sheet
For example if you want cells in column D contain the product of cells in B and C, and column E contains sum of B and C, instead of putting D1 = B1*C1
and E1 = B1 + C1
and drag down you put this in D1 and E1 respectively
=ARRAYFORMULA(B:B*C:C)
=ARRAYFORMULA(B:B + C:C)
Then the formula will be automatically applied to the whole column without dragging anything. X:X
refers to column X. If you want to include only from row 3 to the end use X3:X
That will apply the formula to the whole column and hence show 0s on the rows that has no data. So now to not show anything in the empty rows, i.e calculate only rows that has data in column B (except the header row) and hide the 0s below like you want, use this
=ARRAYFORMULA(IF(B2:B<>0, B2:B + C2:C, ""))
In offline apps like MS Office and LibreOffice to use array formula you'll need to press Ctrl+Shift+Enter instead of ARRAYFORMULA
function
If you want to hide 0s inside the table then you can use a conditional formatting
- Select the cells you want to remove 0s
- Select menu Format > Conditional formatting > add the condition "is equal to" and enter 0 in the textbox
- In formatting style change the text color to white or none
- Press Done
Now every cell that is equal to 0 will be blank