Ask Your Question

Move a page to another document?

asked 2015-07-23 19:16:38 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

How in the world do I move (either by copy/paste or dragging & dropping) a single page from a multiple page existing document to a new document? Lord have mercy Ive been searching around trying to find a simple answer to this "how do I" for hours. Whew ... exhausting! Somebody help me ... please lolbvvvs!!

Thanks in advance ;)

edit retag flag offensive close merge delete


I believe that there is a difference in how the software acts between selecting everything on a page with [Ctrl-End] (that is, all the "used" cells) vs. selecting it with [Ctrl-A] (or Edit> Select All). The first does not respect the complete formatting of the source, while the second duplicates it.

jcarls gravatar imagejcarls ( 2015-07-30 17:14:50 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2015-07-23 21:12:19 +0200

Alex Kemp gravatar image

updated 2015-07-23 21:19:08 +0200

Try this:-

  1. Open source document & destination document
    (if destination is to be a new doc then simply create it)
  2. Select all of your source page
  3. Copy it
    (menu):-Edit | Copy
    (or) Ctrl+C (both keys at the same time)
    (or) Ctrl+Insert (both keys at the same time)
  4. Click in the Destination document at the point to paste the page
  5. Paste it
    (menu):-Edit | Paste
    (or) Ctrl+V (both keys at the same time)
    (or) Shift+Insert (both keys at the same time)

The one problem that may occur comes if the source document has a different selection of embedded styles/colours/etc. within it, in which case you may need to adjust the formatting.

Another option available is to only copy the text within the source. The following also works if the source is a web-page & many other format source-documents:-

Change (5) to:-

  1. Special Paste it
    (menu):-Edit | Paste Special...
    (or) Ctrl+Shift+V (all 3 keys at the same time)
  2. Select "Unformatted text"
  3. Format the way that you want it.

Finally, if you want to delete the source-page after copy then, in the source document whilst the page is selected:-

  1. (menu):-Edit | Cut
    (or) Ctrl+X (both keys at the same time)

If this helps then please tick the answer (✔).

edit flag offensive delete link more

answered 2015-07-30 03:12:13 +0200

In Calc right-click on the tab name and in the context Menu chose Move/Copy Then a small window comes with 3 zones. If you have several tabs the 1st zone allows you to chose between Move an Copy, the 2nd one to chose the destination place with a scrollable Menu that includes "New Document" and in the 3rd zone you can rename the sheet.

edit flag offensive delete link more


The above answer may be true for the version that was current in 7/15, but has changed in v The FIRST zone includes "new document." In fact, that zone is called "To document," and defaults to the current document.

koshari gravatar imagekoshari ( 2017-10-17 00:36:17 +0200 )edit
Login/Signup to Answer

Question Tools



Asked: 2015-07-23 19:16:38 +0200

Seen: 2,617 times

Last updated: Jul 30 '15