Insert an Excel worksheet after a specific sheet

How to insert a single Excel worksheet after a specific sheet using Excel, VBA and Shortcut methods

METHOD 1. Insert an Excel worksheet after a specific sheet using the New sheet button option

EXCEL

Select a sheet after which you want to insert a new worksheet > Click New sheet button

1. Select the sheet after which you want to insert a new worksheet.
2. Click on the New sheet button.
Note: in this example a new worksheet will be inserted after Sheet2, given we have selected Sheet2.

Select a specific sheet and click on the New sheet button - Excel

METHOD 1. Insert an Excel worksheet after a specific sheet using VBA

VBA

Sub Insert_Worksheet_After_a_Specific_Sheet()

'insert a new worksheet after a sheet named Sheet2
Worksheets.Add After:=Sheets("Sheet2")

End Sub

PREREQUISITES
Sheet Name: Have a sheet named Sheet2, this can be either a worksheet or a chart sheet.

ADJUSTABLE PARAMETERS
Sheet Name: Select the sheet after which you want to insert a new worksheet by changing the Sheet2 sheet name in the VBA code to any sheet in the workbook.

METHOD 2. Insert an Excel worksheet after a specific worksheet using VBA

VBA

Sub Insert_Worksheet_After_a_Specific_Worksheet()

'insert a new worksheet after a worksheet named Sheet2
Worksheets.Add After:=Worksheets("Sheet2")

End Sub

PREREQUISITES
Worksheet Name: Have a worksheet named Sheet2.

ADJUSTABLE PARAMETERS
Worksheet Name: Select the worksheet after which you want to insert a new worksheet by changing the Sheet2 worksheet name in the VBA code to any worksheet in the workbook.

METHOD 3. Insert an Excel worksheet after a specific chart sheet using VBA

VBA

Sub Insert_Worksheet_After_a_Specific_Chart_Sheet()

'insert a new worksheet after a chart sheet named Analysis Chart
Worksheets.Add After:=Charts("Analysis Chart")

End Sub

PREREQUISITES
Chart Sheet Name: Have a chart sheet named Analysis Chart.

ADJUSTABLE PARAMETERS
Chart Sheet Name: Select the chart sheet after which you want to insert a new worksheet by changing the Analysis Chart chart sheet name in the VBA code to any chart sheet in the workbook.

Insert a new worksheet after a specific sheet using a Shortcut

SHORTCUT

WINDOWS SHORTCUT

Shift

F11

NOTES
The shortcut will insert a new worksheet in front of an active sheet. Therefore, to insert a new worksheet after a specific sheet you need to activate (select) the sheet to the right of where you want to insert a new worksheet and then action the shortcut.

Explanation about how to insert a worksheet after a specific sheet

EXPLANATION

EXPLANATION
This tutorial explains and provides step by step instructions on how to insert a single worksheet after a specific sheet using using Excel, VBA and Shortcut methods.

Excel Methods: Using Excel you can insert a new worksheet after a specific sheet with the New sheet button.

VBA Methods: Using VBA you can insert a new worksheet after a specific sheet, worksheet or chart sheet by referencing to a Sheets, Worksheets or Charts object, respectively. If you intend to insert a worksheet after a specific worksheet or a chart sheet you will need to have at least one worksheet or chart sheet, respectively, in a workbook.

Shortcut Method: Using a Shortcut in this tutorial you can insert a new worksheet after a specific sheet by activating (selecting) the sheet to the right of where you want to insert a new worksheet and actioning the shortcut.

ADDITIONAL NOTES
Note 1: Using the New sheet button, a new worksheet will be inserted after an active sheet.

Related Topic	Description	Related Topic and Description
Insert multiple Excel worksheets	How to insert multiple Excel worksheets at the same time using Excel, VBA and Shortcut methods
Insert an Excel worksheet	How to insert a single Excel worksheet using Excel, VBA and Shortcut methods
Insert an Excel worksheet as the last sheet	How to insert a single Excel worksheet as the last sheet using Excel and VBA methods
Insert an Excel worksheet as the first sheet	How to insert a single Excel worksheet as the first sheet using Excel, VBA and Shortcut methods
Insert an Excel worksheet before a specific sheet	How to insert a single Excel worksheet before a specific sheet using Excel, VBA and Shortcut methods