lk/data/sc-im.md

65 lines
1.8 KiB
Markdown
Raw Permalink Normal View History

2022-01-16 18:20:39 +00:00
---
title: "sc-im"
tags: [ "Documentation", "data" ]
---
2020-01-02 00:04:35 +00:00
# Edit
2022-07-09 17:46:55 +00:00
## Text
| Action | Key |
|:----------------------|:---:|
| text (left align) | < |
| text (right align) | > |
2023-06-08 15:45:22 +00:00
| text (right align) | `|` |
2022-07-09 17:46:55 +00:00
| Edit existing text | E |
## Meta Actions
| Action | Key |
|:----------------------|:---:|
| edit a number | e |
| delete column | dc |
| yank column | yc |
| delete row | dr |
| literal paste | p |
| paste with format | Pc |
| delete a cell | x |
2023-06-08 15:45:22 +00:00
# Movement
| Action | Key |
|:-------------------------------:|:---:|
| highest part | H |
| lowest part | L |
| top | gg |
| move right | g$ |
| move left | g0 |
| insert middle | \ |
| insert left | \> |
| insert right | < |
| to to cell b4 | b4 |
| see all text in cells | aa |
| format cells so you can see it. | f |
| format wider right | fl |
| format smaller left | fh |
| format wider down | fj |
| format smaller down | fk |
2022-07-09 17:46:55 +00:00
## Functions
2020-01-02 00:04:35 +00:00
2022-12-21 22:30:20 +00:00
| Action | Key |
|:--------------------------------|:------------:|
| add A1 to A4 | =@sum(A1:A4) |
| average B1 to B4 | =@avg(B1:B4) |
| maximum of those numbers | =@max(B1:B4) |
| minimumof those numbers | =@min(B1:B8) |
| multiply C1 to C8 | =@prod(C1:C8)|
2020-01-02 00:04:35 +00:00
2022-07-09 17:46:55 +00:00
## Visual
2020-01-02 00:04:35 +00:00
2022-07-09 17:46:55 +00:00
| Action | Key |
|:--------------------------------|:------------:|
| Increase decimals | f- |
| Decrease decimals | f+ |