On 10/12/2010 10:34 AM, Johnny Rosenberg wrote:
Den 2010-10-12 12:04:10 skrev Earl Melton <earlemel...@yahoo.com>:



On 10/11/2010 01:55 PM, Johnny Rosenberg wrote:
Den 2010-10-11 14:08:12 skrev Kosie Olivier <koos.olivi...@gmail.com>:

I have a problem on OpenOffice - my arrow keys do not move cells on a
spreadsheet anymore like it did before. What can I do?

Hope you can help me!

JPH Olivier koos.olivi...@gmail.com

Why do you still use the very old OpenOffice.org 2.0?

And what do you mean when you say ”move cells”? I have never been able
to do that with the arrow keys alone.

I ws pretty sure I had done it before, but just now confirmed it on my
Ubu 3.2.0 and it worked fine. I selected three contiguous cells, then
placed the mouse pointer on the very edge of the selection and moved
it down to the next row, then back where they belong. Duck soup!

Yes, the mouse, but you was asking about the arrow keys?

Sorry, I realized this after posting the reply to the OP. Helps if you [thoroughly] read the original query, doesn't it? :-(

And placing the mouse pointer at the edge is an Excel thing, you don't
need to do that in OpenOffice.org. Just place it anywhere in the cell
range and move it. If you want to move a single cell, you need to make
sure it is highlighted, for example by selecting two cells and then move
the mouse pointer back to the first cell again without releasing the
mouse button, or by Shift+Click on the cell you want to highlight and
then move it.

I also went back and confirmed this after clicking Send. I very seldom have the occasion/need to move cells, but this -- like so many other things -- is so much easier in OOo than in MSO. Thanks for the Shift+Click tip for moving a single cell. I had never used or known about that one. I usually just copy/pasted, then deleted original cell contents.

Also, I'll admit that, while I've used Writer for years (due to the ease of creating an alphabetized index), I hadn't really used Calc all that much until my switch to Linux. FTM, I was never really what one could call a 'power' user of Excel!

--
Have a blessed day!
  <>< Earl

--

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org

Reply via email to