On 11/03/2008 22:09, Mike Field wrote:
Hi,
Excel has the ability to Cut one or more rows (or columns) and then
Insert Cut Rows (or Columns) at another position, thereby moving the
rows (or columns).
I haven't been able to find a way of doing the same thing in
OpenOffice Calc.
The best I've been able to do is Cut the rows (which just clears the
contents), delete the unwanted rows, Insert the correct number of rows
at the new position, then paste the contents into them.
That's four operations, where Excel can do it in two.
Does anyone know a quicker way of moving a range of rows (or columns)
to a new position?
I did see the recent reply to a similar question about tables in
Writer, but I'm talking about Calc.
Mike Field (UK)
I'm confused. In Calc, select the columns/rows and do Edit>Cut or
Ctrl-C. Move to the column/row which is to be the first of the new data
and select it (click in the column/row heading - not *your* heading,
Calc's: the A, B, C, ... for columns or 1, 2, 3, ... for rows). Now do
Edit>Paste or Ctrl-V. The data are moved. If you did copy originally the
data are copied. It just works. This in OpenOffice 2.2 on Win XP Pro.
If you want data to the right of /below the about-to-be-pasted data to
move to make way for that data, use Paste-Special and select the
relevant "shift cells" radio button shown bottom right of the pane.
Granted the cut operation only cuts the data, not the rows/columns so
that is one extra operation. If you like you can customise one of the
toolbars to display the Delete Columns button and/or Delete Rows button.
If you do this then you just click the relevant button after cutting the
data and while the columns/rows are still selected.
--
Harold Fuchs
London, England
Please reply *only* to users@openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
