You can change the order of the sheets in a book in one of the following ways.
Change the order of sheets by dragging and dropping
1.In the sheet tab bar, left-click the sheet tab you want to move.
2.Drag it left or right along the sheet tab bar.
Change the order of sheets using the context menu
1.Right-click the sheet tab you want to move.
2.From the context menu, select:
•Move to beginning to make the sheet first.
•Move to end to make the sheet last.