Sort, Filter & Column Operations
Sorting
Click the sort arrows in a column header, or right-click the header and choose Sort A\u2192Z / Sort Z\u2192A. 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
Type the new name
Confirm or cancel
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 \u2022\u2022\u2022\u2022\u2022\u2022 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
Click Mask Column
Mask Column (or Unmask Column if already masked). Alternatively use the Columns visibility panel (eye icon) in the toolbar.Bulk masking
Ctrl / \u2318-click multiple headers to select them, then use the column menu \u2192 Mask Selected.Deleting Columns
- Right-click the column header and select
Delete Column. Ctrl / \u2318-click to select multiple columns, then chooseDelete Selected Columnsfrom the menu.- Column deletion is permanent but can be reversed immediately with
Ctrl / \u2318 + Z.