You can rearrange the spreadsheets in a book by clicking a tab and dragging the sheet to another position. The cursor changes to when you are dragging the sheet and an arrowhead indicates where the sheet will be placed when you drop it.
If you have a workbook with many sheets, a more expedient method for rearranging them is to list each spreadsheet in the book then reposition the sheets within this list.
- Right-click any tab in your workbook and select Reorder Sheets from the shortcut menu.
The Sheet Order field lists all the spreadsheets in your book.
- Select a spreadsheet then use the buttons on the right to move the sheet up or down as required.
Moving a sheet up moves it to the left, while moving it down moves it to the right.
- Click OK when you’re done.