Template Issues

Insert a Worksheet from a Personal Template in Excel 365 for Mac

Elise WilliamsElise Williams Nov 14, 2026 868 views

Question details

The user wants to insert a custom worksheet from a personal template into an Excel workbook.

Insert a Worksheet from a Personal Template in Excel 365 for Mac
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.
Before you start

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.

Solution 1Recommended

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.

1
Open both workbooks

In Excel, open the workbook containing the custom worksheet and the workbook where you want to insert it.

2
Open Move or Copy

In the source workbook, right-click the custom worksheet tab and select Move or Copy.

3
Choose the destination

In the Move or Copy dialog, select the destination workbook and choose where to place the sheet.

4
Copy the sheet

Select Create a copy, then click OK. Check the new sheet in the destination workbook.

Copy the custom worksheet into the destination workbook
Check workbook references: If the copied sheet contains formulas or links to other sheets, check that they still refer to the intended data in the destination workbook.
Reuse a formatted worksheet

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. 1. Open the workbooks: In WPS Spreadsheet, open the workbook containing the custom sheet and the destination workbook.
  2. 2. Select the custom sheet: Right-click the custom worksheet tab and choose Move or Copy.
  3. 3. Set the destination: Choose the destination workbook and the position for the copied sheet in the dialog.
  4. 4. Create the copy: Select Create a copy and confirm. Review the copied sheet and save the destination workbook.
Reuse a custom worksheet's layout and formattingOpen and save Microsoft Excel XLSX workbooksWork with a familiar spreadsheet interfaceUse WPS Office for free
QA img-9

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.