How to Save Custom Company Colors Permanently in WPS Spreadsheets Templates
Question details
Use WPS Spreadsheets to save custom cell and font colors in a reusable Excel-compatible template so a company can apply the same branding across multiple workbooks.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- The user needs to store company cell and font colors once and reuse them across multiple workbooks without manually entering color codes every time.
- Observed behavior
- Company colors are saved in a reusable template so new workbooks start with the correct cell and font colors.
Open WPS Spreadsheets and prepare one workbook that contains the exact cell fills, font colors, and styles your company uses. Decide whether the template will be stored in your personal template folder or a shared team location.
Save a company color workbook as an Excel template
Use this method when you want a simple, reusable .xltx template that preserves company cell and font colors for yourself or your team.
The .xltx template stores the formatting, including cell fill colors and font colors, so every new workbook based on the template starts with the same branded design.
Open WPS Spreadsheets and apply the company cell fills, font colors, borders, and styles that you want to reuse.
Click the File menu, choose Save As, and select a location such as your local template folder or a shared team folder.
In the file type dropdown, choose Excel Template (*.xltx), enter a clear file name such as Company_Colors.xltx, and click Save.
Click File > New, choose Personal or Shared templates, and open the saved template. New workbooks will keep the saved colors and formatting.
Deploy the company template for organization-wide use
Use this method when multiple team members need to access the same company colors from one central shared location.
Save and Reuse Company Colors with WPS Spreadsheets Templates
Create a company-branded workbook in WPS Spreadsheets, save it as an Excel template, and reuse the exact cell and font colors across new workbooks without re-entering color codes.
- 1. Open WPS Spreadsheets: Launch WPS Office and open WPS Spreadsheets to create a new workbook.
- 2. Apply company colors and styles: Select the cells or fonts, then use the Font Color and Fill Color buttons on the Home tab to apply your company RGB or HEX colors.
- 3. Save as Excel Template: Click File > Save As, choose Excel Template (*.xltx) from the file type list, name the file, and save it to your template folder.
- 4. Reuse the template: Click File > New, choose Personal or Shared templates, and open the saved template to start a new workbook with your company colors.
Frequently Asked Questions
Can I use custom RGB or HEX colors in a WPS Spreadsheets template?
Yes. Select the cell or font, click the Font Color or Fill Color button on the Home tab, choose More Colors, and enter the company RGB or HEX value before saving the template.
Will the .xltx template keep formatting when opened in Microsoft Excel?
Yes. WPS Spreadsheets saves the workbook as an Excel Template (*.xltx). The cell fills, font colors, and styles remain visible when the template is opened in Microsoft Excel.
Where should I save the template so my team can reuse it?
Save the .xltx file to a shared network folder or your organization's WPS Office template library. Team members can then open File > New, select Shared or Personal templates, and choose the company template.
Can I make the company color template the default for all new workbooks?
You can create a template and distribute it through your organization's shared template location. For all users to automatically start with that template, ask your IT department to deploy it as the default template or custom theme.
Do custom fonts in the template appear on every computer?
The template stores the font names and colors, but the fonts themselves must be installed on each computer. If a required font is missing, the system may substitute another font.
