How to Edit Excel Slicer Styles and Button Settings in WPS Spreadsheets
Question details
The user wants to change a slicer's built-in style, button height, button width, and button column layout from the Slicer contextual tab.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is working in a workbook that contains a pivot table and wants to customize a slicer's appearance and layout.
- Observed behavior
- Slicer formatting is managed through the Slicer contextual tab, including built-in styles, button height, button width, and button column count; a fully custom slicer style is not available from the standard controls.
Open the workbook that contains the slicer, then click the slicer once so the Slicer contextual tab appears. If the tab does not appear, make sure the slicer is selected and that the worksheet or workbook is not protected.
Change slicer style, button size, and column layout from the Slicer tab
Use this method to apply a built-in visual style and adjust the button dimensions and column count for any selected slicer.
The Slicer tab appears only when a slicer is selected. Its controls are the standard way to modify slicer formatting.
In WPS Spreadsheets, open the worksheet that contains the pivot table and click the slicer you want to format.
Click the Slicer contextual tab that appears on the ribbon.
In the Slicer Styles gallery, choose a style to change the slicer's colors and appearance.
In the Buttons group, change the button height and button width values to resize the slicer buttons.
In the Buttons group, adjust the number of button columns to control how many buttons appear per row or column in the slicer.
Edit slicer styles and button settings with WPS Spreadsheets
Use the built-in Slicer tab in WPS Spreadsheets to change slicer colors, resize slicer buttons, and set button columns while working with Excel-compatible workbooks.
- 1. Download WPS Office: Install the free WPS Office suite from the official WPS download page and open WPS Spreadsheets.
- 2. Open the workbook: Open the Excel-compatible workbook that contains the pivot table and slicer.
- 3. Select the slicer: Click the slicer to reveal the Slicer contextual tab on the ribbon.
- 4. Edit style and button settings: Use the Slicer Styles gallery and Buttons group to apply a style, set button height and width, and choose the number of button columns.
- 5. Save the updated file: Save the workbook to keep your slicer formatting changes.
Frequently Asked Questions
Where is the Slicer tab in WPS Spreadsheets?
Select the slicer in a worksheet and the Slicer contextual tab appears on the ribbon. If it does not appear, click the slicer once or check whether the workbook is protected.
Can I create a fully custom slicer style in Excel?
No. Excel and WPS Spreadsheets let you apply built-in slicer styles, but they do not allow fully custom slicer styles directly from the standard style controls.
How do I change how many buttons appear in each slicer column?
Select the slicer, open the Slicer tab, go to the Buttons group, and adjust the number of button columns.
Why are my slicer style options grayed out?
This usually happens when the worksheet is protected, the slicer is locked, or the file is in read-only or compatibility mode. Unprotect the sheet or enable editing and select the slicer again.
