Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excel Spreadsheet - How to Copy over?

Options
  • 26-09-2012 10:33am
    #1
    Registered Users Posts: 28,403 ✭✭✭✭


    Looking to copy a whole spreadsheet over to a new spreadsheet - line widths and formulas etc

    Is this possible? How do I go about it if so.

    Thanks


Comments

  • Banned (with Prison Access) Posts: 4,991 ✭✭✭mathepac


    "Save As..." under File menu giving the new name of the spread-sheet when the dialog box comes up. Type your new data into "New Name" spreadsheet


  • Registered Users Posts: 128 ✭✭excaliburhc


    depends - are you talking about a worksheet or a complete excel workbook?

    to copy a sheet to another you have 2 options
    1) prss the box top left above the 1 and beside the a - this should select all - then right click and copy - goto the sheet you want to add info to - press the same button -right click and paste

    2) rightclick on worksheet name and press move / copy - in popup box - choose the worksheet you wish to move it to , make sure copy information is ticked (otherwise it will move everything to the new workbook)

    http://office.microsoft.com/en-us/excel-help/move-or-copy-a-worksheet-HP001217035.aspx


Advertisement