[Read on Dashport](https://dashport.ai/documentation/sort-filter-columns)

Using SuperSheetsSort, filter & columns

Copy page

[

Dashport Docsv2.0](/documentation)

Getting Started

IntroductionCreating your account5-minute quick start

Connecting Data

Supported integrationsConnect a databaseColumn comments & AI contextSuperSheets as a sourceCredential securityRefresh intervals

Using SuperSheets

What is SuperSheets?Creating a sheetData entry & column typesFormulas & calculationsFormatting & selectionSort, filter & columnsRow operationsValidation & frozen panesImport & exportSharing & activity logKeyboard shortcutsUse as a data source

Asking Chat

How Chat worksWriting effective promptsExample conversationsBuilding charts via ChatLimits & best practices

Building Dashboards

Three ways to buildDrag-and-drop builderAsk Chat to buildSharing & permissions

Using SuperSheetsSort, filter & columns

Copy page

## Sort, Filter & Column Operations[](#ss-sort-filter)

### Sorting[](#ss-sort-filter-sort)

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[](#ss-sort-filter-filter)

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.

Note

Sorting and filtering are non-destructive — the underlying data is unchanged. Clear filters to restore the original row order.

### Resizing Columns[](#ss-sort-filter-resize)

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[](#ss-sort-filter-rename)

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)[](#ss-sort-filter-mask)

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.

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 / \u2318`\-click multiple headers to select them, then use the column menu \\u2192 `Mask Selected`.

Warning

Column masking is a display-only privacy layer. The data is still stored in localStorage — do not use SuperSheets to store truly sensitive production data.

### Deleting Columns[](#ss-sort-filter-delete)

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

Previous

Formatting & selection

Next

Row operations
