Yes, you can print an Excel spreadsheet from Microsoft Excel for Microsoft 365 on Windows: open the workbook, choose File > Print, check the preview, and select Print. Before sending it to a printer, set the print area and page layout so that columns, headings, and numbers are readable on paper.
How printing an Excel spreadsheet works
Excel prints worksheet content according to its print settings, not necessarily according to what is visible in the current window. By default, it prints the active sheet’s used range, divided across as many printed pages as needed. The preview in the Print screen shows how Excel plans to divide the sheet, making it the best place to catch cut-off columns, unwanted blank pages, or text that has been reduced too much.
To print a whole worksheet, open the sheet and press Ctrl+P on Windows, or choose File > Print. Review the preview and the settings below it, select the printer and number of copies, and click Print. On a Mac, use Command+P or choose File > Print; the print dialog and some layout controls differ, but the same basic checks apply.
The Print screen also lets you choose what to print. Under Settings, the default is usually Print Active Sheets. Depending on your goal, you can choose Print Entire Workbook to include every worksheet, or Print Selection to print only the cells you selected before opening the screen. Confirm the choice in the preview: printing the entire workbook can produce many pages, and printing a selection can omit context that readers need.
Prepare the worksheet before printing
A worksheet designed for on-screen work may not make a good paper report. Before printing, check whether the data has a clear title, useful column labels, consistent number formats, and enough space to read. A date or currency value that looks clear on screen can be confusing without a heading or units. Hide or remove temporary calculations and notes if they should not appear on the printed copy.
Look for content far to the right or far below the main table. A stray value or formatting applied to distant cells can make Excel treat a much larger area as part of the worksheet, resulting in extra pages. Use the Name Box to navigate to a known area, or press Ctrl+End on Windows to jump to the last cell Excel regards as used. On Mac, use Control+End or Fn+Control+Right Arrow depending on the keyboard. If the used area extends beyond the real data, clear unnecessary cells or formatting, save the workbook, and check the preview again.
For a straightforward table, consider adjusting column widths before changing print scaling. Select a column and drag its right boundary, or double-click the boundary to fit the visible contents. You can also use Home > Format > AutoFit Column Width. AutoFit may make a column very wide if it contains a long note, so inspect the result rather than applying it blindly to every column.
Choose a print area or print selected cells
A print area tells Excel which part of a worksheet to print when you choose Print Active Sheets. It is useful when a sheet contains supporting calculations beside a report, or when only one table should appear on paper. Select the cells to include, then choose Page Layout > Print Area > Set Print Area. The area remains saved with the worksheet until you change or clear it.
To remove a saved area, choose Page Layout > Print Area > Clear Print Area. If a sheet has more than one print area, Excel prints each area separately; this can produce unexpected page breaks. To print a one-off range without changing the saved print area, select the cells, open File > Print, and choose Print Selection under Settings. Check the preview to ensure the selected cells fit sensibly across the pages.
For example, if a worksheet has a monthly sales table in columns A through F and a separate calculation block in columns H through J, set the print area to the sales table so the calculations do not appear in the report. If you later add another month or a new column, revisit the print area: Excel may not automatically include new cells outside its original boundary.
Fit columns and rows onto pages
A frequent printing problem is a table that spills onto an extra page horizontally. In File > Print, use the scaling menu under Settings. Fit All Columns on One Page is often a practical choice for a wide table: it keeps the columns together but may use multiple pages vertically. Fit Sheet on One Page compresses both width and height, which can make a large worksheet too small to read. Fit All Rows on One Page is useful when rows are the main concern, but it does not necessarily keep all columns together.
Scaling shrinks or enlarges the printed content to fit the chosen page dimensions; it does not remove data. If the preview shows tiny text, avoid forcing a large sheet onto a single page. Instead, use landscape orientation, reduce unnecessary margins, shorten or wrap long headings, or print the data across several pages. You can also set a specific scale from the Page Layout tab’s Scale to Fit controls, adjusting Width and Height. Setting Width to 1 page and Height to Automatic can keep columns together without squeezing every row onto one sheet.
Choose orientation through Page Layout > Orientation > Portrait or Landscape. Landscape gives a wide table more horizontal room, while portrait often suits lists and reports with fewer columns. The paper size also matters: a layout prepared for Letter paper may break differently on A4. Select the intended size at Page Layout > Size and confirm that the printer has the same paper loaded.
Set margins, page breaks, and print titles
Margins affect how much of the page is available for the worksheet and whether content sits comfortably within the printable area of the printer. Choose Page Layout > Margins to select a preset, or choose Custom Margins to adjust them. Very narrow margins can help a table fit, but many printers cannot print all the way to the paper’s edge. If a preview clips content, try a wider margin or a different scaling setting rather than assuming the printer will reproduce edge-to-edge printing.
Excel inserts page breaks automatically, but you can review them in View > Page Break Preview. Drag a page-break line to change where one page ends and the next begins. You can also insert a break from Page Layout > Breaks > Insert Page Break after selecting a row or column. Use manual breaks sparingly: they can become awkward when the table changes size or the paper settings change.
For a multi-page table, repeating its header row makes later pages easier to understand. Choose Page Layout > Print Titles, then use the Rows to repeat at top field in the Page Setup dialog to specify the row or rows. For instance, if the column headings are in row 1, enter or select row 1. You can set columns to repeat on the left in the same dialog, which helps when a wide table spans multiple pages. These options are available in desktop Excel; Excel for the web has a more limited set of page-layout controls.
Use the preview to fix common problems
Always inspect more than the first page when a worksheet spans multiple pages. In the Print preview, use the page navigation controls to check the final page and any pages in the middle. Look for a column separated from its data, a heading stranded at the bottom of a page, unexpectedly blank sheets, or rows that have been cut off. A preview issue is usually easier to correct in Excel than after several copies have printed.
- A column is on a separate page: switch to landscape, reduce margins, or use Fit All Columns on One Page. If the result is too small, print across multiple pages and repeat key columns where appropriate.
- Text is tiny: stop fitting the entire sheet to one page. Use a wider paper size if available, adjust the print area, or allow the report to use more pages.
- Blank pages appear: inspect the print area and the last used cells, then clear unwanted content or formatting outside the report. Check page breaks and preview again.
- Gridlines are missing: on the Page Layout tab, find Sheet Options and turn on Print under Gridlines. Gridlines are not printed by default in many layouts. Cell borders, by contrast, print as formatting.
If row and column headings such as A, B, and 1, 2 should appear, use the Headings option under Page Layout > Sheet Options and check Print. These spreadsheet labels are different from your own table headers, and they are usually unnecessary for a polished report. Header and footer text, such as a date or page number, can be configured from Page Layout > Page Setup using the dialog launcher, then the Header/Footer tab.
Print to paper or save a PDF
You do not need a physical printer to create a shareable copy. On Windows, select Microsoft Print to PDF as the printer in the Print screen to create a PDF file. On a Mac, use the PDF menu in the macOS print dialog and choose Save as PDF. A PDF preserves the page layout for viewing and sharing, though recipients may not be able to edit the workbook’s formulas or data as they could in the original Excel file.
Printing directly to paper is useful for a meeting, a signed checklist, or a report that someone needs to mark up. A PDF is often more convenient when the recipient needs to review the layout without using Excel. If they need to sort, filter, or update the data, share the workbook instead, while considering whether it contains information they should not see.
Excel for the web can also print a workbook. Open the file in the browser and choose File > Print, then review the available print settings and preview. The exact options can differ from desktop Excel, so a complex report may be easier to prepare in the Windows or Mac desktop app. For any version, verify the final output before distributing it, especially if page layout, repeated titles, or print areas are important.
Costs and practical considerations
Excel does not charge a fee to print a worksheet, but printing may use paper, ink or toner, and printer capacity. Large spreadsheets can consume more pages than expected, particularly when a single wide table is split across several sheets. Check the page count in the preview, print only the necessary worksheets or range, and use duplex printing if your printer supports it and double-sided pages suit the document.
Consider readability as well as paper use. A crowded page that technically fits may be less useful than two clearly printed pages. For a report that will be shared broadly, remove irrelevant columns, use descriptive headings, and make sure color is not the only way information is distinguished; some printers render color poorly or in grayscale. Also check whether the workbook contains confidential data before printing, saving a PDF, or leaving pages at a shared printer.
Frequently Asked Questions
Can I print just one page of an Excel spreadsheet?
Yes. In File > Print, use the Pages fields under Settings to enter the page number or range to print. Check the preview first because page numbers depend on Excel’s current layout and page breaks.
How do I print an Excel sheet on one page?
Choose File > Print, open the scaling menu under Settings, and select Fit Sheet on One Page. If the sheet is large, the result may be difficult to read; fitting only all columns on one page is often a better compromise.
Can I print an Excel spreadsheet without gridlines?
Yes. Gridlines generally do not print unless enabled. To control the setting, open Page Layout, find Sheet Options, and clear Print under Gridlines. Cell borders you have applied can still print.
Why does Excel print blank pages?
Excel may include distant cells or formatting, a large print area, or manual page breaks. Check the preview, clear an unnecessary print area, inspect the worksheet’s last used cell, and review page breaks before printing again.
Can I print an Excel spreadsheet from my phone?
Excel mobile apps may offer printing options depending on the device, app, and available printer setup. If the print controls are unavailable or the layout needs detailed adjustment, open the workbook in desktop Excel or save a PDF from a computer.
Related
- Calendar Timeline Template Excel: Build Your Own
- Calendar Planner Template in Excel: Build and Use One
- Calendar Schedule Template in Excel: How to Build One
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Extract Data From a Picture in ExcelTo extract a table from a picture in Excel for Microsoft 365 on Windows, select Data > From…
- How to Add an Attachment to a Word Mail MergeTo add a different attachment to each Word mail-merge email, put each recipient’s file path in your data…
- Find Duplicates in Excel: Shortcut Keys and a Quick GuideTo find duplicate values in Excel for Microsoft 365 on Windows, select the cells to check, then press…
- How to Insert a Line in Word to Type On: Easy MethodsTo make a line you can type on in Word, insert a one-cell table, remove its borders, and…
- Average Shortcut in Excel: Fast Ways to Calculate MeanIn Excel for Microsoft 365 on Windows, click the blank cell where you want the result, press Alt,…
- How to Use a Different Slide Master in PowerPointYes. A PowerPoint presentation can contain more than one slide master, so you can give selected slides a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.