How to Remove a Slicer That Blocks an Excel Worksheet in WPS Spreadsheets
Question details
The user needs to move or remove an accidentally inserted Excel slicer that is covering a worksheet on a Mac without deleting the worksheet or existing data.
- Product
- WPS Spreadsheets
- Device & OS
- macOS
- Scenario
- A slicer was accidentally inserted in an Excel worksheet and is covering the visible working area.
- Observed behavior
- The slicer blocks access to worksheet cells, so the user needs to move or remove it without deleting existing worksheet content.
Make sure the worksheet is open in WPS Spreadsheets and the slicer is visible. Click the slicer border rather than its buttons when selecting it for moving or deletion.
Move the Slicer Away from the Blocked Worksheet Area
Use this method first when the slicer covers data and you need immediate access to the worksheet without deleting anything.
Moving the slicer is non-destructive and is the safest way to restore the visible working area before deciding whether to delete it.
Click the outer border of the slicer once so that move handles appear around it.
Drag the slicer by its border to an empty part of the worksheet, away from cells and other objects.
Release the mouse or trackpad and confirm that the blocked cells are accessible again.
Delete the Slicer Completely from the Worksheet
Use this when you no longer need the slicer and want to remove it from the workbook without affecting the data.
Remove Excel Slicers Safely in WPS Spreadsheets
Open your Excel workbook in WPS Spreadsheets, move or delete the blocking slicer from the worksheet, and continue working with the same pivot table and data layout.
- 1. Open the Excel workbook: Launch WPS Spreadsheets and open the Excel workbook that contains the blocking slicer.
- 2. Select the slicer: Click the slicer border to select it and reveal the move handles.
- 3. Move or delete the slicer: Drag the slicer away from the data area, or press Delete to remove it completely.
- 4. Save the file: Save the workbook in Excel format to preserve compatibility with Microsoft Excel.
Frequently Asked Questions
Will deleting a slicer delete the underlying Excel data?
No. Deleting a slicer removes only the filter control. The worksheet data and any connected pivot table remain unchanged.
Can I move a slicer instead of deleting it in WPS Spreadsheets?
Yes. Click the slicer border and drag it to an empty area of the worksheet. This restores access without removing the slicer.
How do I select a slicer that is covering all visible cells?
Click its outer border, or use the Selection Pane in the editing tools to select the slicer by name, then drag or delete it.
Does this work the same way on Mac and Windows?
The steps are similar. On a Mac, use Delete or Fn+Delete; on Windows, select the slicer and press Delete.
