How to copy a number down the column

I want to copy a number in one cell down to many cells beneath it. When I drag the bottom right corner thing it copies and increments by one at each row.
how do i copy just that number with some kind of drag. No increment?

Hold the Ctrl-Key while dragging to prevent increments.
(Or press Ctrl before releasing the mouse-key)

1 Like

thank you. :slight_smile:

Copy cell with number to clipboard, select target cells, paste.
Or if it’s a new number to be entered, select cells, enter number but close with Alt+Enter instead of just Enter.