Forum Discussion

Katy_Jones's avatar
Katy_Jones
Copper Contributor
Apr 24, 2024

New sheet at end of workbook

Previously new sheets were always added at the end of the workbook, whereas now, new sheets are inserted after the selected worksheet:

How can I change the default behaviour so as to put the new sheet at the end of the workbook?

I know I can drag the new tab, or select the last tab before adding the new one, but this is adding extra steps when it used to work differently.

I've checked Options and searched online and have found many different ways of inserting sheets, but nothing to put it at the end! Thanks for any advice.

excel

2 Replies

Sort By
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Apr 24, 2024

    Katy_Jones 

    As far as I know, you cannot change the default behavior.

    You can create a small macro in your personal macro workbook PERSONAL.XLSB:

    Sub NewSheet()
    On Error GoTo ErrHandler
    Worksheets.Add After:=Sheets(Sheets.Count)
    Exit Sub
ErrHandler:
    Beep
End Sub

    You can assign a custom keyboard shortcut and/or a custom Quick Access Toolbar button to this macro for convenience.

Resources