Tab Placement When a new worksheet is created, its tab is placed to the left of the tab you right clicked. To move a worksheet within a workbook, click on the name tab and drag it to the new location. When selected, the cursor changes to a page icon and a small triangle points to where the worksheet tab will be placed when you let go.
Learn more about XL Adding worksheets