§ 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#
Double-click the column header
The header enters inline rename mode.Type the new name
Enter the replacement name.Confirm or cancel
PressEnterto confirm, orEscapeto 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.
Right-click the column header
Open the column context menu.Click Mask Column
ClickMask Column(orUnmask Columnif already masked). Alternatively use the Columns visibility panel (eye icon) in the toolbar.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 chooseDelete Selected Columnsfrom the menu.- Column deletion is permanent but can be reversed immediately with Ctrl / ⌘ + Z.