Chapter 2: Print settings
Exercise 5: Print in landscape
Task
In portrait, the monthly table splits across two pages. Change the orientation to landscape.
Moves 0 (target 1)1 difference(s) from the model
File
Font
Alignment
Number
Styles
Cells
A1Press and release Alt to show KeyTips (Windows). Ctrl + 1 opens Format Cells, Ctrl + Z undoes.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Branch | Apr | May | Jun | Jul | Aug | Sep | Total |
| 2 | New York | 1000 | 1600 | 2200 | 1450 | 2050 | 1300 | 9600 |
| 3 | Chicago | 2050 | 1300 | 1900 | 1150 | 1750 | 1000 | 9150 |
| 4 | Houston | 1750 | 1000 | 1600 | 2200 | 1450 | 2050 | 10050 |
| 5 | Seattle | 1450 | 2050 | 1300 | 1900 | 1150 | 1750 | 9600 |
| 6 | Boston | 1150 | 1750 | 1000 | 1600 | 2200 | 1450 | 9150 |
| 7 | Denver | 2200 | 1450 | 2050 | 1300 | 1900 | 1150 | 10050 |
| 8 | ||||||||
| 9 |
In portrait, the monthly table splits across two pages. Change the orientation to landscape.
This drill is for computer screens. On a phone you can review the steps.
- Page Layout → "Orientation" → "Landscape" (Alt → P → O)
- Or: choose "Landscape Orientation" on the Ctrl + P print screen
Key takeaway
Tables with many columns fit on one page more easily in landscape.
See how to make a table in Excel for details.