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

Combining two Spreadsheets into one

回答済み
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

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