How to prevent number increment when using AutoFill by dragging in Excel

For example, the cell A2 is filled with KTE00251, and you need to fill below cells with the same content of this cell. When we drag Cell A2’s AutoFill handle down, the number automatically increase (see below screenshot). So is there any way to prevent number from incrementing when using AutoFill in Excel. Below method will help you get it done.

More details: