# Table Slicer

## Content

You can create a slicer for a table using the SpreadJS Designer.

Use the following steps to add a slicer.

1. Add table data and insert a table using the **Table** option under the **Insert** tab.
    
    ![](https://gcdocumentsitekrblob.blob.core.windows.net/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/images/designersliceraddtable.png)
2. Select the **Insert Slicer** option under the **Tools** section.
    
    ![](https://gcdocumentsitekrblob.blob.core.windows.net/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/images/designerslicertab.png)
3. The **Insert Slicer** dialog is displayed. Select the column or columns to create a slicer for.
    
    ![](https://gcdocumentsitekrblob.blob.core.windows.net/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/images/designerslicerinsert.png)
4. Use the **Options** tab to set the caption, height, width, number of columns, and styles.
    
    ![](https://gcdocumentsitekrblob.blob.core.windows.net/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/images/designersliceroptions.png)
5. Use the **Slicer Settings** dialog in the **Slicer** section to set additional options for the slicer such as whether to display a header and so on.
    
    ![](https://gcdocumentsitekrblob.blob.core.windows.net/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/images/designerslicersettings.png)

You can also display a context menu for the slicer by right-clicking on the slicer.

![](https://gcdocumentsitekrblob.blob.core.windows.net/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/images/designerslicercontext.png)

The **Size and Properties** option in the menu displays the following **Format Slicer** dialog. The dialog contains **Position and Layout**, **Size**, and **Properties** tabs.

The **Format Slicer** dialog allows you to set the horizontal and vertical location of the slicer, columns, whether to disable resizing and moving the slicer, the scale width, and height based on the original size, and whether to move and size with cells, and so on.

![](https://gcdocumentsitekrblob.blob.core.windows.net/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/images/designerslicerformatps.png)

![](https://gcdocumentsitekrblob.blob.core.windows.net/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/images/designerslicerformats.png)

![](https://gcdocumentsitekrblob.blob.core.windows.net/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/images/designerslicerformatp.png)