spreadsheets

I use the sc tool for spreadsheets needs.

sc official website

It isn't the most powerful or versatile tool, but it gets the spreadsheets job right.

shortcuts

moving around

• Z: hides a row or column
• s: shows a row or column
• g<XY>: Jump to cell (e.g. gB13 jumps to cell B13)
• i: Insert a row or a column
• m<c>: Mark cell as character (e.g. mu marks cell as u)
• c<c>: Copies the content of the cell marked with the given character (e.g. cu copies the content of the cell marked as u)
• C-f, C-b: Page up / down

managing data

• =: Enters a numeric value or formula
• <: Enters left-justified text
• \: Enters centered text
• >: Enters right-justified text
• e: Edit a numeric value
• E: Edit a string value
• x: Clear cell's content
• d[rcd]: Delete a row (r), column (c), or cell (d)
• y[rcd]: Yank a row (r), column (c), or cell (d)
• p[rcd]: Paste a row (r), column (c), or cell (d)

saving your project

• @: Force re-calculation of all rows
• W<filename>: Writes the sheets in a .txt file
• P<filename>: Writes the sheets in a .sc file
• G<filename>: Reads the sheets from a .sc file