# Copying  Excel Worksheets Between Files?

**URL:** <https://boards.straightdope.com/t/copying-excel-worksheets-between-files/694324>\
**Category:** Factual Questions\
**Created:** [July 29, 2014, 2:38pm UTC](https://boards.straightdope.com/t/copying-excel-worksheets-between-files/694324 "2014-07-29T14:38:52Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jinx](https://avatars.discourse-cdn.com/v4/letter/j/c6cbf5/32.png) [@Jinx](https://boards.straightdope.com/u/Jinx)\
**Post date:** [July 29, 2014, 2:38pm UTC](https://boards.straightdope.com/t/copying-excel-worksheets-between-files/694324/1 "2014-07-29T14:38:52Z")

</div>

Does anyone know how to copy a worksheet from one Excel file into another Excel file? If this can be done, please clue me in! Thanks!

---

<div class="post-metadata">

**Author:** ![Dewey\_Finn](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/dewey_finn/32/4222_2.png) [@Dewey\_Finn](https://boards.straightdope.com/u/Dewey_Finn)\
**Post date:** [July 29, 2014, 2:43pm UTC](https://boards.straightdope.com/t/copying-excel-worksheets-between-files/694324/2 "2014-07-29T14:43:42Z")

</div>

Right-click on the tab containing the worksheet at the bottom on the screen and select copy. For the destination, specify another already-open Excel file.

If that makes no sense, look at [this Microsoft webpage](http://office.microsoft.com/en-us/excel-help/move-or-copy-a-worksheet-HP001217035.aspx).

---

<div class="post-metadata">

**Author:** ![Cheesesteak](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/cheesesteak/32/3694_2.png) [@Cheesesteak](https://boards.straightdope.com/u/Cheesesteak)\
**Post date:** [July 29, 2014, 3:21pm UTC](https://boards.straightdope.com/t/copying-excel-worksheets-between-files/694324/3 "2014-07-29T15:21:19Z")

</div>

You can also left click the upper left corner box, the one between A & 1, that will select the entire sheet. You then hit Copy, open a clean worksheet, and paste into cell A1.

Beware if it references other worksheets within the old file, that can cause issues.
