How I change the order of sheets in my spreadsheet?

From Apache OpenOffice Wiki
< Documentation‎ | FAQ‎ | Calc‎ | Miscellaneous
Revision as of 14:02, 4 November 2008 by Ufi (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


How 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

Note:

  • If you check the Copy option in the dialog, the sheet will copied, not moved.



Personal tools