To print an Excel dashboard on one page, select the dashboard cells and choose Page Layout, Print Area, Set Print Area. Then choose Landscape, set Scale to Fit to 1 page wide and 1 page tall, turn gridlines off, and check Print Preview. To save it as a PDF, use File, Export, Create PDF/XPS.
Set the print area first
Without a print area, Excel prints everything on the sheet that holds anything, including stray cells and notes far to the right. Select exactly the rectangle you want, from the title to the last chart, and choose Page Layout, then Print Area, then Set Print Area. A dotted line shows the boundary. To change it later, choose Clear Print Area and start again.
Page setup that works for a dashboard
| Setting | Where to find it | Suggested value |
|---|---|---|
| Orientation | Page Layout, Orientation | Landscape |
| Paper size | Page Layout, Size | A4 |
| Scale to fit | Page Layout, Scale to Fit | Width 1 page, Height 1 page |
| Margins | Page Layout, Margins | Narrow |
| Centre on page | Page Setup dialog, Margins tab | Horizontally ticked |
| Gridlines | View, Gridlines (and Page Layout, Sheet Options) | Off on screen, Print unticked |
Setting width and height to 1 page tells Excel to shrink the print area until it fits. Choose that rather than typing a percentage, because it adjusts if you later add a chart.
How do I see what will print?
Choose View, then Page Break Preview. The print area appears in white, and everything outside it goes grey. Blue lines show page breaks. If you see a second page, drag the blue line, or recheck Scale to Fit. Then open File, Print and look at the preview on the right, which shows exactly what comes out.
- Select the dashboard cells and set the print area.
- Choose Landscape and A4.
- Set Scale to Fit to 1 by 1.
- Turn off gridlines and set Narrow margins.
- Open Page Break Preview, then File, Print, and check the preview.
What if the text becomes too small?
Fitting a wide dashboard onto one A4 page shrinks everything. If the scale drops far below 70 per cent, the numbers become hard to read. Remove one visual, reduce the number of columns, make fonts a size larger, or split the page into two dashboards. A cramped page is worse than two clear ones.
Save it as a PDF
- Choose File, then Export, then Create PDF/XPS Document.
- Click Options and choose Active sheet(s), so the Data sheet with every transaction is not included.
- Pick Standard for sharing and Minimum size for emailing.
- Name it with the month, such as Spending-Apr-2026, and Publish.
Printing straight to PDF from File, Print also works, using Microsoft Print to PDF if no other option is shown. Open the file once before sending it, and check that nothing is clipped at the edges.
Test with a trial export before printing on paper. A quick PDF shows clipped charts and tiny fonts immediately, and it saves ink. Pale backgrounds print better than dark fills, so set card backgrounds to light grey if the sheet will often go to a printer.
Header, footer and what you are sharing
Insert a footer with the date through Insert, Header and Footer, so an old copy cannot be mistaken for a new one. Also think about who receives the file. A dashboard shows your total spending, merchants and savings. Send it to the family member who needs it, not to a large group chat, and delete copies you no longer need from downloads and chat backups.
If you would rather get a regular report without page setup at all, SpendixAI has a weekly summary and CSV download of its reports. The sheet route above stays useful when you want a layout of your own.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

