Page Layout
Set the orientation to portrait or landscape.
- Choose the best layout for your spreadsheet's data and design
Control the page layout for printing.
- Specify the number of pages, print area, display or hide gridlines, and display or hide row and column headings
Consider the following example spreadsheet:
A |
B |
C |
|
1 |
Name |
Mark |
Year |
2 |
Alex |
85 |
11 |
3 |
Ben |
90 |
12 |
4 |
Chloe |
80 |
11 |
5 |
Dave |
88 |
12 |
6 |
Eve |
82 |
11 |
- Set the orientation to landscape to accommodate the table's width
- Define the print area as A1:C6
- Hide gridlines and display row and column headings for a clean printout
Exam Tip
- Always preview your printout before printing to ensure it looks as expected and fits within the designated page boundaries
- Remember to set the print area, especially if you only want to print a specific part of the spreadsheet