Example. When I copy the value $18.00 by dragging it to the adjacent empty cell, either vertically or horizontally, it is copied as $19.00. I would like to stop this incrementation but I can’t find how to do this.
Help!
Ctrl-Dragging
1 Like
Tibor:
Thanks for the reply. I tried your suggestion Ctrl-Drag. I didn’t work. The value dragged to the new cell still incremented by +1. I am surprised that there doesn’t seem to be a way to turn off this action.
I had a good friend by the name of Tibor. Everyone called him Tibe. His surname was Fazikas, Hungarian heritage.
Regards.
Albert…
1 Like
Tibor:
I just tried Ctrl-Drag on another spreadsheet, and it worked. No increment.
Thanks.
Albert…
1 Like
There is. The same method described by @Zizi64 works for me.
.
Try to wtite a figure in a cell, enter, then grab the square handle of the cell and drag down (without releasing the left mouse button). You should see a preview of the values ro be inserted, now press also Ctrl-key (or press and hold before grabbung the cell-handle). You should see the value(s) changing. Release the mouse button.
.
But maybe: Are you using MacOS? (Often has its own ideas to handle keyboard)
Wanderer:
Thank you very much for your reply and instruction regarding my “incremented value” question. I tried what you said, and it works as you describe. Much appreciated.
I still think that there should be a way to stop the value in a spreadsheet cell from incrementing automatically by default when using the cell handle to drag it to a horizontal of vertical adjacent cell. I believe this automatic increment is not what most users would want to happen, most times. I have looked everywhere I can think of under my LibreOffice’s “Customize…” and “Options…” functions and can’t find a way to do this. Bummer.
I am running LibreOffice on my Dell desktop computer and Windows 11 is my OS.
Regards.
Albert…
Another? Just hold Ctrl.
Try with Ctrl+D, to duplicate the upper cell.
LeroyG:
Just holding the Ctrl key works. Thanks for the tip. I still think there should be some way to stop the increment by default.
Regards.
Albert…