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