How can I change the order of sheets in my spreadsheet?

From Apache OpenOffice Wiki
Jump to: navigation, search


How can I change the order of sheets in my spreadsheet?


You can move a sheet to a different position, click and hold the sheet tab at the bottom of the screen with the mouse and drag it to its new position.

You can also move sheets (even across different documents) using the menu:

  1. Right-click the sheet you want to move and select Move/Copy Sheet... from the pop-up menu, or
    select Edit - Sheet - Move/Copy from the main menu.
  2. Specify the new position of the sheet in the dialog.
    You can even move the sheet to a different document that is opened in Calc.
  3. Click OK.
Documentation note.png If you check the Copy option in the dialog, the sheet will be copied, not moved.



Personal tools