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.