How do you change the worksheet order in Microsoft Excel?

Answer 1

Right-click on the tab at the bottom of the worksheet and name it to whatever you like. After you have named the worksheets, click the tab and drag to a location on the tab row to whatever position you like. There is no method (except for writing a custom visual basic for applications program) to automatically rearrange the worksheet names on the tab row.

Answer 2

Click the worksheet tab you want to move to select it. Click again (not double click) and hold the mouse button to drag the sheet to the position you want it amongst the other worksheets. Release the mouse button and you're done.

Alternatively you can right click on the tab you wish to move and choose 'move or copy'. Select which sheet you want to move before and click OK.

Answer 3

Select all the words with the mouse. Then click the A to Z icon on the toolbar, or go to the Data menu and pick Sort and sort it that way.