Ask Your Question

drag cell to move contents not working in Calc [closed]

asked 2014-02-07 16:44:41 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

New to LO and was working on a spreadsheet. I entered a number in one cell and text in another. I tried to move the cells down several rows but the cursor is not showing the proper moving symbol for dragging. The only option showing is the cursor changing to a + sign which fills all the cells. I use Excel and Numbers on a Mac OSX 10.9 and have no problem moving and have been using spreadsheets for over 20 years. Any idea what I am doing wrong or any specific setting for this?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-07-13 12:25:05.084808



I can't test on a Mac, but on Windows and Linux I find that if I click, drag and release to highlight a group of cells then click in the blue highlighted area, hold the click and drag then the highlighted cells are moved.

w_whalley gravatar imagew_whalley ( 2014-02-07 19:55:47 +0200 )edit

Like commenter cameleon below, on my Mac this does not work if selecting only one cell. Dragging one cell only results in selecting more cells; there seems to be no way to "select" only one cell for dragging.

cdort gravatar imagecdort ( 2014-04-16 19:20:26 +0200 )edit

To drag a single cell (on Windows and Linux) click in the cell and hold the button down, drag the cursor into an adjoining cell and back to the original cell, release the button. The cell stays selected, then click in the cell again, hold the button down and drag where you want.

w_whalley gravatar imagew_whalley ( 2014-04-16 21:18:22 +0200 )edit

w_whalley workaround works for me (Windows) as click and drag only works when cell(s) are highlighted. The bug / trick is to get one cell only highlighted!

jim109b gravatar imagejim109b ( 2014-07-31 11:16:24 +0200 )edit

It looks like the original poster and others are skipping a step: shift click. That's what enables it to work for me on Windows. If I shift click a single cell, then I can just drag it anywhere.

anotherguy gravatar imageanotherguy ( 2019-05-26 17:58:28 +0200 )edit

4 Answers

Sort by » oldest newest most voted

answered 2015-06-27 10:44:57 +0200

sancho.s gravatar image

Operations for marking cells for drag-and-drop are slightly different for a single cell or a range. See

Cell/s ready for usual drag-and-drop are shown with a different background and border color (light blue).

Single cell

Do one of the following:

  1. Click, then Shift-click the cell.
  2. Pressing the mouse button, drag a range across several cells, do not release the mouse button, and then drag back to the first cell. Release the mouse button.

Multiple cells

Simply click and drag across the range.

edit flag offensive delete link more


I'm familiar with this functionality, but it's not working. When I click the light blue region and drag, the mouse moves as though I didn't left-click (and hold). I just installed libreoffice 5 on Archlinux.

lmat gravatar imagelmat ( 2015-08-27 17:08:41 +0200 )edit

Same here. ArchLinux with LO 5.0.1. When you left-click and hold, it does not move the cells, it acts as if you didn't click.

nottin gravatar imagenottin ( 2015-10-15 06:04:02 +0200 )edit

answered 2019-02-02 15:27:10 +0200

updated 2019-02-02 15:32:41 +0200

To move a single cell: Select the cell and then SHIFT-CLICK to turn it blue. Then just drag as usual. To move multiple cells: Select the cells and drag as usual.

HOWEVER, if you have AUTOFILTER enabled on a table, then NOTHING works! The only things you can move will be outside the range of your autofiltered table. You cannot even insert new columns until you release your autofilter.

edit flag offensive delete link more


A no keyboard, one handed action option to select a single cell:

Click in the cell you want to select and, without releasing the mouse (or touchpad) button, move the pointer to a neighbour cell and return to the first, then release the mouse button.

LeroyG gravatar imageLeroyG ( 2020-05-03 02:19:25 +0200 )edit

answered 2016-11-04 11:16:05 +0200

malhaddi gravatar image

Yes, ROSt52, it works for several cells but the problem only when I want to drag only one cell. I also have this problem, hope I get a solution for that !!

edit flag offensive delete link more

answered 2014-02-08 11:49:47 +0200

ROSt52 gravatar image

Could make a test on Mac wit LibO 4.0.2 all works normal.

Select area
Click into the area
Move the area
Drop the moved area

edit flag offensive delete link more


doesn't work for me, after clicking into the area, moving cursor expand the area instead of moving the cell. Bu if you select multiple cells instead of just one, then you will be able to move them by drag and drop. OpenOffice and Libreoffice have always work like this :-(

cameleon gravatar imagecameleon ( 2014-02-09 18:04:32 +0200 )edit

Question Tools

1 follower


Asked: 2014-02-07 16:44:41 +0200

Seen: 7,265 times

Last updated: Feb 02 '19