To copy several sheets in Excel for Microsoft 365 on Windows, select their worksheet tabs, right-click one of the selected tabs, choose Move or Copy, choose the destination, and check Create a copy before selecting OK. Save the workbook first, and open the destination workbook if you are copying sheets into another file.
What You’ll Need
- Excel for Microsoft 365 on Windows, or the Excel desktop app for Mac. The desktop app is the dependable choice for copying a group of sheets; Excel for the web does not offer the same multi-tab copy workflow.
- The source workbook, plus the destination workbook if you are copying sheets to an existing file. Keep both files open in Excel.
- Permission to edit the workbooks. If a workbook is read-only or protected, you may need to save an editable copy or ask the owner to change its settings.
Step-by-Step
- Save the source workbook. Press Ctrl+S on Windows. On a Mac, press Command+S. If you will copy into another workbook, save that file too. Copying sheets does not replace saving your work, and saving first makes it easier to recover if you choose the wrong destination or copy the wrong tabs.
- Find the worksheet tabs you want to copy. The tabs are along the bottom of the Excel window. If you cannot see all the tabs, use the navigation arrows at the lower left to scroll through them. You can also widen the workbook window or drag the divider beside the horizontal scroll bar to make more tab labels visible. Make a note of the first and last sheet names if the workbook has many tabs.
- Select the sheets. For sheets next to one another, click the first tab, hold Shift, and click the last tab. Excel selects the tabs between them, including both end tabs. For sheets that are not next to one another, hold Ctrl and click each tab you want on Windows. On a Mac, use Command-click for nonadjacent tabs; use Shift-click for a continuous range. Check that only the intended tabs are highlighted before continuing.
- Open the sheet-tab menu. Right-click any one of the selected tabs, then choose Move or Copy. You only need to open the menu once; the command acts on the selected group. If you accidentally click a tab without the selection key, Excel can replace your group selection with just that sheet, so verify the highlighted tabs again if needed. On a Mac, Control-click or right-click a selected tab to open its context menu.
- Choose where the copies should go. In the Move or Copy dialog, use the To book list to select the current workbook, another open workbook, or (new book). If you are copying to a different file and it is not listed, cancel the dialog, open that destination workbook in Excel, and repeat the command. The destination needs to be open for it to appear in the list.
- Choose the insertion point. Under Before sheet, select the sheet that should come immediately after the copied group. To place the copies at the end, select the last sheet in the destination; Excel inserts the copies before it, so they may appear just before that sheet rather than after it. If you need a particular order, review this list carefully before confirming.
- Check Create a copy, then confirm. This is the crucial step: tick Create a copy so Excel duplicates the selected sheets instead of moving the originals. Click OK. Leave the box clear only if you deliberately want to relocate the sheets and remove them from the source position. When you select (new book), Excel creates a new workbook containing the copied sheets.
- Verify the result. Look at the destination workbook’s tabs and confirm the correct sheets are present and in the intended order. Click through a few copied sheets to check their contents, formulas, formatting, and visible objects. Excel may adjust names when a sheet name already exists in the destination. Save the destination workbook when you are satisfied.
- Ungroup the source tabs if they are still selected. After copying, several tabs may remain selected. Click a single sheet tab without holding Shift, Ctrl, or Command to return to normal sheet editing. When multiple tabs are grouped, edits such as entering data or formatting cells can affect every selected sheet, so make sure the group is cleared before continuing with unrelated work.
Copying sheets into a new workbook
If you want a separate file containing only the selected sheets, choose (new book) in the To book list and check Create a copy. Excel opens the new workbook with those sheets. Use File > Save As to give the new file a name and choose where to store it. Until you save it, the new workbook may have a temporary name and may not be stored in your usual folder.
Copying sheets into an existing workbook
Open both the source and destination files in the desktop app before starting. In the dialog, choose the destination by its workbook name, then choose where the new sheets should appear. If multiple workbooks have similar names, check the workbook title bar or switch between files to identify the right one. Copying sheets between files can affect formulas that refer to sheets or data not included in the copied group; inspect important formulas and links afterward.
Common Mistakes
- Forgetting Create a copy: With the box unchecked, Excel moves the selected sheets. They disappear from their original position, which can look like data has been lost. If you notice immediately, use Ctrl+Z on Windows or Command+Z on Mac, provided you have not closed the workbook or performed actions that prevent undo. Otherwise, reopen the saved source or restore a backup.
- Selecting the wrong tabs: Shift selects a continuous range, not just the two tabs you click. Ctrl-click on Windows or Command-click on Mac is for picking separate tabs. Review the highlights before you open the dialog.
- Copying when you meant to move, or vice versa: The dialog’s checkbox controls this. Read it before pressing OK; the word “Move” in the dialog title does not mean the sheets will definitely be moved.
- Assuming copied formulas are self-contained: A copied formula may refer to a sheet that was not copied, or to a sheet in the original workbook. Excel can preserve a link to the source file. Check formulas that use other sheets, defined names, or external data, especially when moving a group to a new workbook.
- Editing while sheets are grouped: A group selection is useful for copying, but it can cause a change to be applied across all selected sheets. Click one tab to ungroup them as soon as the copy is complete.
- Expecting the original tab names to remain unique: A workbook cannot contain two sheets with exactly the same name. If a destination already has a sheet with a copied name, Excel adjusts the copied sheet’s name. Check that references or instructions relying on a specific tab name still make sense.
Tips
- Use a continuous selection when possible. Shift-clicking the endpoints is quicker and less likely to miss a tab when the sheets form one uninterrupted block.
- Use Ctrl-click or Command-click selectively. This lets you copy separate sheets without including every sheet between them. Keep track of the order in which the tabs appear, because Excel retains the selected sheets’ relative order when it copies them.
- Choose a clear insertion point. The dialog inserts the copies before the sheet selected in Before sheet. If the destination has a useful section heading or divider tab, place the copies next to the relevant group, then check the final order.
- Keep a clean source file. Copying leaves the originals in place when Create a copy is selected. This makes the source a useful reference if you later discover that a formula, chart, or layout did not carry over as expected.
- Review features that depend on other workbook content. A sheet can contain formulas, charts, data validation, conditional formatting, PivotTables, or links that rely on supporting sheets, named ranges, data connections, or other files. Copying the visible sheet does not guarantee that every dependency is available in the destination.
- Protect important originals. Keep a backup before copying sheets from a workbook with complex links or macros. A copied sheet does not necessarily bring along workbook-level settings, connections, or every item stored elsewhere in the file.
- Prefer the desktop app for this task. In Excel for the web, open the workbook in the desktop app if you need to select and copy several tabs together. The exact tab and dialog experience can differ between Excel for Windows and Mac, but the key check remains Create a copy.
Troubleshooting
- Move or Copy is unavailable or the copy fails: Check whether the workbook is protected, shared in a restricted way, or opened read-only. Save an editable copy with File > Save As, then try again. If the workbook is protected by its owner or your organization, request the necessary access rather than trying to bypass it.
- The destination workbook is missing from To book: Open the destination in the same Excel desktop session, return to the source, select the tabs again, and reopen Move or Copy. If the destination is open in a browser rather than the desktop app, it may not be listed. Save and close any unsaved changes before switching or reopening files.
- The copied sheets appear in the wrong place: Open Move or Copy again and choose a different entry under Before sheet. Remember that the selected sheet is the one the copies go before. You can also drag the copied tabs to the correct position afterward.
- Only one sheet was copied: Return to the source and select the whole group again. For a range, Shift-click its endpoints; for separate tabs, use Ctrl-click on Windows or Command-click on Mac. Confirm all intended tabs are highlighted before opening the menu.
- A formula shows an error or points to another file: Inspect the formula bar and identify the referenced sheet or workbook. If a required supporting sheet was not copied, copy it too or update the formula to use the correct destination sheet. For external links, use Data > Workbook Links if that command is available in your Excel build to review or manage links; do not break a link unless you understand what the formula needs.
- You cannot see the copied sheet name clearly: Scroll along the tab bar or widen the Excel window. If Excel added a suffix because the destination already had the same name, right-click the copied tab, choose Rename, and enter a unique, descriptive name.
Frequently Asked Questions
Can I copy multiple sheets at once in Excel?
Yes. Select a continuous range with Shift-click or select separate tabs with Ctrl-click on Windows or Command-click on Mac. Then use Move or Copy and check Create a copy.
Can I copy multiple sheets into a different workbook?
Yes. Open both workbooks in Excel’s desktop app. In the Move or Copy dialog, choose the destination under To book, set the insertion point, and select Create a copy.
How do I copy sheets into a brand-new workbook?
Select the sheets, open Move or Copy, choose (new book), and check Create a copy. Excel creates a new workbook; use File > Save As to save it with a name and location.
Will copying sheets also copy formulas and formatting?
Excel copies the sheets’ cell contents and much of their sheet-level formatting and layout. Formulas that refer to sheets, names, or data outside the copied group may still depend on the source workbook, so check those references in the destination.
Can I copy multiple sheets in Excel for the web?
The web app does not provide the same reliable multi-sheet selection and copy process as the desktop app. Open the workbook in Excel for Windows or Mac, copy the grouped tabs there, and then save the workbook.
Related
- How to Close an Excel Sheet With a Keyboard Shortcut
- How to Close Editing Mode in Excel Without Losing Work
- How to Close an Excel File With a Keyboard Shortcut
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Set an Out of Office Email in the New OutlookTo set an out-of-office email in New Outlook, open Settings, go to Accounts > Automatic replies, turn on…
- Disable Circular References in Excel: Causes and FixesTo stop Excel for Microsoft 365 on Windows from calculating circular formulas iteratively, go to File > Options…
- Excel Not Responding Due to Large Data: Causes and FixesYes. Excel can show “Not Responding” when a large workbook takes a long time to calculate, load, refresh,…
- Word Mail Merge: Keep Excel Formatting for Dates, NumbersWord mail merge does not reliably carry Excel cell formatting into the finished document. To control the result,…
- How to Add Page Numbers and Your Name in Microsoft WordTo add page numbers and your name in Word, insert an automatic page number in the header or…
- Excel Worksheet Tabs Not Visible? How to Restore ThemIf Excel worksheet tabs are not visible, first check File > Options > Advanced and turn on Show…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.