ALL ABOUT OFFICE

EXCEL

HOME

ACCESS

EXCEL

WORD

OUTLOOK

POWERPOINT

Changing the Order of Worksheets

You can move worksheets to a different position in the workbook or even to another workbook.  If you click on the Edit drop-down menu and choose Move or Copy Sheet, the window shown below appears.  If you want to move or copy the sheet to a different workbook you must first make sure you have opened that workbook as well and you can then choose the workbook from the drop-down list at the top of the window.  The position of the sheet is then chosen from the list at the bottom of the window, select the sheet that will come after the one you are moving.  If you want to copy the sheet elsewhere, make sure you click on the Copy box to enter a tick in it, your original sheet will now stay where it is and a copy will be placed in the new position.

Moving sheets can affect formulas that have been set up using 3-D references, make sure the results of your calculations still look correct after you have moved or copied a sheet.

Click here to return to the Excel index.

webmaster@allaboutoffice.co.uk