>

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










Picture showing the Move or Copy... option on the context menu of the tab

Click to Enlarge



Picture showing a popup window to move or copy the worksheet

Click to Enlarge








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