Articles → EXCEL → Copy Worksheets In Excel

Copy Worksheets In Excel






Software Requirement





Prerequisite Knowledge





Open A New Excel





Add Data In Excel




Picture showing the sample excel file for copying worksheets

Click to Enlarge


Copy Worksheets




  1. Select a worksheet
  2. Right click on it
  3. Select ‘Move or Copy..’ option
  4. Picture showing the Move or Copy... option on the context menu of the tab

    Click to Enlarge

  5. A window appears as shown in figure below
  6. Picture showing a popup window to move or copy the worksheet

    Click to Enlarge




  1. ‘To Book:’ - Which worksheet you want to move. Basically the worksheet you have selected appears in the drop down.
  2. ‘Before sheet:’ – Before which worksheet you want to insert the selected worksheet. For example you have selected ‘Sheet3’ then ‘Sheet1’ will be moved between ‘Sheet2’ and ‘Sheet3’. If you select the option ‘(move to end)’ then the worksheet will be moved to the last.

More About ‘To Book’: Section




Picture showing the new excel file created when user selected the new excel in To Book: section

Click to Enlarge



Picture showing the sample excel file with the deleted worksheet

Click to Enlarge


How Things Will Change If We Select 'Create A Copy' Option?




Picture showing the copy of worksheet when using create a copy option

Click to Enlarge



Picture showing the new excel file when user selects new workbook from To Book section and Create copy option

Click to Enlarge

Picture showing the new excel file when user selects new workbook from To Book section and Create copy option

Click to Enlarge


Posted By  -  Karan Gupta
 
Posted On  -  Sunday, March 2, 2014

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250