Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Automatic Incrementing a Number in Numbers

How to stop a number from automatically incrementing when I copy the cell, in Numbers

iMac 21.5″, macOS 10.15

Posted on Mar 6, 2022 1:09 PM

Reply
Question marked as Best reply

Posted on Mar 6, 2022 1:59 PM

Is this data you have entered or are you talking about cell references in formulas?


If this is about data you have entered into a cell, Copy/Paste does not increment (or I cannot think of a case at the moment where it does). Drag-Filling (grab the cell border and drag in a direction) will increment in some instances. If it does, copy/paste the value to the cell next to it, select both cells, then drag-fill. Or just use copy/paste.


If this is about cell references in formulas, you use $ to lock in the row, column, or both. $B1 or B$1 or $B$1 depending on what you need.

1 reply
Question marked as Best reply

Mar 6, 2022 1:59 PM in response to rjmman1

Is this data you have entered or are you talking about cell references in formulas?


If this is about data you have entered into a cell, Copy/Paste does not increment (or I cannot think of a case at the moment where it does). Drag-Filling (grab the cell border and drag in a direction) will increment in some instances. If it does, copy/paste the value to the cell next to it, select both cells, then drag-fill. Or just use copy/paste.


If this is about cell references in formulas, you use $ to lock in the row, column, or both. $B1 or B$1 or $B$1 depending on what you need.

Automatic Incrementing a Number in Numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.