'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel Not Showing New Cell Style Option
Question details
The user is unable to find the New Cell Style or More options within the Cell Styles menu in Excel.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to create and apply a custom cell style to format data within a workbook.
- Observed behavior
- The New Cell Style option is completely missing from the Excel ribbon interface, preventing the creation of custom cell formatting.
Before troubleshooting, check your browser or taskbar to confirm whether you are accessing your workbook through Excel for the web or the locally installed Excel desktop application.
Switch from Excel for the Web to the Desktop Application
Excel for the web has limited features and does not support creating custom cell styles. Opening the file in the full desktop app resolves this issue.
Excel for the web is a lightweight version of the software designed for quick edits and real-time collaboration. Certain advanced formatting features, including the ability to create, modify, and save custom 'New Cell Styles', are exclusive to the full desktop version of Excel.
While viewing your workbook in Excel for the web, look at the ribbon menu at the top of your screen and click on the 'Viewing' or 'Editing' button.
Select 'Open in Desktop App' from the dropdown menu. If prompted by your browser, confirm that you want to open the Microsoft Excel application.
Once the file opens in your local Excel application, navigate to the Home tab, click on 'Cell Styles', and the 'New Cell Style' option will now be visible at the bottom of the gallery.
Use WPS Office for Full Spreadsheet Formatting
If you don't have access to the Microsoft Excel desktop application, WPS Office provides a powerful, free alternative. WPS Spreadsheet includes comprehensive cell formatting and style options natively in its lightweight desktop app, allowing you to customize your workbooks without the limitations of a web browser.
- 1. Download and Install WPS Office: Get the free WPS Office desktop suite from the official website and install it on your device.
- 2. Open your Excel file: Launch WPS Spreadsheet and open your existing .xlsx workbook directly.
- 3. Apply Custom Styles: Navigate to the Home tab and use the Styles tools to create and apply custom cell styles exactly as you need.
Frequently Asked Questions
Can I create custom cell styles in Excel for the web?
No, Excel for the web currently does not support creating new cell styles. You can only apply the pre-existing default styles provided in the online ribbon. To create custom styles, you must use a desktop spreadsheet application.
Why are some features missing when I open an Excel file in my browser?
Excel for the web is a simplified version of the desktop application. Advanced tools, macros, and specific formatting options like custom cell styles are intentionally excluded to keep the web application fast and lightweight.
How do I transfer my custom cell styles to another workbook?
In the desktop version of Excel, open both the workbook containing your custom styles and the destination workbook. Go to the Home tab, click Cell Styles, select Merge Styles, and choose the workbook you want to copy the styles from.
Will WPS Office recognize my existing Excel custom cell styles?
Yes, WPS Spreadsheet is highly compatible with Microsoft Excel formats. When you open a file with custom cell styles saved from Excel desktop, WPS Spreadsheet will recognize and accurately display those custom formats.
