How to change where new sheet appears

[evilbrent]

I don't know how I've done it, but for some reason when I open a new worksheet it appears to the left of the current tab, rather than to the right.

Does anyone know how to put it back so that the + button adds the new sheets to the right?

[Sam Capricci]

just click on the tab and hold down and move it where you want, another way is to right click on the tab and a box will appear with one of the selections being move or copy, click on move or copy, then another box opens which allows you to select the sheet you want it to appear before (or create a copy), select the tab from the list you want it to come before and hit ok.

[evilbrent]

Thanks, but that's not what I mean sorry.

I mean that I'm used to new tabs appearing to the right of current tab when I create them, but they're appearing to the left.

When you have a workbook with one worksheet, and you hit the + button a few times, you expect it to read Sheet1 Sheet2 Sheet3 etc ->, but mine is reads

<- etc Sheet3 Sheet2 Sheet1

Oh this is doing my head in. It's stopped. It was doing it the wrong way an hour ago, and now it's doing it the right way. I don't know what's going on. Thanks.