Excel: Permanently disable/stop auto-increment when dragging down cells (drag-and-drop)
I'm working on a form with many rows that user need to fill. Often they drag down (drag-and-drop) cell values to popluate rows that have the same values over several rows. Auto-increment (see below), causes multiple false values in my Excel form.
How can I permanently disable auto-increment to obtain the following:
I know the easiest way would to hold down Ctrl while dragging down, but users filling the from typically do not know this. Same applies to other solutions to be applied by the users themself.
I may also disable drag-and-drop completely in the Excel settings under advanced, but this would limit the functionality of the form.
Any ideas? Ready to use VBA solutions are welcome.
Note: I do not search a solution avoiding the problem for me, I need a solution avoiding the problem for users filling the form!
Instead of filling in one cell then dragging the cell handle, select all the cells where you want a value, then type and press Ctrl+Enter to fill that value in all of them (or a formula, or whatever).
If you already have a value, select all the cells where you want it (continuous or otherwise), then press F2 to go into edit mode, then Ctrl+Enter.