How to disable sequential numbering for a *specific* column in spreadsheet?

%3CLINGO-SUB%20id%3D%22lingo-sub-2511299%22%20slang%3D%22en-US%22%3EHow%20to%20disable%20sequential%20numbering%20for%20a%20*specific*%20column%20in%20spreadsheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2511299%22%20slang%3D%22en-US%22%3E%3CP%3EWould%20anyone%20be%20kind%20enough%20to%20help%20me%20solve%20disabling%20sequential%20numbering%20for%20specific%20columns%20in%20my%20spreadsheet%3F%20It's%20confidential%20information%20for%20work%20so%20I%20cannot%20share%20but%20essentially%20I%20want%20to%20drag%20a%20row%20down%20to%20automatically%20copy%20cells%20instead%20of%20filling%20series%20by%20default.%20So%20if%20I%20had%20something%20like%20TELC-18Z009%2C%20I%20want%20it%20to%20copy%20instead%20of%20TELC-18Z010%2C%2011%2C%20etc.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20I%20can%20outright%20disable%20the%20drag%20%2B%20fill%20feature%2C%20but%20the%20sequential%20numbering%20feature%20is%20useful%20for%20other%20columns%20I%20have%20in%20the%20spreadsheet.%20I%20know%20that%20I%20can%20also%20hold%20ctrl%20as%20I%20drag%20and%20fill%20but%20I'd%20like%20to%20stop%20doing%20that%20and%20just%20straight%20up%20drag%20%2B%20fill%20instead.%20I've%20tried%20changing%20the%20column%20'Number%20format'%20to%20'Text'%20but%20that%20hasn't%20resulted%20in%20anything%20new.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%20curious%20to%20hear%20if%20there's%20a%20way%20to%20change%20the%20default%20outcome%20after%20dragging%20%2B%20filling.%20For%20some%20of%20my%20columns%20the%20pop-out%20button%20is%20'Copy%20Cells'%20and%20for%20others%20it%20is%20'Fill%20Series'.%20If%20I%20can%20find%20a%20way%20to%20force%20it%20to%20default%20to%20one%20or%20the%20other%20that%20would%20also%20be%20a%20great%20workaround.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2511299%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2511396%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20disable%20sequential%20numbering%20for%20a%20*specific*%20column%20in%20spreadsheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2511396%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1094233%22%20target%3D%22_blank%22%3E%40TonyOne_Savage%3C%2FA%3E%26nbsp%3BPress%20and%20hold%20the%20alt-key%20while%20dragging%20down.%20That%20should%20do%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2511398%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20disable%20sequential%20numbering%20for%20a%20*specific*%20column%20in%20spreadsheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2511398%22%20slang%3D%22en-US%22%3EOne%20workaround%20is%20that%20you%20can%20use%20a%20formula%3CBR%20%2F%3E%3D%22TELC-18Z009%22%3CBR%20%2F%3EThat%20way%20if%20you%20drag%2C%20you%20just%20copy%20the%20formula%20and%20the%20value%20is%20always%20the%20same.%3C%2FLINGO-BODY%3E
New Contributor

Would anyone be kind enough to help me solve disabling sequential numbering for specific columns in my spreadsheet? It's confidential information for work so I cannot share but essentially I want to drag a row down to automatically copy cells instead of filling series by default. So if I had something like TELC-18Z009, I want it to copy instead of TELC-18Z010, 11, etc. 

 

I know I can outright disable the drag + fill feature, but the sequential numbering feature is useful for other columns I have in the spreadsheet. I know that I can also hold ctrl as I drag and fill but I'd like to stop doing that and just straight up drag + fill instead. I've tried changing the column 'Number format' to 'Text' but that hasn't resulted in anything new. 

 

Also curious to hear if there's a way to change the default outcome after dragging + filling. For some of my columns the pop-out button is 'Copy Cells' and for others it is 'Fill Series'. If I can find a way to force it to default to one or the other that would also be a great workaround. 

 

Thank you!

 

3 Replies

@TonyOne_Savage Press and hold the alt-key while dragging down. That should do it.

One workaround is that you can use a formula
="TELC-18Z009"
That way if you drag, you just copy the formula and the value is always the same.
For me it is the <ctrl> key that will stop the increment (force copy instead of sequence) as noted in the original post.
That said another alternative I found is you can click and drag using the right mouse button and it will bring up a contextual menu with multiple options (similar to pop-out button but automatically opens). Not sure that really solves the original complaint though.