Jul 11 2021 04:34 PM
I am trying to understand the Excel rules for changing cell contents when copying down by dragging the cell handle. They do not appear to be consistent. For example:
I cannot tell what the rhyme or reason is and am not aware of a setting that controls this.
Jul 11 2021 10:21 PM
@RLevkoy Any text ending with a digit will increase by 1 when you just drag it down by the fill handle. So, "Text1" becomes "Text2", "Text3" etc, Pressing Alt while dragging cancels the automatic incrementing of the number. So you will get "Text1", "Text1", "Text1" etc,