4

So I have a column with text like abcd81. If I drag the cell by that bottom right point then the next row will have abcd82 and so on.

How can I prevent this behavior?

Improve this question
0

5 Answers 5

Reset to default
3

Copy the one cell you want duplicate.

Mark all the cells you want to have this value and paste

That worked for me

Improve this answer
4

On Windows, hold Ctrl button while dragging the cell. This will autofill the cell as-is.

Improve this answer
3

Use copy and paste instead of dragging the corner of the cell.

Improve this answer
1

On Mac, you can hold the Option key and drag the handle at corner of the originating cell.

Improve this answer
-1

Use $ before the number, like abcd$81, to prevent this behaviour.

Improve this answer
1
  • 1. The question is not about a cell reference but about a text string. 2. ABCD81 is not a cell reference. Sheets has a maximum columns of 18, 278 which is equivalent to ZZZ
    – Blindspots ♦
    Commented May 7 at 22:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.