number cell increment +1 when dragging down box

[Guest]

Can anyone tell me how to stop a number from incrementing by 1 when you grab
the corner of the cell and drag it down to copy the number into several cells
in the column. It seems sometimes it doesn't and sometimes it does (add 1)
to the number. I would like to choose when it increments the number and when
it simply copies what is in the cell when the contents is a number.

 

[Guest]

Try selecting 2 rows of one's and dragging that down. This way it will just
copy a 1 into every row.

Another way would be to select the entire area you want as 1's, type a 1,
and hit ctrl+enter. This will fill the entire selection with 1's.

 

[Guest]

If you right-click & drag down, when you release the mouse button yu'll see a
menu which gives you several options. One of them is "Copy Cells"

 

[Bernard Liengme]

In my Excel2003, pulling the fill handle of a cell with one number just
repeats that number.
With a date I always get incrementation

 

[Guest]

Thanks this works great!

If you right-click & drag down, when you release the mouse button yu'll see a
menu which gives you several options. One of them is "Copy Cells"