Jul 02 2021 09:42 AM
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!
Jul 02 2021 09:59 AM
@TonyOne_Savage Press and hold the alt-key while dragging down. That should do it.
Jul 02 2021 09:59 AM
Jul 02 2021 11:22 AM