How To Copy or Move A Worksheet in Excel?

In Excel, we can Move or Copy a Worksheet in the same Workbook so we can organize the Workbook the way we want to, or we can even Move or Copy a Worksheet to other location, such as an existing open Workbook or to a New Workbook. All you need to do, so you can find out how, is to continue reading this post below.

How To Move Or Copy A Spreadsheet in Excel

The first way is that we move with our mouse on top of the desired Worksheet and click on it, to activate it that we want to Move or Copy. Then we do a right click with our mouse and from the shortcut menu that appears we select the command Move or Copy as shown in the image below.

Move or Copy Spreadsheet

The second way is to have the desired Worksheet activated by selecting it, and then from the Home tab, we locate the area of the ribbon named Cells and we select the command Format and then from the drop down menu that appears we select the command Move Or Copy Sheet as shown below.

Move or Copy Spreadsheet

No matter which way we choose, the Move or Copy dialog box appear as shown below. This dialog box is separated in the following areas which will be described below.

Move or Copy Spreadsheet

  • Move Selected Sheets To Book: If we select the Move command, by selecting the drop-down menu, we will Move the selected Sheet either to a New Book or to an Open Workbook as shown in the image below, which the already opened Workbook is named PersonalInsurances.xlsx. Whatever we select, once we Move the Sheet it will no longer be in the original position, but it will Move to the New Location either it is a New Book or an Open Existing One.

Move or Copy Dialog Box

  • Before Sheet: If we choose to Move a Worksheet in an already opened Workbook, we can choose where to Move the Worksheet Before. For my example, as mentioned above I have opened a Workbook named PersonalInsurances.xlsx, which contains the Worksheets EFKA-OGA, OGAKanonismos and Teve, where we Move Before the Selected Worksheet. We also have the option to Move the selected Sheet To the End.

Before Sheet

Create A Copy: If we activate this command, instead of Moving the Spreadsheet, we actually Create a Copy of it. If we want to Create A Copy of it, we must first select this option, and then follow the steps that I mentioned above.

Create A Copy

Below you check out the video describing How To Move Or Copy A Spreadsheet in Excel.

Don’t Forget To Subscribe To My YouTube Channel.

YouTube Channel


About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on March 18, 2019, in Excel 365 English, Microsoft Office 365 ProPlus English and tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , . Bookmark the permalink. Comments Off on How To Copy or Move A Worksheet in Excel?.

Comments are closed.