To fit a wide budget sheet on A4, set the print area, switch the page to landscape, and on the Page Layout tab set Width to 1 page and Height to Automatic. Excel then shrinks the columns to the paper width and lets the rows run onto as many pages as they need. Always look at the preview afterwards, because shrinking too far makes the printout unreadable.
Step 1: set the print area so only the budget prints
Select the block you want on paper, say A1 to N40 holding categories and twelve month columns. On the Page Layout tab choose Print Area, then Set Print Area. Anything outside that block, such as scratch calculations parked to the right, stays off the page. If you add rows below later, they will not print until you set the area again, which is the usual reason a last row seems to go missing.
Which settings make a wide sheet fit on one page width?
- Page Layout, Size: pick A4. Some files carry another paper size from wherever they were created, so check it rather than assume.
- Page Layout, Orientation: Landscape. A4 is 29.7 cm along the long side and 21 cm along the short one, so landscape gives roughly 40 percent more width for twelve month columns.
- Page Layout, Margins: choose Narrow, or Custom Margins and tick Horizontally under Center on Page.
- File, Print: under the scaling option choose Fit All Columns on One Page. The same thing lives on Page Layout in the Scale to Fit group as Width 1 page, Height Automatic.
- Read the page count under the preview. If it still says more pages than you expect, a stray cell far to the right or below is probably inside the print area.
Avoid Fit Sheet on One Page for a long list of rows. It squeezes the rows as well and a year of daily entries becomes a speck.
How small is too small to read?
Scaling multiplies your font size. Say the columns of your sheet add up to 38 cm at full size, and you use 1 cm margins, so 27.7 cm is usable on landscape A4. 27.7 divided by 38 is about 0.73, so Excel prints at roughly 73 percent. An 11 point font then prints at about 8 points.
| Scenario (hypothetical sheet) | Usable width | Scale | 11 pt prints as |
|---|---|---|---|
| 38 cm wide, landscape, 1 cm margins | 27.7 cm | about 73% | about 8 pt |
| Same sheet in portrait | 19 cm | 50% | 5.5 pt |
| Same sheet after hiding two 3 cm helper columns (32 cm), landscape | 27.7 cm | about 87% | about 9.5 pt |
As a rule of thumb, text below roughly 8 points is tiring to read on paper. If you land there, hide or narrow columns before you accept a smaller scale. The Page Setup dialog shows the percentage Excel chose next to Adjust to.
What if the page still breaks in the wrong place?
Open the View tab and choose Page Break Preview. Blue dashed lines are automatic breaks and solid blue lines are ones you set. Drag a line to move it. To force a break, select the row below where the new page should begin, then use Page Layout, Breaks, Insert Page Break. Breaks, Reset All Page Breaks undoes the lot.
One catch: Excel ignores manual page breaks while a Fit To setting is switched on. If you want your own breaks, use the Adjust to option with a percentage you choose, for example 75 percent, instead of Fit To.
How do I repeat the category names on every page?
Go to Page Layout, Print Titles. In Columns to repeat at left enter $A:$A, and in Rows to repeat at top enter $1:$1 if your month headings sit in row 1. Now page two and three of a sheet that spills over still show which row is which category.
A short check before you print
- Print area covers the budget block and nothing else.
- Paper is A4, orientation is landscape.
- Scaling is Fit All Columns on One Page, or a fixed percentage if you set manual breaks.
- Effective text size is not much below 8 points; helper columns are hidden if it is.
- Category names repeat on every page through Print Titles.
- Totals row is visible on the last page and not cut off.
If the sheet is wide mainly because you paste in a year of bank statement rows, SpendixAI can import the statement files and its reports can be downloaded as CSV, so the sheet you print only has to hold the summary.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


