The short answer: select the cells you want, go to Page Layout, click Print Area, and choose Set Print Area. Then open File and Print, and under Scaling pick a fit option or set custom scaling to 1 page wide and leave the tall box empty. That combination, a defined print area plus width-only scaling, fixes almost every Excel printing problem in one pass.
Last updated August 2026.
Printing from Excel goes wrong in a way that printing from Word never does. Word has a page. A worksheet does not: it is an effectively infinite grid, and Excel has to guess where to slice it. Left to guess, it slices badly, and you get eleven pages where three columns wandered onto page 7 on their own.
Everything below is the fix for that, in the order you should apply it. The steps are for Excel on Windows in Microsoft 365, and the ribbon paths are close enough on Excel for Mac that you will find each command in the same place.
How do I print an Excel spreadsheet?
Press Ctrl+P, or go to File and then Print. That opens the print screen with a live preview on the right, which is the part most people skip and then regret. Check the page count under the preview before you send anything to the printer. If it says 1 of 14 and you expected 2, stop and set a print area rather than printing and squinting at the result.
The print screen is also where the settings that matter live: which sheets to print, orientation, paper size, margins and scaling. Changes you make there apply to the sheet, not just to this one print job, so they stick when you save.
How do I set the print area in Excel?
Select the range you want to print, then on the Page Layout tab, in the Page Setup group, click Print Area and then Set Print Area. From that point on, Excel prints only that range, and it ignores everything else on the sheet, including notes, scratch calculations and the stray value someone typed into cell AB400 three months ago.
A few behaviors from Microsoft's own documentation are worth knowing before you start, because they surprise people:
- A worksheet can have more than one print area, and each print area prints as a separate page. Hold Ctrl while selecting to pick several ranges at once.
- Only adjacent cells can be added to an existing print area. If you use Add to Print Area on a range that is not touching the current one, Excel creates a new print area instead of extending it, which is how you end up with an unexpected extra page.
- The print area is saved with the workbook, so a file someone else set up may already have one defined. That is the single most common reason a colleague's spreadsheet prints only part of itself on your machine.
How do I print an Excel sheet on one page?
Go to File and Print, and under Scaling choose Fit Sheet on One Page. That works, and for a small sheet it is the right answer. For anything with more than about 40 rows it is a trap: Excel shrinks both dimensions until the whole thing fits, and a 300 row report squeezed onto a single sheet of letter paper is technically one page and completely unreadable.
What you almost always want instead is to constrain the width and let the length run. Open the Page Setup dialog with the small arrow in the corner of the Page Setup group, choose Fit to, type 1 in the page(s) wide box, and clear the tall box entirely. Microsoft documents this explicitly: leaving the tall box blank fills the paper width and uses as many pages as necessary. Your columns stay on one page across, the rows continue onto page 2 and 3, and the text stays legible.
| Scaling option | What it does | Use it when |
|---|---|---|
| No Scaling | Prints at 100 percent and breaks pages wherever they fall | The sheet already fits, or you set explicit page breaks |
| Fit Sheet on One Page | Shrinks width and height until everything fits on one sheet | Small tables, roughly 40 rows or fewer |
| Fit All Columns on One Page | Shrinks width only, rows continue onto later pages | Long reports and ledgers. This is the everyday answer |
| Fit to: 1 wide by blank tall | The same as above, set manually in Page Setup | You want the exact setting saved with the workbook |
How do I print an Excel sheet with the lines?
On the Page Layout tab, in the Sheet Options group, tick the Print box underneath Gridlines. Gridlines are not printed by default, regardless of whether they are displayed on screen, which is why a sheet that looks like a table on your monitor prints as numbers floating in white space.
Two things to be aware of. Gridlines only print for cells that contain data or formatting, so an empty column inside your range will not show lines. And gridlines are a printing convenience, not a design: if the printout is going to a client or a lender, apply real borders to the range instead, because borders print reliably, survive a PDF export and let you make the header row heavier than the body.
How do I repeat the header row on every printed page?
On the Page Layout tab, click Print Titles in the Page Setup group. In the Rows to repeat at top box, enter the row reference, typically $1:$1 for a single header row. Every printed page then carries the column labels, so page 4 of a transaction list is still readable on its own.
This trips people up because it is not the same thing as Freeze Panes. Freezing affects only what you see while scrolling and has no effect on the printout at all. Print Titles affects only the printout and does nothing on screen. If you want both, and on a long report you usually do, you have to set both. The freezing side is covered in how to freeze rows in Excel.
One more catch: the Print Titles button is greyed out if you are editing a cell or if multiple sheets are selected. Press Escape, click a single sheet tab, and it becomes available again.
Why does my Excel spreadsheet print on so many pages?
Nearly always because the used range is much bigger than the data you can see. Excel tracks the furthest cell that has ever been touched, and formatting counts as touched. Press Ctrl+End: if the cursor lands somewhere far below or to the right of your actual data, that is the problem, and it is why the printout carries a dozen blank pages.
Fix it by deleting the empty rows and columns between your data and that cell (select whole rows, right click, Delete, not just press Delete on the contents), then save and reopen the file so Excel resets the used range. Setting a print area is the belt and braces version and it works even if the used range is still oversized. If the sheet came out of a conversion and is full of stray blank rows, removing the blank rows first will shrink the print job on its own.
How do I print only selected cells in Excel?
For a one time job, do not bother with a print area. Select the cells, press Ctrl+P, and under Settings change Print Active Sheets to Print Selection. That prints just what is highlighted and changes nothing about the workbook, so the next person to open it is not confused by a print area they did not set.
Use Set Print Area instead when the same range gets printed repeatedly, such as a monthly summary block at the top of a working sheet. The rule of thumb: Print Selection for once, print area for every month.
How do I clear the print area in Excel?
Click any cell on the sheet, then Page Layout, Print Area, Clear Print Area. Note the important detail: if the worksheet contains multiple print areas, clearing removes all of them, not just the one your cursor is sitting in. There is no way to clear a single area out of several, so if you want to keep some, clear them all and set the ones you want again.
Why is my Excel print area not working?
Because something else is overriding it, and it is usually one of five things. This table covers what actually goes wrong.
| Symptom | Likely cause | Fix |
|---|---|---|
| Extra pages print with content you did not select | Multiple print areas exist, each printing separately | Clear Print Area, reselect the single range, set it again |
| Print area ignored completely | Ignore print areas is ticked in the print settings | File, Print, Settings, untick Ignore Print Areas |
| New rows added below do not print | The print area is a fixed range and does not grow | Reset it after adding rows, or format the range as a table and set the area to the table |
| Columns split across pages mid table | Scaling is set to No Scaling and the sheet is wider than the paper | Fit All Columns on One Page, or switch to landscape |
| Only part of the sheet prints and you set nothing | A print area was saved in the file by whoever built it | Page Layout, Print Area, Clear Print Area |
How do I set the print area for multiple sheets at once?
You cannot set one print area across several sheets in a single action, because a print area belongs to a worksheet. Grouping sheets by Ctrl+clicking their tabs does let you apply page setup settings such as orientation, margins, scaling and Print Titles to all of them at once, which is the part that is genuinely tedious to repeat. Set the print area sheet by sheet, then group them for the rest.
Remember to ungroup afterwards by clicking a single tab. Leaving sheets grouped is how people accidentally type the same value into fourteen worksheets.
Getting the sheet worth printing in the first place
Most of the printing problems above are really layout problems that arrived with the data. A statement or report that started life as a PDF and got converted badly comes in with merged cells, stray rows and amounts stored as text, and no amount of scaling makes that print well. If that is your starting point, convert it properly first with a PDF to Excel converter that keeps the columns intact, then clean up the sheet before you touch Page Layout. A clean rectangular range with one header row prints correctly with almost no configuration.
It is also worth asking whether printing is the right destination at all. A printed spreadsheet is a poor way to present numbers to a room, and if the sheet is headed for a meeting rather than a filing cabinet, turning the report into slides communicates the same figures far better than a stack of landscape pages. For circulation and archiving, exporting to PDF from the same Page Layout settings gives everyone an identical document without depending on their printer drivers.
A five step routine that works every time
- Press Ctrl+End and check the used range is not miles past your data. Delete the empty rows and columns if it is.
- Select your range, then Page Layout, Print Area, Set Print Area.
- Page Layout, Print Titles, and put $1:$1 in Rows to repeat at top.
- Page Layout, Sheet Options, tick Print under Gridlines if the sheet has no borders.
- Ctrl+P, set Scaling to Fit All Columns on One Page, check the page count in the preview, then print.
Save the workbook afterwards. All five settings are stored in the file, so next month the same report prints correctly on the first attempt without repeating any of this. If you convert documents into Excel regularly, doing this once on the template you paste into is the version of the trick that actually saves time, whether the source is a bank statement or a financial report.