Difference between revisions of "Documentation/FAQ/Calc/Miscellaneous/How I change the order of sheets in my spreadsheet?"
From Apache OpenOffice Wiki
< Documentation | FAQ | Calc | Miscellaneous
(New page: {{DISPLAYTITLE: How I change the order of sheets in my spreadsheet?}} <section begin=question/> '''How I change the order of sheets in my spreadsheet?''' <section end=question/> <section...) |
m |
||
| Line 1: | Line 1: | ||
| − | {{DISPLAYTITLE: How I change the order of sheets in my spreadsheet?}} | + | {{DISPLAYTITLE: How can I change the order of sheets in my spreadsheet?}} |
<section begin=question/> | <section begin=question/> | ||
| − | '''How I change the order of sheets in my spreadsheet?''' | + | '''How can I change the order of sheets in my spreadsheet?''' |
<section end=question/> | <section end=question/> | ||
| Line 10: | Line 10: | ||
You can also move sheets (even across different documents) using the menu: | You can also move sheets (even across different documents) using the menu: | ||
| − | # Right-click the sheet you want to move and select '''Move/Copy Sheet...''' from the pop-up menu, or<br>select '''Edit - Sheet - Move/Copy''' from the main menu | + | # Right-click the sheet you want to move and select '''Move/Copy Sheet...''' from the pop-up menu, or<br>select '''Edit - Sheet - Move/Copy''' from the main menu. |
| − | # Specify the new position of the sheet in the dialog.<br>You can even move the sheet to a different document that is opened in Calc | + | # Specify the new position of the sheet in the dialog.<br>You can even move the sheet to a different document that is opened in Calc. |
| − | # Click '''OK''' | + | # Click '''OK'''. |
| − | + | {{Documentation/Note | If you check the '''Copy''' option in the dialog, the sheet will be copied, not moved.}} | |
| − | + | ||
Revision as of 08:43, 12 May 2009
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:
- 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. - 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. - Click OK.
