| View previous topic :: View next topic |
| Author |
Message |
netconuk
Newbie
Joined: 07 Nov 2007
Posts: 4
|
 Posted: Wed Nov 07, 2007 4:42 am Post subject: Moving a highlighted cell like in Excel |
 |
|
One of the really nice features in Excel was the ability to be able to highlight a range of cells and move them with the mouse by grabbing the border of the selection. I can't seem to do this in Calc. Is there any way?
-Jerry |
|
| Back to top |
|
 |
huwg
Super User
Joined: 14 Feb 2007
Posts: 890
|
| Posted: Wed Nov 07, 2007 4:57 am Post subject: |
|
|
| It's even easier in Calc - you drag selected cells by clicking anywhere in the black highlighting, rather than having to precisely click on the border. |
|
| Back to top |
|
|
keme
Moderator
Joined: 30 Aug 2004
Posts: 2732
Location: Egersund, Norway
|
| Posted: Wed Nov 07, 2007 5:09 am Post subject: |
|
|
| Dragging only one cell isn't as obvious, though. You have to "highlight" it first. If you drag from your cell to another, then back to the original cell, you should have only that cell highlighted (or should I say "lowlighted"...) and can drag it, just like huwg says. |
|
| Back to top |
|
|
huwg
Super User
Joined: 14 Feb 2007
Posts: 890
|
| Posted: Wed Nov 07, 2007 5:56 am Post subject: |
|
|
Didn't they recently change the selection method for a single cell? I think there was a plan for it to be possible using a slow double-click.
Edit: typo.
Last edited by huwg on Thu Nov 08, 2007 3:53 am; edited 1 time in total |
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Wed Nov 07, 2007 6:02 am Post subject: |
|
|
| huwg wrote: | | Didn't they recently change the selction method for a single cell? I think there was a plan for it to be possible using a slow double-click. |
I don't see that, but just playing around I see a neat way to copy from one cell to another. It doesn't copy format though. Triple click and then drag the selection.
David |
|
| Back to top |
|
|
netconuk
Newbie
Joined: 07 Nov 2007
Posts: 4
|
| Posted: Thu Nov 08, 2007 3:09 am Post subject: |
|
|
Thanks you all for your help. Cracked it!
-Jerry |
|
| Back to top |
|
|
|
