Insert a Worksheet from a Personal Template in Excel 365 for Mac
Question details
The user wants to insert a custom worksheet from a personal template into an Excel workbook.

- Product
- Microsoft Excel 365 for Mac
- Device & OS
- Mac
- Scenario
- The user wants to reuse a formatted worksheet in another workbook.
- Observed behavior
- Inserting a worksheet creates a blank sheet without showing a template-selection dialog.
Open the destination workbook and a workbook containing the custom worksheet. Check that the source sheet has the formatting and content you want to reuse.
Copy the custom worksheet into the destination workbook
Use Move or Copy to reuse a formatted worksheet when Excel does not show the template-selection dialog.
In Excel, open the workbook containing the custom worksheet and the workbook where you want to insert it.
In the source workbook, right-click the custom worksheet tab and select Move or Copy.
In the Move or Copy dialog, select the destination workbook and choose where to place the sheet.
Select Create a copy, then click OK. Check the new sheet in the destination workbook.

Copy a Custom Worksheet with WPS Spreadsheet
Use WPS Spreadsheet to copy a formatted worksheet from a source workbook into another workbook without rebuilding the sheet.
- 1. Open the workbooks: In WPS Spreadsheet, open the workbook containing the custom sheet and the destination workbook.
- 2. Select the custom sheet: Right-click the custom worksheet tab and choose Move or Copy.
- 3. Set the destination: Choose the destination workbook and the position for the copied sheet in the dialog.
- 4. Create the copy: Select Create a copy and confirm. Review the copied sheet and save the destination workbook.

Frequently Asked Questions
Why does Excel insert a blank sheet instead of showing my personal template?
In Excel 365 for Mac, the Insert action may create a blank sheet directly rather than showing the template-selection dialog. You can instead copy the custom sheet from a workbook using its tab's Move or Copy command.
Do I need to open both workbooks before copying the sheet?
Yes. Open the source and destination workbooks in Excel, then right-click the source sheet tab and select Move or Copy to choose the destination.
How do I keep the original worksheet in the source workbook?
In the Move or Copy dialog, select Create a copy before clicking OK. This leaves the original sheet in the source workbook.
Will formulas on the copied worksheet work in the new workbook?
Formulas are copied with the sheet, but references to other sheets or workbooks may still point to the original data. Review those formulas in the destination workbook.




