Results 1 to 4 of 4

Thread: How to copy worksheet in Microsoft Excel 2010?

  1. #1
    Join Date
    Nov 2009
    Posts
    1,191

    How to copy worksheet in Microsoft Excel 2010?

    Hi Friends, I have an issue regarding the use of the Microsoft Excel 2010 and need to solve that. Actually i have an worksheet that i want to copy in the existing workbook. But i haven't any idea so that i can perform the same. So any one please help me with the How to copy worksheet in Microsoft Excel 2010?. Any help may be appreciated. Thanks in advance.

  2. #2
    Join Date
    Apr 2008
    Posts
    4,642

    Re: How to copy worksheet in Microsoft Excel 2010?

    It is very to perform in the Excel 2010. Just open that in the worksheet that you want to copy in the new tab and just right click on the and then to the Move or copy option. This will open a dialog box that will display the list of the worksheet to move in drop down menu. Click on the project and on the next field click on the position where you want to paste the things. And its done. Thank you

  3. #3
    Join Date
    May 2008
    Posts
    4,570

    Re: How to copy worksheet in Microsoft Excel 2010?

    Just follow the below given procedure to help yourself with the moving of the Worksheet in another Workbook. This is really working. So go with the step.
    • In a new workbook with two or more sheets, add a table or a list in one of the worksheets.
    • Select more than one sheet with the CTRL key held down. (Be sure that one of the selected worksheets contains a List or Table.)
    • Right-click on one of the sheet tabs, and then choose Move or copy.
    • In To Book, choose (new book), and then check the checkbox named Create a Copy.
    • Click OK, and then you will see a message box: “You cannot copy or move a group of sheets that contain a table.”

  4. #4
    Join Date
    May 2008
    Posts
    4,345

    Re: How to copy worksheet in Microsoft Excel 2010?

    Hey it is little bit difficult to copy the data more then one. It is impossible to copy more than one sheet to a existing workbook or to the new work book if you are working on Excel 2003 with list or on the Excel 2007 with the table Worksheet so make sure that you are not moving the file of the older version. This is easy task for the coworker in the office so that send them the worksheet and finish the work of copying file. Thanks

Similar Threads

  1. Replies: 1
    Last Post: 13-01-2012, 05:09 PM
  2. Replies: 8
    Last Post: 04-12-2011, 11:24 AM
  3. Replies: 3
    Last Post: 11-07-2011, 10:37 AM
  4. Replies: 5
    Last Post: 14-05-2011, 10:36 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,710,116.90926 seconds with 17 queries