Forum Discussion

Robert Ertsey's avatar
Robert Ertsey
Copper Contributor
Sep 12, 2018

Excel autofill combination of letters and numbers

How do I autofill combination of letters and numbers so that the numbers increment by 1.  Example: TMT111, TMT112, TMT113 etc...   Thanks
excel
CliffP's avatar
CliffP
Copper Contributor
Dec 29, 2018

Hi Kim,

Thanks for your reply.

The icon that comes up when I drag the crosshairs down is the Quick Analysis tool.

Lorenzo Kim wrote:

How do I open up the icon that you show in your screenshot?

(You've probably gathered my computer skills are limited!)

Thanks,

Cliff

 

 

 

 

  • Lorenzo Kim's avatar
    Lorenzo Kim
    Bronze Contributor
    Dec 29, 2018

    point to the left lower corner of the box, click the icon then select fill...

    HTH

Resources