To have Excel fill in any numbers, letters or formulas into other cells, I should:

Select a cell, next click the BLACK plus sign on bottom right and drag it as far as I want to be filled in.