How to drag an existing cell, or cells, to new location in Calc

ChrisJ7903 · July 28, 2025, 11:07pm

I’m having difficulty dragging cells in Calc.

In MS Excel it’s done by click. hold, drag.

According to Gemini to do the same in Calc use the ALT key or Shift-ALT but I can’t get this to work … today! I did get it to work briefly a few weeks ago, so it may simply be a matter of key sequencing. But no luck today so far …

Here’s the main sequence I’m using:

Click and Hold on cell(s)
Press and Hold ALT
try to drag (but doesn’t work)

or:

Click and Hold on cell(s)
Press and Hold Shift+ALT
try to drag (but doesn’t work)

What am I doing wrong?
I am on UBUNTU 24.10

TIA

EarnestAl · July 29, 2025, 1:48am

For just one cell: Drag select the cell and continue to include a neighbouring cell then, while still not having released the mouse button, drag back to the original cell which will now a a blue selection background. Release the mouse button then click and drag the cell to your desired location
For more than one cell: select the cells, release the mouse button then click and drag to desired location

CalcDragCell