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.
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.
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.
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 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.
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.
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.
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.