Learn how to move a sheet in Microsoft Excel in various proven methods for different challenging situations.

Moving a sheet can break cell references, especially if other sheets depend on its data. Not to mention other associated issues with moving an Excel worksheet, like lost hyperlinks, misplaced named ranges, disrupted data connections within a workbook or between workbooks, Excel VBA macro errors, and so on.

If you wish to move worksheets efficiently in an Excel workbook or between workbooks, follow along with the methods I have explained here. These methods will help in avoiding problems related to Excel sheet movements. Let’s begin!

Drag and Drop (Using Mouse)

This is the most widely used method to move a sheet in Excel. Let me walk you through the simple steps:

First things first, open your Excel file. Make sure you can see the sheet tabs at the bottom—those little labels that say things like Sheet1, Sheet2, and so on.

Now, locate the sheet you want to move. Maybe it’s on the far right, but you want it up front so it catches your eye first—totally makes sense!

Place your mouse pointer directly on the sheet tab you want to move. Not too fast—just gently hover your mouse there until the pointer turns into a little white hand or arrow.

Once you’re there, click and hold the left mouse button—don’t let go just yet! Imagine you’re carefully picking up a note from your desk.

While still holding the mouse button, slowly drag the tab left or right. A small black triangle will appear to show you where the sheet will land—handy little guy, isn’t it?

When the triangle points to the spot where you want your sheet to go, simply release the mouse button.

Voilà! The sheet jumps right into place like it knew you were planning a redecoration.

If it doesn’t land where you wanted, no worries. Just try again.

📒 Read More: How To Automate Sorting, Hiding, Unhiding and Listing Your Sheets

Right-Click Menu (Move or Copy)

This method allows you to move a selected sheet before a worksheet of the sheet tab or to another workbook. Let me show you how it is done:

Open your Excel workbook and make sure you can see the sheet tabs at the bottom. If they’re hidden for some reason, try adjusting the window size or making sure Sheet Tabs are enabled under Excel Options.

Right-click the sheet tab that you want to move. For example, if your sheet is named Sheet1, just move your mouse over the Sheet1 tab at the bottom and give it a right-click. A menu will pop up like a little toolbox of options.

In that menu, look for and click the Move or Copy option.

A dialog box will appear titled Move or Copy. This is where you tell Excel exactly where you want to move your sheet.

Under the To book section, choose the workbook you want to move the sheet to. If you’re moving it within the same workbook, leave it as is.

The destination workbook, if separate from the existing workbook, must be open for successful movement of worksheets.

If the destination workbook is open on the same PC, you’ll get the name of the file in the To book drop-down menu.

Now, in the list below that says Before sheet, click the sheet name you want your selected sheet to appear before. It’s like choosing where to slide a folder in a row of folders.

If you only want to move the sheet, don’t check the Create a copy box. But if you want a duplicate instead, feel free to check it.

Click OK, and ta-da! Your sheet will move to its new spot.

Using the Ribbon (Home Tab)

The Format command in the Excel ribbon menu allows you to organize sheets in an Excel workbook or in-between two or more workbooks, including moving the sheet in various ways. Here are the simple steps you can follow:

Open your Excel workbook that contains the sheet you want to move.

Click on the sheet tab you want to move, so it’s the active sheet. It’ll look like the tab is pressed in or underlined.

Go to the Home tab on the Ribbon. This tab is usually selected by default, but if not, click it.

In the Home tab, look for the Cells group, usually on the right side.

Inside that group, click on Format. It’s a drop-down menu that opens several options.

From the dropdown, hover over or click on Move or Copy Sheet…

A dialog box will pop up. This is where you choose where to move the sheet.

Under the To book section, select the workbook you want to move the sheet to (either the same file or another one that’s currently open).

Under the Before sheet option, choose the sheet before which you’d like to place your current sheet.

Optionally, if you also want to make a copy instead of moving, tick the checkbox that says Create a copy.

Click OK. Boom! Your sheet has now moved (or copied) to the new location.

Keyboard Shortcut (Alt + Drag)

If you’re the kind of person who loves keyboard shortcuts and doing things quickly without diving through menus, you’ll probably enjoy this method. It’s simple, effective, and makes you look like a spreadsheet pro—even if you just started using Excel last week.

Here’s how to move a sheet using the Alt + Drag method:

Open your Excel workbook with the sheet you want to move.

Take a second to find the sheet tabs at the bottom. These are like the tabs in a notebook.

Now, press and hold the Alt key on your keyboard. Yep, just keep it held down.

While holding Alt, click and hold the sheet tab you want to move.

Drag the sheet left or right to the position you want within the workbook.

You’ll notice a tiny little black triangle showing where it will land—don’t worry, that’s normal.

Let go of the mouse button first, then release the Alt key.

And just like that, your sheet has been moved! It’s a bit like rearranging sticky notes, but digital. If your hand-eye coordination isn’t perfect, it might take a couple of tries—but once you get it, it becomes second nature.

Copy Instead of Move (Duplicate Sheet)

Sometimes you don’t want to move a sheet—you want to make a copy of it so the original stays right where it is. Maybe you’re testing out a new formula or creating a monthly report based on a previous one. Duplicating the sheet saves you from starting from scratch and keeps your original safe. Here’s how to do it:

Open your Excel workbook and locate the sheet you want to copy.

Right-click on the sheet tab at the bottom—yes, that little tab with the sheet name.

From the menu that appears, click on Move or Copy…

A dialog box will pop up with a few options.

Under the Before sheet section, pick where you want the copied sheet to be placed in the same workbook.

Now this part is crucial—check the box that says Create a copy.

If you forget this, the sheet will be moved instead of copied, and you might wonder where your original went!

Once you’ve selected everything, click OK.

And just like that, your duplicated sheet appears—usually with (2) added to the name. You can rename it to something more meaningful, like Report_April or Test_Sheet. This trick is a lifesaver when you want to keep experimenting without breaking anything important.

VBA Macro to Move Sheets

If you wish to automate the whole process of moving sheets within the same or different workbooks, you can use an Excel VBA macro.

Here’s how you can get started with creating a macro from a VBA script:

📒 Read More: How To Use The VBA Code You Find Online

Now that you’re ready to create a macro, use this script:

Sub MoveSheet()
    Dim sheetName As String
    Dim moveOption As VbMsgBoxResult
    Dim newPos As Variant
    Dim targetWorkbook As Workbook
    Dim targetPath As Variant
    Dim destinationSheetName As String
    Dim sourceSheet As Worksheet
    
    ' Step 1: Get the name of the sheet to move
    sheetName = InputBox("Enter the name of the sheet to move:", "Sheet Name")
    If sheetName = "" Then Exit Sub
    
    On Error Resume Next
    Set sourceSheet = ThisWorkbook.Sheets(sheetName)
    On Error GoTo 0
    
    If sourceSheet Is Nothing Then
        MsgBox "Sheet not found: " & sheetName, vbCritical
        Exit Sub
    End If
    
    ' Step 2: Ask where to move the sheet
    moveOption = MsgBox("Do you want to move the sheet within the SAME workbook?" & vbCrLf & _
                        "Click Yes for SAME, No for DIFFERENT workbook.", vbYesNoCancel + vbQuestion, "Move Options")
    
    If moveOption = vbCancel Then Exit Sub
    
    ' ====================
    ' SAME WORKBOOK OPTION
    ' ====================
    If moveOption = vbYes Then
        newPos = InputBox("Enter the position number to move the sheet to (e.g., 3):", "New Position")
        If Not IsNumeric(newPos) Or Val(newPos) < 1 Or Val(newPos) > ThisWorkbook.Sheets.Count Then
            MsgBox "Invalid position entered.", vbExclamation
            Exit Sub
        End If
        Application.DisplayAlerts = False
        sourceSheet.Move Before:=ThisWorkbook.Sheets(CInt(newPos))
        Application.DisplayAlerts = True
        MsgBox "Sheet '" & sheetName & "' moved to position " & newPos & ".", vbInformation
    Else
    ' ========================
    ' DIFFERENT WORKBOOK OPTION
    ' ========================
        targetPath = Application.GetOpenFilename("Excel Files (*.xls*), *.xls*", , "Select the Target Workbook")
        If targetPath = False Then Exit Sub ' Cancel pressed
        
        ' Open the target workbook
        Set targetWorkbook = Workbooks.Open(Filename:=targetPath)
        
        ' Ask for new sheet name (to move as)
        destinationSheetName = InputBox("Enter the name for the sheet in the target workbook:", "New Sheet Name", sheetName)
        If destinationSheetName = "" Then Exit Sub
        
        ' Move and rename
        sourceSheet.Copy After:=targetWorkbook.Sheets(targetWorkbook.Sheets.Count)
        targetWorkbook.Sheets(targetWorkbook.Sheets.Count).Name = destinationSheetName
        
        MsgBox "Sheet '" & sheetName & "' copied to '" & targetWorkbook.Name & "' as '" & destinationSheetName & "'.", vbInformation
    End If
End Sub

When the macro is ready, press Alt + F8 to launch the Macro dialog box. Select the MoveSheet macro and hit the Run button.

The macro will ask you to type in the name of the worksheet you wish to move.

Then, the VBA script will also show you a dialog box to find out if you want to move the sheet to a different workbook or within the same workbook.

Once you give a preference here, you’ll find another dialog box asking you to enter the new position for the sheet you’re moving, like 2 for the 2nd position in the workbook.

Excel will move the worksheet as per your preferences.

Conclusions

So, now you know how to move a sheet in Microsoft Excel following various proven methods.

You can choose the best method depending on the Excel workbook type and your specific use case.

If you liked the guide, use the comment box to share your acknowledgments. Share this Excel tutorial with your friends, family, and colleagues to help them learn Microsoft Excel effortlessly.