クラシックファイルタイプは2021年1月をもって使用できなくなりました。クラシックファイルを移行することも、PDFをダウンロードすることもできます。詳細はこちら

Combining two Spreadsheets into one

回答済み
デモをリクエスト

I imported two separate spreadsheets into Wdesk and these two spreadsheets are within a Project.  Each spreadsheet has multiple tabs within it.  What I want to do now is combine these two, so that I am working with just one spreadsheet with multiple tabs.  What is the best way to do this?

0

コメント

1件のコメント

日付 投票
  • Mike
    Hi Kellie!

    Sorry for the delay in getting this answered. I have a two options for you that should get the job done.

    Export/Import method
    One option is to export one Spreadsheet and then import that into the other Spreadsheet. This can be done if you export the file as a XLSX first, then when you go to Import > Microsoft Excel. Then, from this pop-up window, choose the second option for Add Excel sheets to this Spreadsheet, like so:



    This may only be ideal if you don't have links going to or from the second Spreadsheet, however. In that case, the second option would be best.

    Copy/Paste method
    You can also copy and paste the sheets over from the first Spreadsheet to the second. You would be able then to copy the formulas, formatting and links. First, create the new sheet in first Spreadsheet, then in the second Spreadsheet open a sheet and copy all the data you want. You you can do a CTRL+A to select all the cells. Then go back to the new sheet within the first Spreadsheet and paste the values. Note here that if there are source links (the blue links) in the second Spreadsheet you are copying from, you'll need to do a Cut and Paste to bring them over.

    Hopefully those options help. Let me know what questions you have or if you need any further clarification on any of the above. Thanks as always and have a super day!
    1

サインインしてコメントを残してください。