← Travailler avec les feuilles de calcul
Leçon 5 sur 5
Printing what you meant to print
Ce que vous saurez faire
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
Étape 1 sur 6 · 1 point
Set the print area to just the order data and its totals: A1:H13.
Mise en forme
Dans Excel, cela se trouve dans Mise en page > Zone d'impression > Définir la zone d'impression. Ici, saisissez dans cette zone la plage que vous voulez imprimer.
| 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