Show Menu
Cheatography

SC-IM - Spreadsheet Calculator Improvised -- An ncurses spreadsheet program for terminal

Basic Navigation

hjkl
Move cursor down, up, right or left.
^
Go up to row 0 of the current column.
#
Go down to the last valid row of the current column.
0
Go left to column A in the current row.
$
Go right to the last valid column of the current row.
b/w
Go back/f­orward to the previous valid cell.
gg/G
Go to the first/last cell of sheet.
gl
Go to the last (previ­ously occupied) cell position
gab24
Go to cell AB24.
'{aZ}
Go to the cell/range marked previously with the char.

Insert Mode

=
Enter a numeric constant or expres­sion.
<
Enter a left justified string or string expres­sion.
\
Enter a centered label.
>
Enter a right justified string or string expres­sion.
<bs>
Delete the character after or before the cursor.
<ta­b>
Return to Edit mode from Insert mode.
^v
Enter Visual mode.

Commands for handling cell content

x
Delete the current selected cell or range and save its content in the yankbu­ffer.
{}|
Align the content of a cell to the left/r­igh­t/c­enter.
f[jk]
Decrem­ent­/In­crement decimal precision.
f[hl]
Decrem­ent­/In­crement column width.
i[rc]
Insert a row/co­lumn.
o[rc]
Insert after the current row/co­lumn.
s[hjkl]
Shifts the current cell or range left/d­own­/up­/right.
yy
Yank the selected cell.
y
If a range is selected, yank the range.
y[rc]
Yank current row/co­lumn.
p
Paste the previously yanked cell or range.
d[rc]
Delete the current row/co­lumn.
-/+
Decrea­se/­Inc­rease a numeric value of the cell or range.
u/^r
UNDO/REDO last change
.
Repeat the last normal mode command.
aa
Auto-r­esize the selected column(s) to accomm­odate the widest cells
 

Scroll Navigation

^[fb]
Scrolls down/up full screen.
^[ey]
Scroll a row down/up.
z[hl]
Scroll left/right one column.
z[HL]
Scroll left/right half a page.
zm
Horizo­ntally to position the selected cell at the center of the screen.
zz
Vertically to position the selected cell at the middle of the screen.
z[tb]
Vertically to position the selected cell at the top/bottom of the screen.

Visible Navigation

H
Go to the top row visible on screen.
L
Go to the lowest row visible on screen.
M
Go to the middle row on the screen.
g0
Go to the leftmost column visible on screen.
g$
Go to the rightmost column visible on screen.
gM
Go to the middle column on the screen.

Other commands

^L
Redraw the screen.
Z[rc]
Zap (hide) the current row/co­lumn.
S[rc]
If a range is selected, show the rows/c­olumns hidden in the range.
/
Alias for ':int goto '.
n/N
Move to next/p­reviuos search match.
rl
Lock the current cell or range.
ru
Unlock a locked cell or range, making it editable.
rv
Valueize the current cell or range.
   
 

Metadata

  • Languages:
  • Published: 1st March, 2021

Comments

No comments yet. Add yours below!

Add a Comment

Your Comment

Please enter your name.

    Please enter your email address

      Please enter your Comment.

          More Cheat Sheets by isaacnewton

          fugitive Keyboard Shortcuts