← Mit Tabellen arbeiten
Lektion 5 von 5
Printing what you meant to print
Was du danach kannst
Set a print area, fit the sheet to the page sensibly, and repeat headings so page two is still readable.
the branch manager prints this. Right now it would come out over four pages, with the headings only on the first, and column H on a sheet of its own. Ten minutes of page setup is the difference between a report and a pile of paper.
0 XP
Schritt 1 von 6 · 1 Punkt
Set the print area to just the order data and its totals: A1:H13.
Formatierung
In Excel findest du das unter Seitenlayout > Druckbereich > Druckbereich festlegen. Hier tippst du den Bereich, der gedruckt werden soll, in dieses Feld.
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ||||||||||||||
| 2 | ||||||||||||||
| 3 | ||||||||||||||
| 4 | ||||||||||||||
| 5 | ||||||||||||||
| 6 | ||||||||||||||
| 7 | ||||||||||||||
| 8 | ||||||||||||||
| 9 | ||||||||||||||
| 10 | ||||||||||||||
| 11 | ||||||||||||||
| 12 | ||||||||||||||
| 13 |
Rows 1 to 13 of 13