Spreadsheets

Print an Excel dashboard to a one-page PDF

Print an Excel dashboard to a single landscape page and save it as a PDF: set the print area, fit to one page, hide gridlines and check the preview.

Editorial illustration for Print an Excel dashboard to a one-page PDF

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

SettingWhere to find itSuggested value
OrientationPage Layout, OrientationLandscape
Paper sizePage Layout, SizeA4
Scale to fitPage Layout, Scale to FitWidth 1 page, Height 1 page
MarginsPage Layout, MarginsNarrow
Centre on pagePage Setup dialog, Margins tabHorizontally ticked
GridlinesView, 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.

  1. Select the dashboard cells and set the print area.
  2. Choose Landscape and A4.
  3. Set Scale to Fit to 1 by 1.
  4. Turn off gridlines and set Narrow margins.
  5. 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.

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.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports