Chapter 2: Print settings
Exercise 8: Set the print area
Task
The notes on the right get printed too. Make only the table in A1:D6 the print area.
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 | |
|---|---|---|---|---|---|---|---|
| 1 | Item | Rep | Qty | Amount | Notes (not printed) | ||
| 2 | Notebook | Smith | 12 | 18000 | Checking unit price | ||
| 3 | Ballpoint pen | Johnson | 5 | 1250 | |||
| 4 | Clear folder | Williams | 30 | 36000 | Price rises next month | ||
| 5 | Sticky notes | Brown | 8 | 2400 | |||
| 6 | Total | 55 | 57650 | ||||
| 7 | |||||||
| 8 |
The notes on the right get printed too. Make only the table in A1:D6 the print area.
This drill is for computer screens. On a phone you can review the steps.
- Select A1:D6
- Page Layout → "Print Area" → "Set Print Area" (Alt → P → R → S)
Key takeaway
The print area is saved with the workbook. To remove it, use "Clear Print Area".
See how to make a table in Excel for details.