Forum Discussion
Rules for copying down
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: If I have a phone number in a...
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,