How To: Move or copy sheets in Excel easily

Avatar

I have seen too many people struggle with copying and moving around their sheets in Excel. What they do not know is that there is an insanely easy way to move the sheets with a variety of options at their disposal at any given point.

MoveOrCopyExcel2

First of all, you will need to right click on the Sheet you want to move at the bottom of Excel’s window. Choose the Move or Copy option and you will see a small window popping up. Now you will have a variety of options that you can configure before actually moving the sheets. The first option is to choose the Book (the Excel file) that you want to move the sheet to. You can move it to the one you are currently working on or a new one entirely. That option is available from the dropdown list. Next you will need to choose its position on the book. You can either place it before an already existing sheet or simply place it at the very end by choosing the “move to end” option. Finally, you can choose to keep a copy of the original sheet.

MoveOrCopyExcel1

This feature offers a ton of utility to the moving and copying options but it is also kind of slow. The other way you can move sheets is to keep pressing Ctrl and dragging and dropping the sheet to where you want it to go. However, there are some disadvantages to this. You cannot move the sheet to another book and a copy will be automatically created when using this option. If you do not care about these two things then feel free to use this faster way.