Instructions to copy and move Sheet in Excel

Using Excel to process data, moving and copying sheets in Excel is a lot of people to do. It helps users to search, view and organize data quickly.

You can move sheets to different locations in the file or move, copy sheets to other Excel files.

How to move Sheet in Excel

Step 1: Select the sheet you want to move then right-click the sheet name and select Move or Copy .

Instructions to copy and move Sheet in Excel Picture 1

Step 2: The Move or Copy dialog box appears , you can move the sheet in the current file or move the sheet to another Excel file ( Note: This Excel file also needs to be opened).

Move sheet in current file

In the Move or Copy dialog box , the To book will default to the current Excel file name, select the position to move the sheet in the Before sheet (before the sheet).

For example, if you want to move the sheet to the first position of the Excel file (before sheet 1), select Sheet 1 in the Before sheet and click OK to move.

Instructions to copy and move Sheet in Excel Picture 2

Your results will be as follows:

Instructions to copy and move Sheet in Excel Picture 3

Move the sheet to another Excel file

In the Move or Copy dialog box , select the Excel file names that you need to move the sheet to in the To book section (for example, move the sheet to FileExcel 2).

Instructions to copy and move Sheet in Excel Picture 4

Once you have selected the file name, the sheet names of the file will be displayed and you also choose the position of the sheet in the Before sheet and click OK to move the sheet.

Instructions to copy and move Sheet in Excel Picture 5

Your results will be as follows:

Instructions to copy and move Sheet in Excel Picture 6

How to copy Sheet in Excel

To copy a sheet to another Excel file, you do the same move sheet, but in the Move or Copy dialog box you need to select the Create a copy before clicking OK to make Excel copy the sheet.

Instructions to copy and move Sheet in Excel Picture 7

Note: When moving a sheet, the sheet will move completely to the new file without retaining the original.

And when you copy the sheet, the sheet will be preserved and create a new sheet to the copy position.

Good luck!

5 ★ | 1 Vote

May be interested

  • Instructions on how to copy formulas in ExcelInstructions on how to copy formulas in Excel
    when we work with calculations on excel with many different data, copying formulas from one column to another will save time much more work.
  • How to move between sheets in a spreadsheet processing programHow to move between sheets in a spreadsheet processing program
    in spreadsheet processing programs, a sheet, tab sheet or worksheet tab is used to display the worksheet that the user is currently editing.
  • How to hide and show Sheet in ExcelHow to hide and show Sheet in Excel
    sometimes working with too many sheets makes you confused, or you don't want important sheets being viewed by others on your computer ..., or for some reason you want to hide the sheet and when necessary then display the sheet.
  • Recover deleted Sheet in ExcelRecover deleted Sheet in Excel
    when you delete sheet in excel, it seems that the undo keyboard shortcut has no effect. so how to recover deleted sheet in excel?
  • Show Sheet Tab in Excel when hiddenShow Sheet Tab in Excel when hidden
    accidentally when you open the excel file to work, you do not see the sheet tab bar appear to select sheet. you do not know what to do, so let's learn about the display of sheet tab in excel when hidden in this article.
  • Shortcut switch Sheet in ExcelShortcut switch Sheet in Excel
    shortcut switch sheet in excel. are you looking for a shortcut combination to quickly switch sheet in excel to make the process of working between sheets faster? below the article shared to you the sheet shortcut shortcut in excel, invite you to tickle
  • How to lock Excel Sheet, set a password for the sheet in ExcelHow to lock Excel Sheet, set a password for the sheet in Excel
    lock sheet, set password for data sheet in excel to create security for your data file, do not let anyone edit or add data. tipsmake.com will guide you how to do in our article below.
  • How to separate sheets into separate Excel filesHow to separate sheets into separate Excel files
    to separate each excel sheet into separate excel files, simply use the vba macro code to finish.
  • How to copy data from Excel to Word?How to copy data from Excel to Word?
    in some cases you need to insert some data into word documents to make reports, presentations ... the following article the network administrator will guide you how to copy data from excel to word.
  • How to Unprotect an Excel SheetHow to Unprotect an Excel Sheet
    this wikihow teaches you how to unprotect a sheet within a microsoft excel workbook in windows or macos. if the sheet is protected by a password and you're not sure what it is, you can use google sheets or a vba script (in earlier versions...