The Lumber Room

"Consign them to dust and damp by way of preserving them"

Moving rows in OO.o Calc ( Spreadsheet)

with 4 comments

It turns out that neither Calc nor Gnumeric has an option to move (or swap) rows (or regions) up and down (while MS Excel does). (Someone asked about moving rows in Calc on their mailing list.)

Bugs have been filed (at least) at

I installed the CellMover macro from, and it works perfectly.

Rather perversely, the documentation on how to install this library (and others) is in another library entirely, which can be got from their site.

Update: See the comments; it appears to have been fixed now.

Written by S

Sun, 2006-06-11 at 19:32:00

Posted in compknow

4 Responses

Subscribe to comments with RSS.

  1. Thanks for the update; I wouldn’t have noticed it.


    Tue, 2008-03-04 at 16:48:52

  2. Hold alt while moving to swap the rows out.


    Fri, 2010-08-20 at 02:35:14

  3. holding alt while moving is nice.. thanks Anonymous.

    Also Anonymous

    Mon, 2013-02-25 at 19:38:31

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: