Chapter 2: Print settings
Exercise 6: Fit all columns on one page
Task
Keep portrait, but fit all columns on one page so the right edge of the table is not cut off.
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 |
Keep portrait, but fit all columns on one page so the right edge of the table is not cut off.
This drill is for computer screens. On a phone you can review the steps.
- Press Ctrl + P to open the print screen
- Change "No Scaling" to "Fit All Columns on One Page"
- Or: on Page Layout, set "Width" to "1 page" (Alt → P → W)
Key takeaway
The height stays the same; only the width is shrunk to fit one page.
See how to make a table in Excel for details.