Fit a sheet on one page in Google Sheets
Create a compact one-page version of the wide report in L1:O4. Use the headers Project, Owner, Due, and Status and copy all three records. Do not change the wide source report.
Verified by JosephineAbout 60 secondsCreate a compact one-page version of the wide report in L1:O4. Use the headers Project, Owner, Due, and Status and copy all three records. Do not change the wide source report.
Step-by-step
Select the targetCreate a compact one-page version of the wide report in L1:O4.
Apply the changeUse the headers Project, Owner, Due, and Status and copy all three records.
Shortcut or faster method
Use the menu path shown in the video and keep the target range selected until the change is applied.
Expected result
L1:O4 contains the complete four-column report in a compact print-ready layout.
Common mistake
Changing the source values while applying the formatting or structure change.
Troubleshooting
Re-select L1:O4 and repeat the final action. L1:O4 contains the complete four-column report in a compact print-ready layout.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Project | Owner | ||||
| Website | Anna | ||||
| Launch | Ben | ||||
| Audit | Cara |
Video transcript
- Open the prepared One-page report spreadsheet.
- Select the target. Create a compact one-page version of the wide report in L1:O4.
- Apply the change. Use the headers Project, Owner, Due, and Status and copy all three records.
- L1:O4 contains the complete four-column report in a compact print-ready layout.