Change the Default Theme for Excel Move or Copy Worksheets
Question details
The user wants worksheets copied to a new workbook with Excel Move or Copy to retain a preferred workbook theme and font instead of using the newer default theme and Aptos Narrow.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet is moved or copied to a newly created workbook by selecting the New book option in the Move or Copy dialog.
- Observed behavior
- The new workbook uses a newer Excel theme and Aptos Narrow rather than the theme used in the original workbook.
Create a workbook containing one worksheet and apply the theme, fonts, colors, and effects you want new copied worksheets to use. Close Excel before placing the template in XLSTART so Excel can load it when it starts.
Create a Sheet.xltx template in the Excel XLSTART folder
Use this method when Move or Copy creates a new workbook with an unwanted default theme or font.
Excel can use a one-sheet template named Sheet.xltx when it creates a new workbook from a copied or moved worksheet. The template must contain the desired theme and be saved in the active XLSTART startup folder.
Open Excel, create a blank workbook, keep one worksheet, then go to Page Layout > Themes and apply the required theme. Use Page Layout > Fonts if you need to confirm the theme font selection.
Select File > Save As, choose Excel Template (*.xltx) as the file type, and name the file exactly Sheet.xltx.
Move or save Sheet.xltx to Excel's XLSTART folder. On many Windows installations, enter %appdata%\Microsoft\Excel\XLSTART in File Explorer's address bar to open the folder.
Close all Excel windows, reopen Excel, then select a worksheet and choose Home > Format > Move or Copy Sheet. Choose (new book) and verify that the new workbook uses the template theme.

Copy the worksheet into an existing themed workbook
Use this workaround when you need a guaranteed theme match for a specific workbook or cannot use an XLSTART template.
Use WPS Spreadsheets to copy worksheets while managing workbook themes
If Microsoft Excel continues to apply an unwanted default theme when creating a new workbook, WPS Office provides a free, lightweight spreadsheet alternative with a familiar interface and straightforward workbook formatting tools. You can open, edit, and migrate Excel files while managing themes and worksheet copies in WPS Spreadsheets.
- 1. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheets from the WPS Office home screen.
- 2. Open the Excel workbook: Select Open and choose the existing .xlsx or .xls workbook that contains the worksheet and formatting you need.
- 3. Set the workbook appearance: Use the Page Layout tab to choose a theme, colors, fonts, or effects for the workbook.
- 4. Copy the worksheet: Right-click the worksheet tab and select the available Move or Copy command to place the sheet in the required workbook or create a copy.

Frequently Asked Questions
Why does Excel use Aptos Narrow after I copy a worksheet to a new workbook?
When Move or Copy creates a new workbook, Excel may use its current default workbook template and theme rather than the theme from the source workbook. A Sheet.xltx template in XLSTART can define the preferred default theme.
What is the required name for the Excel worksheet template?
Name the one-sheet Excel template Sheet.xltx. Excel looks for that specific filename when it creates a new workbook from a worksheet operation.
Where is the Excel XLSTART folder on Windows?
A common location is %appdata%\Microsoft\Excel\XLSTART. Paste that path into File Explorer's address bar. If your installation uses a different startup folder, check Excel's configured startup locations.
Do I need to restart Excel after adding Sheet.xltx?
Yes. Close all Excel windows and reopen Excel after placing Sheet.xltx in XLSTART so the application can load the template.
Can I keep the original theme by copying into another workbook?
Yes. Open a destination workbook that already uses the desired theme, then right-click the source worksheet tab, select Move or Copy, and select that workbook in the To book list rather than choosing (new book).




