§ 3.5Using SuperSheets
Formatting & Selection
Formatting Toolbar#
Use the formatting toolbar above the grid to style selected cells, rows, or columns.
- Bold — Toggle bold on selected cells. Shortcut: Ctrl / ⌘ + B
- Italic — Toggle italic on selected cells. Shortcut: Ctrl / ⌘ + 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#
SuperSheets supports multi-cell drag selection with gold/amber highlights, just like Excel.
4 stepsTick steps off as you go
Click to select
Click a cell to select it — it highlights in gold.Drag to extend
Click and drag across cells to select a rectangular range. The range highlights in amber.Shift+click to extend
HoldShiftand click another cell to extend the selection to that cell.Select all
Press Ctrl / ⌘ + A to select all cells.
Column Selection#
Click any column header letter to select the entire column. Ctrl / ⌘-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#
The fill handle lets you copy a cell's value or formula down or across a range by dragging — exactly like Excel.
4 stepsTick steps off as you go
Select the source cell
Select a cell containing the value or formula you want to copy.Hover the bottom-right corner
Hover over the small square in the bottom-right corner of the cell. The cursor changes to a crosshair.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.Release to apply
Release the mouse to apply the fill. The action is logged in the Activity Monitor.