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

English
,
#1

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

#2
  • 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

3 Likes
#3

You could read the help instead:
https://help.libreoffice.org/latest/en-US/text/scalc/guide/move_dragdrop.html

2 Likes
#4

What is AI doing wrong? See Hallucination (artificial intelligence) - Wikipedia

#5

No, in Excel you’ve got to drag the border of a cell or cell range.
In Calc you’ve got to highlight the cell or cell range before you can grab the selection anywhere.

#6

Thanks @EarnestAI very clear visuals, and that works.

PS: Are you human, or pure AI genius? :grinning:

#7

In fact I did, sady all those words didn’t help. FWIW, if EarnestAI’s visual was in the help I wouldn’t have needed to ask.

#8

The administrators were kind enough to change the font for the names to a serif font to make it clear the last letter is an L

#9

oops … sorry Al, hard to distinguish I from I , in this font at least. I can see the diff in your font, subtle.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.