Go Back   Wiki NewForum > Career Forum (Documents/Tutorials/Advice) > Tech Forum & Tutorial > IT Forum > MS office Tutorials (2003 & 2007) > MS Excel 2003

Sponsored Links

MS Excel 2003 Step-by-step Excel 2003 Tutorials, Tips and Training

Reply
Views: 824 Source: CNN18.com, India-Forums, TellyChakkar, India, Times of India, Youtube, BollywoodLife, Rediff  
Thread Tools Rate Thread Display Modes
  #1  
Old 01-26-2010, 11:18 AM
seema seema is offline
Administrator
 
Join Date:
Oct 2009
Posts: 5,551
Default Topic 28: Copying Excel Worksheet from one Workbook to Another

If you use Microsoft Excel, then you’ve run into the situation where the information in a worksheet is needed in another workbook. You could go through and copy and paste the cells from one worksheet to another, but if you are working with a large spreadsheet, this is way too painful. Excel makes it easy to copy (and even easier to move) worksheets from oneworkbook to another.

To copy a worksheet to another workbook

Open the workbook that you intend to copy the worksheet. (Ex: Book1)
Open another workbook that you want the worksheet copied to. (Ex: Book2)
Go to the workbook with the desired worksheet that you wish to copy. Right-click on the tab of the target worksheet.


Select Move or Copy… from the menu.


Reply With Quote
  #2  
Old 01-26-2010, 11:18 AM
seema seema is offline
Administrator
 
Join Date:
Oct 2009
Posts: 5,551
Default




From the Move or Copy window appears, use the To book: dropdown list to select the workbook that you want to copy the worksheet to. (Ex: Book2)
Then select the existing sheet that you want the copy to be placed in front of. For example, if you select the Sheet2, the copiedworksheet will be place before the Sheet2.
Check the Create a copy check box.
Click OK. You will now have the same worksheet in both workbooks.

Note: To move a worksheet to another workbook, just follow the above steps and simply exclude checking the Create a copy check box.
Reply With Quote
Reply

New topics in MS Excel 2003

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump


Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2018, vBulletin Solutions, Inc.