[Read on Dashport](https://dashport.ai/documentation/formatting-and-selection)

Using SuperSheetsFormatting & selection

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 SuperSheetsFormatting & selection

Copy page

## Formatting & Selection[](#ss-format-select)

### Formatting Toolbar[](#ss-format-select-toolbar)

Use the formatting toolbar above the grid to style selected cells, rows, or columns.

*   **Bold** — Toggle bold on selected cells. Shortcut: `Ctrl / \u2318 + B`
*   **Italic** — Toggle italic on selected cells. Shortcut: `Ctrl / \u2318 + I`
*   **Background Color** — Apply a background color to cells. Click the color swatch to open the picker.
*   **Row Formatting** — Select an entire row by clicking the row number, then apply toolbar styles.
*   **Column Formatting** — Click a column header to select the whole column, then use the toolbar.

### Cell Selection[](#ss-format-select-cell)

SuperSheets supports multi-cell drag selection with gold/amber highlights, just like Excel.

1

Click to select

Click a cell to select it — it highlights in gold.

2

Drag to extend

Click and drag across cells to select a rectangular range. The range highlights in amber.

3

Shift+click to extend

Hold `Shift` and click another cell to extend the selection to that cell.

4

Select all

Press `Ctrl / \u2318 + A` to select all cells.

Note

With a multi-cell selection active, pressing `Delete` or `Backspace` clears all selected cells at once.

### Column Selection[](#ss-format-select-col)

Click any column header letter to select the entire column. `Ctrl / \u2318`\-click to add more columns to the selection. A selected column can be used for bulk formatting, masking, and deletion via the column dropdown menu.

### Fill Handle & Drag-to-Copy[](#ss-format-select-fill)

The fill handle lets you copy a cell's value or formula down or across a range by dragging — exactly like Excel.

1

Select the source cell

Select a cell containing the value or formula you want to copy.

2

Hover the bottom-right corner

Hover over the small square in the bottom-right corner of the cell. The cursor changes to a crosshair.

3

Click and drag

Drag the handle down (or across) the cells you want to fill. A live preview shows the values to be filled in semi-transparent overlays on each target cell.

4

Release to apply

Release the mouse to apply the fill. The action is logged in the Activity Monitor.

Tip

Dragging a formula adjusts cell references automatically — e.g. `=A1+B1` becomes `=A2+B2` on the next row.

Previous

Formulas & calculations

Next

Sort, filter & columns
