Enter the formula in the first cell of the column
Press Enter
Select the cell with the formula
Double-click the fill handle or drag it down the column
Use copy and paste to apply the formula to the remaining cells
Select the entire target range before entering the formula
Press Ctrl+D to fill down in Excel or Google Sheets
Use an array formula or spill formula if supported
Convert the range to a table to auto-fill formulas in Excel
Apply the formula to the first row of a table column to fill the whole column automatically