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.
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.