Working with Cells

Copying Cells

To copy a cell's content, right-click or double-click on the cell and select "Copy <cell name>". The cell content is copied to your browser's clipboard.

Filtering Cells

To apply a filter on a value:

1. Right-click or double-click the cell and select "Filter by <cell name>". The dialog 'Apply Filter' opens.
   
   
2. Adjust the filter to your needs and confirm with "Create Filter". The filter applies and the data set is filtered. Only matching values to the filter are displayed.
   
   

Excluding Cells

To exclude a value from the data set:

1. Right-click or double-click the cell and select "Exclude <cell name>". The dialog 'Apply Filter' opens.
   
2. Adjust the filter to your needs and confirm with "Create Filter". The filter applies and values that do not fit to the filter rules are excluded from the data set.
   
   

Splitting Cells

To split the data set from a cell:

1. Right-click or double-click the cell and select "Split on <cell name>". The 'Split to Columns' configuration opens on the right side.
   
   
2. Check the pre-filled selection from the section "Input": 'Column', 'Type' and 'Delimiter' are already pre-selected according to the selected cell. If needed, enter the amount of skipped leading characters and/ or skipped trailing characters.
   
3. Check the section "Output": If needed, enter the amount of elements skipped first. Then decide into how much columns the cells shall be split. Then decide whether to catch additional elements in an overflow column or drop those elements by selecting the relevant bullet point. If needed, mark the check boxes for 'Trim Whitespace' and/ or 'Define Empty Value'. Finally, adjust the "Column Prefix". Per default, the prefix is the current column name.
   
4. Confirm with "Create Sheet". Splitting cells is finished. The new sheet is displayed.