To print in Microsoft Excel for Microsoft 365 on Windows, open the workbook, choose File > Print, review the preview, adjust settings such as orientation or scaling, select a printer, and click Print. The preview is important: it shows how worksheet cells will be divided across pages before you use paper.
Excel can print a selected range, the current worksheet, or an entire workbook. A few minutes spent setting the print area and page layout can prevent clipped columns, tiny text, and blank pages.
What You’ll Need
- An Excel workbook with the worksheet or data you want to print.
- A printer connected to your computer, switched on, and loaded with the paper size you intend to use. You can also save a print-ready copy as a PDF if you do not need paper.
- Microsoft Excel for Microsoft 365 on Windows. The basic process is similar on Mac, while Excel for the web may open your browser’s print dialog and has a slightly different interface.
Step-by-Step
-
Open the workbook and choose what to print. Select the worksheet tab you need. If you only want part of a sheet, drag across the cells to select the range. To print more than one worksheet, hold Ctrl and click each relevant sheet tab on Windows; on Mac, hold Command while selecting tabs. Be aware that grouped sheets stay selected together, so ungroup them afterward by clicking a single sheet tab.
-
Open Print Preview. Choose File > Print, or press Ctrl+P on Windows. On Mac, press Command+P. Excel displays a preview and print settings. Use the page arrows or page number controls in the preview to inspect every page, not just the first one. If the preview is blank or shows an unexpected sheet, cancel printing and check your selection and active worksheet.
-
Choose the right print scope. In the Settings area, select Print Active Sheets to print the current sheet or selected grouped sheets. Choose Print Entire Workbook to include all worksheets, or Print Selection if you selected a specific cell range before opening Print. The selection option is useful for a one-off printout; it does not permanently limit what the workbook can print later.
-
Set a print area when you will reuse the same range. Select the cells, then go to Page Layout > Print Area > Set Print Area. Excel will treat that range as the printable part of the sheet. To remove that limit later, choose Page Layout > Print Area > Clear Print Area. Check the preview afterward: an old print area can make Excel omit newly added data outside its borders.
-
Choose paper size, orientation, and margins. In File > Print, choose the paper size that matches the paper in your printer, such as Letter or A4. Use Portrait for a tall layout and Landscape for a wide table. Select a margin preset such as Normal, Narrow, or Wide, or use Custom Margins when you need more control. You can also set these options on the Page Layout tab. If you change paper size in Excel but the printer uses a different size, the result may be scaled or positioned unexpectedly.
-
Make wide or long data fit sensibly. In the Print settings, open the scaling menu, which commonly starts at No Scaling. Choose Fit All Columns on One Page if the main issue is that columns spill onto extra pages. Choose Fit Sheet on One Page only for a small sheet; forcing a large worksheet onto one page can make text too small to read. For finer control, use Page Layout > Scale to Fit and set Width or Height to a number of pages, leaving the other dimension as Automatic when appropriate. Return to Print Preview and check the font size visually.
-
Improve repeated pages and page breaks. If a table spans several pages, use Page Layout > Print Titles. In the Page Setup dialog, set Rows to repeat at top, such as the row containing column headings, then confirm. To see where pages split, choose View > Page Break Preview. Drag a page-break line to adjust a split, or use Page Layout > Breaks > Reset All Page Breaks to return to automatic breaks. Avoid splitting a row of headings from the data it labels.
-
Check the details and print. Look for missing columns, unwanted blank pages, cut-off text, and headers or footers in the preview. To print gridlines, go to Page Layout and, in Sheet Options, select the Print checkbox under Gridlines. Gridlines are off in printouts by default; they are different from cell borders, which you can apply from the Home tab. If useful, add a page number or date through Insert > Header & Footer. Select the printer and number of copies in File > Print, then click Print. For a PDF, choose a PDF printer available on your computer, such as Microsoft Print to PDF, and complete its save prompt.
Common Mistakes
Printing the wrong scope: Print Active Sheets does not mean the whole workbook. Confirm the selected option before sending a multi-sheet job. Also check that you have not accidentally grouped worksheet tabs.
Scaling everything onto one page: This can shrink a large table until its figures are unreadable. Fit columns to one page or use Landscape first, then inspect the preview and allow multiple pages vertically if needed.
Forgetting a saved print area: A print area from an earlier job can exclude rows or columns added later. Clear it or reset it to include the full intended range.
Assuming screen appearance equals print appearance: Worksheet gridlines usually do not print unless enabled, and colors may look different on paper. Check the preview and, for color-critical work, consider a test page.
Ignoring paper settings: A mismatch between Excel’s selected paper size and the printer’s loaded paper can change scaling or cause a print error. Match both settings before printing.
Tips
- Use Print Preview as a final checklist each time you change orientation, margins, scaling, or print area.
- For wide data, try Landscape and narrower margins before shrinking the font. Keep a readable type size and let the table continue onto additional pages where necessary.
- Repeat column headings on each page with Page Layout > Print Titles. This makes a multipage report easier to follow when pages are separated.
- Use borders when you need visible cell divisions. Turning on printed gridlines is quick, but borders let you control which lines appear and how strongly.
- Save layout changes in the workbook if you want to reuse them. Before a one-time print, remember that changing print settings may affect the workbook’s saved page setup.
- If you are not sure how the printer will handle the sheet, print one copy first. For a document that will be shared or printed elsewhere, export or print to PDF and inspect the saved pages.
Troubleshooting
Some columns are missing: Return to File > Print and check whether the preview has extra pages to the right. Switch to Landscape, reduce margins, or use Fit All Columns on One Page. If the resulting text becomes too small, let the sheet span several pages or adjust the layout rather than forcing a single-page fit.
The printout has blank pages: Check for stray formatting or content far beyond the table, and inspect View > Page Break Preview. Clear or reset the print area if it includes empty cells. In Print Preview, note which page is blank and locate its corresponding area on the worksheet.
The printout is too small or cut off: Review the scaling choice and paper size. No Scaling can leave columns off the page, while Fit Sheet on One Page can shrink the content excessively. Try landscape orientation or a fit-to-width setting, then inspect every preview page.
Gridlines or headings do not appear: Enable Page Layout > Sheet Options > Gridlines > Print if you want gridlines. For headings repeated on each page, set the top row in Page Layout > Print Titles; simply freezing panes changes on-screen scrolling, not printed pages.
Nothing prints or the printer is unavailable: Check that the correct printer is selected in File > Print, that it is online, and that its paper and queue are ready. Try printing another document to distinguish a printer issue from a workbook layout issue. If Excel for the web is open, its print command may hand the job to the browser; check the browser’s printer selection and print preview as well.
Frequently Asked Questions
How do I print only selected cells in Excel?
Select the cells, choose File > Print, and select Print Selection in Settings. Review the preview to confirm that only the intended range appears.
How do I print an Excel sheet on one page?
Choose File > Print and select Fit Sheet on One Page. Use this for a small sheet; for a broad table, Fit All Columns on One Page may preserve more readable text while allowing multiple pages down the sheet.
How do I print the column headings on every page?
Choose Page Layout > Print Titles. In the Page Setup dialog, enter or select the heading row under Rows to repeat at top, then check the preview of later pages.
How do I print gridlines in Excel?
On the Page Layout tab, find Sheet Options, then select Print under Gridlines. Cell borders are a separate formatting feature and may be a better choice when you need specific lines to show.
Can I print an Excel workbook without a printer?
Yes. In File > Print, choose a PDF printer such as Microsoft Print to PDF if it is available, then save the resulting file. On Mac, use the PDF option in the system print dialog. Excel for the web may use the browser’s print or PDF controls.
Is printing different in Excel for Mac or the web?
The main layout options are similar in Mac Excel, but the print dialog and some controls look different; use Command+P instead of Ctrl+P. Excel for the web can pass printing to the browser, so review the browser preview and its paper settings too.
Related
- How to Move Tabs in Excel With the Keyboard
- Move Text Down in an Excel Cell: Two Easy Ways to Do It
- How to Move in Excel Without a Mouse
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Date Shortcut: Insert Today’s Date with Ctrl+;In Excel for Microsoft 365 on Windows, press Ctrl+; (Ctrl plus the semicolon key) to insert today’s date…
- Remove Page Break Gridlines in Excel: Quick StepsTo remove page-break lines in Excel for Microsoft 365 on Windows, switch to View > Normal, then open…
- Undo in Excel: Keyboard Shortcut and How to Use ItTo undo your last action in Excel for Microsoft 365 on Windows, press Ctrl+Z. Press it again to…
- Excel: Calculate Percentage Difference Between NumbersIf A2 contains the first number and B2 the second, calculate the percentage difference with =ABS(A2-B2)/AVERAGE(ABS(A2),ABS(B2)), then format…
- Indent Down in an Excel Cell: Steps and FixesTo indent text in an Excel cell, select the cell and choose Home > Increase Indent. This moves…
- Excel Power Query: Turn a JSON List Into a TableIn Excel for Microsoft 365 on Windows, choose Data > Get Data > From File > From JSON,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.