Excel Tip: Copy an Entire Worksheet | AccountingWEB

Excel Tip: Copy an Entire Worksheet

Here's a timesaving tip for Excel users who frequently need to copy an entire worksheet (a page within a workbook) of information-such as a list of items for a monthly inventory-from one workbook (Excel file) to another.

To copy an entire sheet to another workbook, follow these steps:

  1. Open the workbook into which you want to paste the copied sheet.

  2. Switch to the workbook that contains the sheet you want to copy.

  3. Right-click the Sheet tab of the sheet you want to copy. A pop-up menu will appear.

  4. Click Move or Copy on the pop-up menu.

  5. From the To book drop-down menu, select the workbook that will receive the sheet. (To copy the selected sheet to a new workbook, click New book on the drop-down menu.)

  6. Indicate where in the receiving file you want the sheet to appear (Before Sheet1, Before Sheet2, etc.)

  7. Check the Create a copy check box. (If you don't select this check box, the sheet will be moved instead of copied.)

  8. Click OK. A copy of the worksheet will appear in the file you indicated.

View more helpful tips!

Wait, there's more!
There's always more at AccountingWEB. We're an active community of financial professionals and journalists who strive to bring you valuable content every day. If you'd like, let us know your interests and we'll send you a few articles every week either in taxation, practice excellence, or just our most popular stories from that week. It's free to sign up and to be a part of our community.
Premium content is currently locked

Editor's Choice

WHAT KIND OF FIRM ARE YOU?
As part of our continued effort to provide valuable resources and insight to our subscribers, we're conducting this brief survey to learn more about your personal experiences in the accounting profession. We will be giving away five $50 Amazon gift cards, and a $250 Amazon gift card to one lucky participant.
This is strictly for internal use and data will not be sold
or shared with any third parties.