Apache OpenOffice Community Forum

I'm just switching over and I'm very pleased so far.. however I really got used to pointing to the edge of a single cell and dragging it where I wanted it in Excell. I'm making simple lists, no formulas or anything.

I can accomplish the same exact thing in open office calc but only on multiple cells and I want to be able to do it on single cells. But it only expands the selection area instead of dragging the cell.

help and thank you.

Calc is much clumsier than Excel in this regard. You can only drag areas which are highlighted (black); you drag them by clicking and dragging the black area. The trick with a single cell is to get it selected: you have to click, drag out of the cell (now two cells turn black), then drag back into the first cell, and now you have a single black cell you can drag to another location. Remember to drag by clicking in the black area, not on the border like Excel.

You can also click on the cell, then Shift+click to select it (black), then drag it--but it's easier just to do it all with the mouse, since you're going to drag it anyway.

Edit: Note: OOo version 3 or later uses a transparent blue highlighting, instead of the plain black, reverse video-style highlighting.

wow, that is awkward.. but it works so cool.. Thanks for the information!

It is very useful for us in Bangladesh. I have translated it in Bengali and posted with link for help another on www.forum.linux.org.bd.

Be aware that moving a cell using this method (or using cut & paste) will take all the formatting with it. It also changes the old original celll to Default Formatting. If you want to keep the formatting in the original cell, use copy & paste then go back to the original cell location and hit the delete key.