3 ms·Enter the formula on row 1, copy it, select the column and pasteby srcreigh 4y agoEnter the formula on row 1, copy it, select the column and paste