How to move active sheet to end or front of current workbook in Excel?

Moving the active sheet to the beginning or end of the workbook helps you easily navigate among multiple sheets. In this article, we will show you methods of moving active sheet to end or front of current workbook in Excel.

Move active sheet to end or front of current workbook with Move or Copy
Move active sheet to end or front of current workbook with VBA code
Easily move active sheet to end or front of current workbook with an amazing tool

Move active sheet to end or front of current workbook with Move or Copy

With Excel’s Move or Copy function, you can move active sheet to end or front of current workbook in Excel.

1. On the active sheet, right-click the sheet tab, and select Move or Copy from the context menu. See screenshot:

2. In the Move or Copy dialog box, for moving active sheet before all sheets, select the top sheet in the Before sheet list. To move the active sheet to the end, scroll down and select move to end option in the Before sheet box. And finally click the OK button. See screenshots:

Move active sheet to top	Move active sheet to end

Then the active sheet will be moved to end or front of current workbook at once.

Move active sheet to end or front of current workbook with VBA code

Running the following VBA codes, you can move active sheet to end or front of current workbook in Excel.

1. Activate the worksheet you want to move to end or front of current workbook, press Alt + F11 keys to open the Microsoft Visual Basic Applications window.

2. In the Microsoft Visual Basic Applications window, click Insert > Module. Then copy and paste below codes into the Module window.

VBA code: move active sheet to end of current workbook

Sub MoverToEnd()
	ActiveSheet.Move _
	After: = ActiveWorkbook.Sheets(ActiveWorkbook.Sheets.Count)
End Sub

Sub MoverToFront()
	ActiveSheet.Move Before: = ActiveWorkbook.Sheets(1)
End Sub

3. After pasting the code, press the F5 key to run the code. Then the active sheet will be moved to end or front of current workbook immediately.

Easily move active sheet to end or front of current workbook with an amazing tool

With the Sort Sheets utility of Kutools for Excel, you can not only sort all worksheets with alpha, color, but also easily move active sheet to top, end or specified position of current workbook.

1. Click Kutools Plus > Worksheet > Sort Sheets. See screenshot:

2. In the Sort Sheets dialog box, the active sheet is selected by default, and you need to do the following operations:

Notes:

Related articles:

• How to delete all sheets except specified/current one in Excel?
• How to save, export or convert multiple/all sheets to csv or text files in Excel?
• How to return to last active sheet in Excel?