Excel: Enter same number in specific number of cells

Good morning, I would like to enter the same number in a specific amount of cells, i.e. the number "14" in A4 needs to be entered down the next 17 cells. Is there an easier way than just doing the math in my head? Julie

This question generated 25 answers. To proceed to the answers, click here.

This thread is current as of November 17, 2014.

For more resources for Microsoft Excel