1. Home
  2. Split a Book

Split a Book

Select menu: Spread | Book | Split

Use this to create new books containing a selection of sheets from the current book. The new books can be created by either copying or moving the sheets from the current book. Note that if sheets are moved from a book, then at least one sheet must remain present in the current book. 

  1. From the menu select Spread | Book | Split.

    The left pane of the dialog lists the spreadsheets in your current book. The Columns in sheet field displays the number of columns in the currently selected sheet; this list is for information purposes only.

  2. Double-click your required spreadsheets in the left pane to move them to the Selected sheets field. You can select multiple spreadsheets by holding down Ctrl while clicking with the mouse then click  to move them all across in one action.

Select sheets to split into new book

This lists all the sheets in the current book. 

Selected sheets

This lists the currently selected sheets that will be opened in new books. You can remove a sheet from the list by either double clicking on the item or by selecting one or more items and clicking on the button.

Columns in sheet

This list displays the columns within the sheet that is currently selected within the Select sheets to split into new book list. This list is for information only.

Action for selected sheets

  • Move – move the selected sheets into a new book. Sheets that are moved will be deleted from the original book.
  • Copy – copy the selected sheets into a new book.

Split to single-page books

When selected, each sheet will be created in a separate book where each book will contain a single page.

Action buttons

OK Split the book and close the dialog.
Cancel Close the dialog without further changes.
Clear Remove names from the Selected sheets list.

See also

Updated on March 21, 2019

Was this article helpful?