← Mit Tabellen arbeiten
Lektion 4 von 5
Making a sheet someone else can read
Was du danach kannst
Format numbers and dates so they are unambiguous, structure headers so the sheet can be navigated, and avoid the formatting choices that break later work.
The numbers are right. Right now the sheet still looks like a data dump, and the branch manager is going to open it on a laptop and scroll. Formatting is not decoration here, some of it is the difference between a sheet that sorts and one that does not.
0 XP
Schritt 1 von 6 · 1 Punkt
Format the unit prices in F2:F13 as US dollars with two decimals and a thousands separator.
Formatierung
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ||||||||||
| 2 | ||||||||||
| 3 | ||||||||||
| 4 | ||||||||||
| 5 | ||||||||||
| 6 | ||||||||||
| 7 | ||||||||||
| 8 | ||||||||||
| 9 | ||||||||||
| 10 | ||||||||||
| 11 | ||||||||||
| 12 | ||||||||||
| 13 |
Rows 1 to 13 of 13