Yes. In Excel for Microsoft 365 on Windows, open File > Print, check the preview, choose a printer and settings, then select Print. Before printing, you can set which cells to include, adjust page orientation and scaling, and check where page breaks fall so the printed copy is readable.
What It Means to Print an Excel Sheet
Excel worksheets are grids that can extend far beyond the part of the workbook visible on screen. Printing turns some or all of that grid into one or more paper pages, or into a print-ready file such as a PDF. The worksheet itself is not changed when you print it, though settings such as a print area and page orientation can be saved with the workbook.
A sheet does not automatically print as a single page. Excel divides the selected content across pages according to the paper size, margins, printer, and scaling settings. A wide table may span several pages from left to right; a long table may continue onto additional pages below. The preview in the Print screen shows how those choices will affect the result.
Printing can also differ from what you see in the worksheet. Gridlines are not printed by default, and screen row and column headings are normally omitted. Hidden rows or columns are not included in the printed output. Cell colors, borders, fonts, and other formatting usually carry through, subject to the printer or PDF output settings.
Print a Worksheet, Workbook, or Selection
To print the active worksheet, use File > Print or press Ctrl+P on Windows. In the Print screen, confirm the printer and number of copies, then inspect the preview before printing. On a Mac, use Command+P; the Print screen and available printer options can look different, but the same general choices apply.
The setting beneath the printer options determines what Excel sends to print. Depending on the workbook, the choices include the active sheets, the entire workbook, or only the currently selected cells. For a selection, select the cells first, open the Print screen, and choose Print Selection. This is useful for printing a short summary from a large data sheet without changing the rest of the sheet.
- Print Active Sheets: Prints the active sheet or sheets. If the active sheet has a defined print area, Excel uses that area.
- Print Entire Workbook: Prints all worksheets in the workbook, including sheets that may not be immediately visible in the sheet tabs. Review the preview and page count before printing.
- Print Selection: Prints only the cells selected before opening the Print screen.
The exact wording or placement of print choices may vary with the printer driver and Excel update. If a setting is missing, check that a printer is selected and look at the available options in the Print screen.
Choose a Print Area for Specific Cells
A print area tells Excel which part of a worksheet to print when you print the active sheet. Select the cells you want, then choose Page Layout > Print Area > Set Print Area. The selected range becomes the print area, and Excel can split it across pages if it does not fit on one. A print area is helpful when a sheet contains notes, calculations, or supporting data that should stay out of the handout.
To remove the saved area, choose Page Layout > Print Area > Clear Print Area. You can also set more than one print area on a worksheet by selecting a nonadjacent range while setting an area, but separate areas may print on separate pages. For a one-time output that should not change the sheet’s saved print setup, select the cells and use Print Selection instead.
A common source of confusion is an unexpectedly small printout: a print area left over from an earlier task can exclude rows or columns the user expected to see. If the preview looks incomplete, clear the print area and check again, or deliberately set a new one.
Set Orientation, Paper Size, and Margins
Page layout choices help determine how much information fits on each page. On the Page Layout tab, use Orientation to choose Portrait or Landscape, Size to choose a paper size supported by the printer, and Margins to select a margin preset. Landscape orientation often works better for a table with many columns; Portrait can suit a narrow list or report.
Paper size should match the paper loaded in the printer or the intended PDF format. Choosing a larger size in Excel does not make a standard printer produce larger paper; the printer may request different paper, scale the output, or report a mismatch. Margin presets also affect how much room remains for the worksheet and for headers or footers.
For more detailed controls, open the Page Setup dialog from the Page Layout tab. Its options include page orientation, scaling, paper size, margins, headers and footers, and sheet-specific print settings. The dialog’s appearance can vary slightly across Excel releases and operating systems.
Fit Columns and Rows Without Shrinking Too Much
When a table is only slightly wider than a page, scaling it to fit the page width can prevent a narrow last column from being pushed onto a separate sheet of paper. In Excel for Windows, go to Page Layout and use the Scale to Fit controls. Set Width to 1 page and leave Height as Automatic if you want the columns to fit across one page while allowing the rows to continue over multiple pages.
Setting both width and height to one page forces the entire print area onto a single page. That can be convenient for a small summary, but it may reduce text to a size that is difficult to read when the sheet contains many rows or columns. Check the preview at a realistic viewing size rather than assuming that a one-page result is automatically a good one.
For a very wide worksheet, consider printing in landscape, reducing unnecessary columns, or using a larger supported paper size before applying aggressive scaling. If readability matters more than keeping everything on one page, allow the table to span multiple pages and repeat its column labels on each page.
Check Page Breaks and Repeat Headings
Excel inserts automatic page breaks based on the selected paper, margins, and scaling. To inspect them on Windows, choose View > Page Break Preview. Blue lines show where pages divide; you can drag a break to adjust the division. Return to View > Normal when finished. Manual changes to page breaks can be useful, but they do not replace checking the Print preview because other layout settings may change the final pagination.
If a long table continues over multiple printed pages, its column names may appear only on the first page unless you tell Excel to repeat them. Choose Page Layout > Print Titles. In the Page Setup dialog, use Rows to repeat at top to select the row or rows containing the headings. You can use Columns to repeat at left when the table spans multiple pages horizontally and needs identifying labels on each page. Confirm the result in Print preview.
Headers and footers are different from repeated worksheet headings. They can add items such as a page number, date, or workbook information to the page margins. Set them through the Page Setup dialog or the header and footer controls on the Page Layout tab. Use them when a multi-page printout needs page identification, but keep them short enough not to crowd the worksheet.
Gridlines, Headings, and Print Preview
Worksheet gridlines are a screen aid and are not printed by default. To include them, go to Page Layout, find Sheet Options, and select the Print checkbox under Gridlines. The same area has a Print option for headings, which adds row numbers and column letters. These can help with reference copies, but they are not usually appropriate for a polished report.
Cell borders are separate from gridlines. If a table needs clear divisions on paper, applying borders to the cells is often more reliable than turning on worksheet gridlines, particularly when the output should show only the table and not the surrounding blank cells. Print preview is the quickest way to confirm which lines and headings will appear.
The preview in File > Print lets you move between pages and check the overall layout before committing to paper. Look for cut-off columns, nearly blank pages, tiny text, missing headings, and totals separated from the figures they summarize. If the preview is not right, return to the worksheet or Page Layout settings and adjust the print area, orientation, scaling, margins, or page breaks.
Common Printing Problems and Fixes
- Only part of the table prints: Check whether a print area is set, whether Print Selection was chosen, and whether rows or columns are hidden.
- The last column is on another page: Try Landscape orientation or set the Scale to Fit width to one page. Check whether the smaller text remains readable.
- Text is too small: Avoid forcing both width and height to one page. Let the sheet use more pages, remove unneeded columns, or adjust margins.
- Headings appear only on page one: Set rows or columns to repeat through Page Layout > Print Titles.
- Gridlines are missing: Turn on the Gridlines Print option under Page Layout > Sheet Options, or apply cell borders.
- Blank pages appear: Inspect the print area and page breaks, and look for formatted or populated cells far beyond the main table. Clear an unwanted print area or adjust the range being printed.
A printer issue can also look like an Excel layout problem. If the preview is correct but the paper output differs, check the printer’s paper size, orientation, tray, and scaling options. Printer properties may override or conflict with the settings chosen in Excel. For a useful diagnostic, save or print the same preview as a PDF and compare the PDF layout with the physical output.
Print to PDF and Excel for the Web
You do not need paper to create a printable copy. In Windows, choose File > Print and select a PDF printer, such as Microsoft Print to PDF if it is available, then print and choose where to save the file. Excel also offers File > Save As or export options for PDF, depending on the current interface. A PDF is useful for sharing a fixed page layout, but check the pages before sending it because scaling and page breaks still matter.
Excel for the web can print a workbook through its File and Print options, but printing may pass through the browser’s print interface and offers a different set of controls from the Windows desktop application. For detailed page setup, repeated print titles, or fine control over breaks, open the workbook in the desktop app when those options are needed. In Excel for Mac, the basic process is similar, while the print dialog and some ribbon controls may be arranged differently; use Command+P to open printing.
Frequently Asked Questions
Can I print just one page of an Excel sheet?
Yes. In the Print screen, use the page range controls to specify the page or pages to print. Check the preview first because the page number refers to Excel’s current pagination, which can change when you alter scaling, orientation, or margins.
How do I print an Excel sheet on one page?
On the Page Layout tab, set the Scale to Fit width and height to one page, or use the corresponding fit-to-page option in Page Setup. Review the preview carefully: a large worksheet may be scaled down until its text is hard to read.
Can I print an Excel spreadsheet without gridlines?
Yes. Gridlines are usually omitted by default. If they appear, go to Page Layout > Sheet Options and clear the Gridlines Print checkbox. Cell borders are separate and may still print.
Why does Excel print blank pages?
Common causes include a print area that extends too far, page breaks in an unexpected place, or content or formatting far outside the main table. Check the Print preview, clear or reset the print area, and inspect the sheet in Page Break Preview.
Can I print an Excel sheet to PDF?
Yes. Select a PDF printer in the Windows Print screen, or use Excel’s PDF save or export options. The PDF preserves a page-based layout, so check the preview and page count before sharing it.
Related
- Break-Even Analysis Calculator Excel Template
- Break External Links in Excel: Steps and Side Effects
- Break External Links in Excel: Safe Ways to Remove Them
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Data Cleaning Shortcuts in Excel: A Practical GuideFor quick data cleaning in Excel for Microsoft 365 on Windows, turn the range into a table with…
- Customer Contact List Template for ExcelA customer contact list template for Excel is a structured worksheet for recording and finding customer names, contact…
- Excel PivotChart Without a PivotTable: What Actually WorksExcel cannot create a true PivotChart without an associated PivotTable: when you insert a PivotChart, Excel creates or…
- Excel Shuffle List of Names: 10 Easy MethodsTo shuffle names in Microsoft Excel for Microsoft 365, add a random-number helper with =RAND() and sort the…
- Google Sheets Jira Sync: Methods, Setup, and LimitsGoogle Sheets does not include a built-in, always-live Jira sync, but you can connect the two with a…
- How to Set Up Out of Office Automatic Replies in OutlookTo set up an out-of-office reply in Outlook, open Automatic Replies, turn them on, choose when they should…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.