← Working With Sheets
Lesson 5 of 5
Printing what you meant to print
What you will be able to do
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
Step 1 of 6 · 1 point
Set the print area to just the order data and its totals: A1:H13.
Formatting
| 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