The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

This page is outdated. You will be redirected to /wiki/Documentation/FAQ shortly.

Documentation / User FAQ / Calc / Previous-Next

How I change the order of sheets in my spreadsheet?

The simplest method to move a sheet is to grab its tab with the mouse, click on the tab with the mouse and hold the mouse button down, then drag the tab to its new position amongst the other tabs in the workbook. There are other methods to move (or copy) sheets too:

  1. Select the sheet you want to move.
  2. While still positioned over the sheet tab, click the right mouse button to access the context menu, then choose Move/Copy Sheet..., or in the pull-down menus go to Edit > Sheet > Move/Copy...
  3. In the Move/Copy dialog that appears, be sure that the check box labeled Copy is not set unintentionally. Place a tick at Copy only if you wish to copy the sheet instead of move it.
  4. Specify where to move the sheet in the Move/Copy pop-up box. Select an open document from the drop down menu labeled To document. Choose the position of the sheet in that document from the drop-down menu labeled Insert before.
  5. Click OK.

Documentation / User FAQ / Calc / Previous-Next

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.