Cheatography
https://cheatography.com
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/forward to the previous valid cell. |
gg/G
|
Go to the first/last cell of sheet. |
gl
|
Go to the last (previously 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 expression. |
<
|
Enter a left justified string or string expression. |
\ |
Enter a centered label. |
>
|
Enter a right justified string or string expression. |
<bs>
|
Delete the character after or before the cursor. |
<tab>
|
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 yankbuffer. |
{}|
|
Align the content of a cell to the left/right/center. |
f[jk]
|
Decrement/Increment decimal precision. |
f[hl]
|
Decrement/Increment column width. |
i[rc]
|
Insert a row/column. |
o[rc]
|
Insert after the current row/column. |
s[hjkl]
|
Shifts the current cell or range left/down/up/right. |
yy
|
Yank the selected cell. |
y
|
If a range is selected, yank the range. |
y[rc]
|
Yank current row/column. |
p
|
Paste the previously yanked cell or range. |
d[rc]
|
Delete the current row/column. |
-/+
|
Decrease/Increase a numeric value of the cell or range. |
u/^r
|
UNDO/REDO last change |
.
|
Repeat the last normal mode command. |
aa
|
Auto-resize the selected column(s) to accommodate 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
|
Horizontally 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/column. |
S[rc]
|
If a range is selected, show the rows/columns hidden in the range. |
/
|
Alias for ':int goto '. |
n/N
|
Move to next/previuos 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. |
|
Created By
Metadata
Comments
No comments yet. Add yours below!
Add a Comment
More Cheat Sheets by isaacnewton