content/documentation/faqs/spreadsheet/017.html

<meta http-equiv="REFRESH" content="10;url=http://wiki.services.openoffice.org/wiki/Documentation/FAQ">
<h3>This page is outdated. You will be redirected to <a href="http://wiki.services.openoffice.org/wiki/Documentation/FAQ">http://wiki.services.openoffice.org
/wiki/Documentation/FAQ</a> shortly.</h3>
<div style="margin-bottom: 10em;"></div>
<p><a href="../../index.html">Documentation</a> / <a
 href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
 href="016.html" accesskey="p">Previous</a>-<a href="018.html"
 accesskey="n">Next</a></p>
<h3>How I change the order of sheets in my spreadsheet?</h3>
<p>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:</p>
<ol>
  <li>Select the sheet you want to move.</li>
  <li>While still positioned over the sheet tab, click the right mouse
button to access the context menu, then choose <b>Move/Copy Sheet...</b>,
or in the pull-down menus go to <b>Edit &gt; Sheet &gt; Move/Copy...</b></li>
  <li>In the Move/Copy dialog that appears, be sure that the check box
labeled <b>Copy</b> is not set unintentionally. Place a tick at <b>Copy</b>
only if you wish to copy the sheet instead of move it.</li>
  <li>Specify where to move the sheet in the Move/Copy pop-up box.
Select an open document from the drop down menu labeled <b>To document</b>.
Choose the position of the sheet in that document from the drop-down
menu labeled <b>Insert before</b>.</li>
  <li>Click <b>OK</b>.</li>
</ol>
<p><a href="../../index.html">Documentation</a> / <a
 href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
 href="016.html" accesskey="p">Previous</a>-<a href="018.html"
 accesskey="n">Next</a></p>