Commands

VimSheet commands are entered after pressing : in NORMAL mode. Commands can be prefixed with a range in visual mode (e.g., :A1:B10 fill 1 or :A1:B10 plot line).

File Operations

Command

Description

:e <path>

Open a file

:w

Save current workbook

:w <path>

Save to a specific path

:wq

Save and quit

:x

Save and quit (alias for :wq)

:q

Quit (fails if there are unsaved buffers)

:q!

Force quit without saving

:sp <file>

Open file in a split buffer

:ex <file>

Export to file (format detected by extension)

:ex <format> <file>

Export with explicit format (csv, json, html, md, tex)

Buffer Management

Cell Operations

Search and Replace

Sheet Operations

Command

Description

:sa [name] / :sheetadd [name]

Add a new sheet

:sd [name] / :sheetdel [name]

Delete a sheet by name (or current sheet if no name)

:sr <newname>

Rename current sheet

:sr <oldname> <newname> / :sheetrename

Rename a sheet by name

:sdup [name] / :sc [name] / :sheet copy [name]

Duplicate a sheet (appends “ (copy)” suffix)

:sl / :sheets / :sheetlist

List all sheets

:sheet <name>

Switch to named sheet

:nextsheet

Go to next sheet

:prevsheet

Go to previous sheet

:undodelsheet

Restore the last deleted sheet

Sort and Filter

Column and Row Management

Conditional Formatting

Plotting

Command

Description

:plot <type> [range] [title]

Plot a chart — type first, optional range and title (types: bar, line, scatter, pie, histogram)

:plot <range> <type> [title]

Plot a chart — range first, then type

:plot

Plot cursor column as bar chart (default)

:<range> <type>

Visual-mode shorthand — e.g., :A1:B10 line (no plot keyword needed)

HTTP Fetching

Command

Description

:fetchnow

Force immediate refresh of all HTTP-fetched cells

:fetchstop

Stop all background HTTP fetches

:fetchlist

Show all active HTTP fetch cells

Configuration

Command

Description

:set <option>=<value>

Set a configuration option

:set

Show current setting for an option

:theme <name>

Switch theme (dark, light, nord, gruvbox, dracula, tokyo, monokai, solarized, catppuccin, rose-pine)

:colorscheme

Show all current palette field values

:colorscheme <field> <value>

Set a palette field (hex, named colour, or $variable)

:colorscheme reset [field]

Reset palette to theme defaults

:colorscheme save

Persist current overrides to config.json

:recalc

Force full recalculation of all formulas

Scripting

Command

Description

:funcs [filter]

List all available formula functions

:loadtext <file>

Load text file content into current cell

Miscellaneous