Enter same number in specific number of cells

[pyxiidust]

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

 

[pyxiidust]

I'm sorry again, but I just can't help thinking this simple task is being made more difficult than it really is.

If you left click and hold on A4
Then drag your mouse down, the Name Box (which Rick cleverly used before) automatically and dynamicly shows you how many rows/columns you have selected.
Just move your mouse down till the Name Box Says 17R X 1C (or 18r?).
Release the mouse, and press CTRL+D

THATS PERFECT!!! That's EXACTLY what I figured Excel could do!!!!

 

[Jonmo1]

THATS PERFECT!!! That's EXACTLY what I figured Excel could do!!!!

Whew

Glad to help, thanks for the feedback.

 

[Rick Rothstein]

I'm sorry again, but I just can't help thinking this simple task is being made more difficult than it really is.

If you left click and hold on A4
Then drag your mouse down, the Name Box (which Rick cleverly used before) automatically and dynamicly shows you how many rows/columns you have selected.
Just move your mouse down till the Name Box Says 17R X 1C (or 18r?).
Release the mouse, and press CTRL+D

Well... DUH! How did I not notice that!!!

 

[Jonmo1]

Well... DUH! How did I not notice that!!!

Chalk it up to being forum responders, our minds automatically jump to the 'more clever' solutions, than the simple ones.


Maybe you just wanted to show off that neat trick....j/k

 

[pyxiidust]

Chalk it up to being forum responders, our minds automatically jump to the 'more clever' solutions, than the simple ones.


Maybe you just wanted to show off that neat trick....j/k

Ya'll make me chuckle! Thank you, again! Can always count on this forum for us 'dummies'!