If there is no equals sign then whatever is typed in the cell will not be regarded as a formula. You should first type the formule into the cell B1 secondly select the entire column B and then click Home Fill Down. Double-Clicking the Fill Handle This is the easiest process for inserting the formula for the entire column.
Just click on the arrow for Insert Insert Table Columns to the Left.
Just click on the arrow for Insert Insert Table Columns to the Left. Note the formula in the formula bar while the result we would expect is in cell B2. You just do the following. To create a formula in excel must start with the equal sign.