How to Move Or Copy WorkSheets in Microsoft Excel?

This article explains about moving or copying worksheets or worksheet data in Microsoft Excel.

How to move a worksheet in Microsoft Excel?

Right-click on the worksheet tab and click on the Move or Copy option.

Move or copy worksheets or worksheet data in Microsoft Excel

Select a sheet from the Before sheet to move the current sheet in-front to it. Then click OK.

Move or copy worksheets or worksheet data in Microsoft Excel

Another way to move a sheet is to select the worksheet tab and drag it to where you want it and drop it.

How to copy a worksheet in Excel?

To copy a worksheet right click on the worksheet tab and select Move or Copy.

Move or copy worksheets or worksheet data in Microsoft Excel


Select the Create a copy box.

Select a sheet from the Before sheet to move the current sheet in-front to it. Then click OK.

Move or copy worksheets or worksheet data in Microsoft Excel

A new copy of the sheet gets created in-front of the sheet you’ve selected.

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Hey, wait!Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.