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

METHOD 1. Insert an Excel worksheet before a specific sheet using the sheet option

EXCEL

Right-click on a sheet before which you want to insert a new worksheet > Insert > Worksheet > OK

1. Right-click on a specific sheet before which you want to insert a new worksheet.
2. Click Insert.
Note: in this example a new worksheet will be inserted in front of Sheet2, given we have right-clicked on Sheet2.

Right-click on a specific sheet and select Insert - Excel

3. Select Worksheet and click OK.

METHOD 2. Insert an Excel worksheet before a specific sheet using the ribbon option

EXCEL

Select a sheet before which you want to insert a new worksheet > Home tab > Cells group > Insert > Insert Sheet

1. Select a specific sheet.
Note: in this example a new worksheet will be inserted in front of Sheet2, given we have selected Sheet2.

2. Select the Home tab.

3. Click Insert in the Cells group.
4. Click Insert Sheet.

Click Insert and click Insert Sheet - Excel

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

VBA

Sub Insert_Worksheet_Before_a_Specific_Sheet()

'insert a new worksheet before a sheet named Sheet2
Worksheets.Add Before:=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 Selection: Select the sheet before 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 before a specific worksheet using VBA

VBA

Sub Insert_Worksheet_Before_a_Specific_Worksheet()

'insert a new worksheet before a worksheet named Sheet2
Worksheets.Add Before:=Worksheets("Sheet2")

End Sub

PREREQUISITES
Worksheet Name: Have a worksheet named Sheet2.

ADJUSTABLE PARAMETERS
Worksheet Selection: Select the worksheet before 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 before a specific chart sheet using VBA

VBA

Sub Insert_Worksheet_Before_a_Specific_Chart_Sheet()

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

End Sub

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

ADJUSTABLE PARAMETERS
Chart Sheet Selection: Select the chart sheet before 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 worksheet before 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 before a specific sheet you need to activate (select) the sheet in front of which you want to insert a new worksheet and then action the shortcut.

Explanation about how to insert a worksheet before a specific sheet

EXPLANATION

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

Excel Methods: Using Excel you can insert a new worksheet before a specific sheet with a ribbon or sheet option.

VBA Methods: Using VBA you can insert a new worksheet before a specific sheet, worksheet or chart sheet by referencing to a Sheets, Worksheets or Charts object, respectively. If you intend to insert a worksheet before 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 you can instantly insert a new worksheet in front a specific sheet by activating (selecting) the sheet in front of which you want to insert a new worksheet.

ADDITIONAL NOTES
Note 1: Using the sheet or ribbon option, a new worksheet will be inserted in front of 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 after a specific sheet	How to insert a single Excel worksheet after a specific sheet using Excel, VBA and Shortcut methods