auto add ( + )

[leecavturbo]

i want to print lots of repeated text/numbers
so i entered the number in a cell then used the pulldown
(bottom right select box) to repeat the number
in the cells below but excel has added 1 to every cell so the
number increases by 1 every row, how do i stop excel adding?

 

[Peter_SSs]

i want to print lots of repeated text/numbers
so i entered the number in a cell then used the pulldown
(bottom right select box) to repeat the number
in the cells below but excel has added 1 to every cell so the
number increases by 1 every row, how do i stop excel adding?

One way is:
Hold Ctrl while pulling down

Another way is:
Select all the cells first, type the entry and confirm with ctrl+enter

 

[leecavturbo]

One way is:
Hold Ctrl while pulling down

Simple when you know
thank you very much