![Image](http://shamskm.com/forum/exceltutor/Autosumshortcut/how_to_stop_auto_increment_in_excel.jpg)
But if you have a situation where you want your number to remain same throughout the cells while you are dragging it down, how to get it?
The easiest and best way is to hold down the Ctrl key while you are dragging cell B3 (which contains me1 in the example) down your column. Nothing more
![Smile :-)](./images/smilies/icon_smile.gif)
![Image](http://shamskm.com/forum/exceltutor/Autosumshortcut/how_to_stop_auto_increment_in_excel_figure2.jpg)
Have fun
![Smile :-)](./images/smilies/icon_smile.gif)