Skip to content

§ 3.6Using SuperSheets

Sort, Filter & Column Operations

Sorting#

Click the sort arrows in a column header, or right-click the header and choose Sort A→Z / Sort Z→A. Sorts are applied to the full dataset and logged in the Activity Monitor.

Filtering#

Click the funnel icon in the toolbar to open the filter panel. You can filter any column by value. Filters stack — multiple columns can be filtered simultaneously. The aggregation footer reflects only the filtered rows.

Resizing Columns#

Hover over the divider between two column headers until the cursor changes to a horizontal resize arrow. Click and drag to set the column width. Minimum width is 60 px. The new width is saved automatically.

Renaming Columns#

3 stepsTick steps off as you go
  1. Double-click the column header

    The header enters inline rename mode.
  2. Type the new name

    Enter the replacement name.
  3. Confirm or cancel

    Press Enter to confirm, or Escape to cancel. The rename is logged in the Activity Monitor.

Column Masking (Privacy)#

Masking hides the raw values of a column — ideal for sensitive data like salaries or passwords. Masked cells show •••••• instead of the actual value. Formulas referencing masked columns still compute correctly, but the formula bar also hides raw values.

3 stepsTick steps off as you go
  1. Right-click the column header

    Open the column context menu.
  2. Click Mask Column

    Click Mask Column (or Unmask Column if already masked). Alternatively use the Columns visibility panel (eye icon) in the toolbar.
  3. Bulk masking

    Ctrl / ⌘-click multiple headers to select them, then use the column menu → Mask Selected.

Deleting Columns#

  • Right-click the column header and select Delete Column.
  • Ctrl / ⌘-click to select multiple columns, then choose Delete Selected Columns from the menu.
  • Column deletion is permanent but can be reversed immediately with Ctrl / ⌘ + Z.