How To Print An Excel Spreadsheet

Printing an Excel spreadsheet without cut-off columns or blank pages is easy once you know the right settings. This guide walks you through the best page setup, print area, and preview checks so your data fits neatly on paper every time.

Fast Answer

Key setting: Set Print Area, then use "Fit Sheet on One Page" in Page Setup before printing.
Quick check: Always review Print Preview before sending to the printer.

5–10 minutes Time needed

Easy Difficulty

Columns cut off Watch out for

Before You Start

A computer with Microsoft Excel 2016 or newer (the steps also work in Excel for Microsoft 365).
Your spreadsheet file saved and open.
A working printer with paper loaded, or access to "Print to PDF" if you want a digital copy first.
Roughly 5–10 minutes of uninterrupted time to check and adjust settings.

Check first: Confirm which columns and rows contain the data you truly need. Printing extra blank cells is the most common cause of wasted paper and confusing page breaks.

Step-by-Step Instructions

Open Your Spreadsheet and Review the Data Range

Open the Excel file you want to print. Scroll through your data and note where it starts and ends. Look for any blank rows or columns that sit between your data and the edge of the sheet. These blanks often create extra pages when you print.

If you spot empty rows or columns that are not part of your report, you can hide them or simply exclude them from the print area in a later step.

Tip: Use Ctrl + Home to jump to cell A1, then Ctrl + End to see the last cell Excel thinks contains data. If that endpoint is far beyond your actual data, you have stray blanks to fix.

Select the Specific Cells You Want to Print

Click and drag to highlight the exact cells you need. For example, if your data runs from A1 to G45, select that entire block. If your spreadsheet has several separate sections, hold down the Ctrl key while clicking and dragging to select multiple ranges.

Selecting the range first gives you full control over what appears on paper. It prevents Excel from printing entire blank columns that stretch to column XFD or blank rows that go down to row 1,048,576.

Tip: If your data is small, you can skip this step and just use the "Print Active Sheets" option later. But for larger workbooks, a precise selection saves paper and confusion.

Set the Print Area

With your cells still selected, go to the Page Layout tab on the ribbon. Look for the Print Area button in the Page Setup group. Click it and choose "Set Print Area". Excel now draws a thin dashed border around your selected range to show the print boundary.

This step tells Excel to ignore everything outside your selection. Even if the sheet contains hidden rows, notes, or formulas in distant cells, only your chosen range will print.

Tip: To remove a print area later, go back to Print Area and select "Clear Print Area". This is useful if you share the workbook with someone who needs to print the whole sheet.

Open Page Setup and Check the Page Tab

Still on the Page Layout tab, click the small arrow in the bottom-right corner of the Page Setup group. This opens the Page Setup dialog box with several tabs. Start with the Page tab.

Choose "Landscape" orientation if your spreadsheet is wider than it is tall. Choose "Portrait" if your data is taller than it is wide. Most financial reports and data tables work better in Landscape because columns have more room.

Tip: If you are unsure which orientation to use, select Landscape first. It reduces the chance of columns spilling onto a second page.

Adjust Scaling to Fit Your Data on One Page

In the same Page Setup dialog box, look for the Scaling section. Choose "Fit to" and set it to "1 page wide by 1 page tall". This forces Excel to shrink your data so it fits on a single sheet of paper.

If you prefer to keep text at a readable size, you can instead set "Fit to" only "1 page wide" and leave the tall setting blank. Excel will then split the data across multiple pages vertically but never cut off columns horizontally.

Tip: For a quick check, click "Print Preview" at the bottom of the dialog box. If the text looks too small to read, try the "1 page wide" option instead of forcing everything onto one page.

Set Margins and Center the Content on the Page

Click the Margins tab inside the Page Setup dialog box. Set the left and right margins to around 0.5 inches (1.27 cm) to give your data more horizontal space. You can also check the boxes for "Horizontally" and "Vertically" under the Center on page section.

Centering your printout makes the data look balanced on the paper instead of jammed into the top-left corner. This is especially useful for smaller tables that would otherwise look lost on the page.

Tip: Need to save paper? Reduce the top and bottom margins to 0.3 inches (0.76 cm) as long as your printer supports that small a margin.

Add or Remove Headers and Footers

Click the Header/Footer tab in the Page Setup dialog box. Excel gives you preset header and footer options like page numbers, file names, or dates. Choose "Page 1 of ?" from the Footer dropdown so your multi-page printouts stay organised.

If you want custom text, click "Custom Header" or "Custom Footer". Type your report title in the left section, the date in the centre section, and page numbers in the right section. This makes your printout look professional and easy to file.

Tip: For financial or legal documents, always include a page number and the file name in the footer. If pages get separated, you can quickly identify them.

Preview the Printout and Check Page Breaks

Click "Print Preview" to see exactly how your spreadsheet will look on paper. Scroll through each page to check for cut-off columns, awkward page breaks, or blank pages. Look at the bottom of the preview window to see how many pages Excel plans to print.

If a column is split across two pages, return to Page Setup and reduce the scaling or adjust the margins. If a row of data is split awkwardly, click "Page Break Preview" on the View tab and drag the blue dashed line to a better position.

Warning: Never skip Print Preview. What looks fine on screen can look completely different on paper, especially with wide columns or hidden rows.

Print Your Spreadsheet

Click the File tab and choose Print, or press Ctrl + P on your keyboard. In the Print panel, check that the correct printer is selected. Under Settings, confirm it says "Print Active Sheets" so Excel only prints the sheet you prepared.

Set the number of copies you need and choose whether to print single-sided or double-sided. Then click the big Print button to send your job to the printer.

Tip: If you want a digital copy for email or filing, choose "Microsoft Print to PDF" as the printer instead. This saves the spreadsheet as a PDF file without wasting paper.

Common problem: If your printed output shows blank pages at the end, your print area or scaling still includes empty cells. Clear the print area and repeat the selection process.

Quick Reference

Situation	Use this	Why
Wide spreadsheet with many columns	Landscape orientation + Fit to 1 page wide	Prevents columns from spilling onto extra pages
Large dataset that needs readable text	Fit to 1 page wide only (allow multiple pages tall)	Keeps font size larger while stopping horizontal cuts
Only part of the sheet contains relevant data	Set Print Area before printing	Excludes blank rows and unrelated sections
Multi-page report for filing	Add footer with page numbers and file name	Keeps pages organised and identifiable

Remember: The most common printing mistake is forgetting to set the print area. Always select your data range first, then set the print area, and you will avoid most issues.

Common Problems When You Print an Excel Spreadsheet

Columns are cut off: This happens when your data is wider than the paper. Go to Page Setup, choose Landscape, and set "Fit to 1 page wide". If text becomes too small, reduce margins to 0.5 inches instead of forcing single-page fit.

Blank pages print at the end: Excel is detecting empty cells beyond your data. Select your actual data range, set the print area, and check Print Preview again. You may also need to clear the print area first and then reset it.

Text is too small to read: When you force everything onto one page, Excel shrinks the font. Instead, set "Fit to 1 page wide" and allow the sheet to print across multiple pages vertically. Alternatively, increase the paper size in your printer settings.

Gridlines do not appear: By default, Excel does not print gridlines. If you want them, go to Page Layout, check the Print box under Gridlines in the Sheet Options group. This only affects the current sheet.

Header row repeats only on page 1: For multi-page printouts, set repeat rows. Go to Page Layout, click Print Titles, and in the "Rows to repeat at top" box, select your header row. Excel will print that row at the top of every page.

Advanced Tips for Printing an Excel Spreadsheet

Use Page Break Preview to control where pages split: Go to the View tab and click Page Break Preview. Blue dashed lines show where Excel plans to break pages. Drag these lines to keep related rows together on the same page.

Print titles for repeated headers: If your report spans multiple pages, use Page Layout, Print Titles, and select the row containing your column headings. This keeps the headings visible at the top of every printed page.

Set a custom print area for each sheet: You can set different print areas for different sheets in the same workbook. Select the sheet tab, set the print area, and repeat for the next sheet. Excel remembers each sheet's settings separately.

Save as PDF for easy sharing: Instead of printing directly, choose Microsoft Print to PDF in the printer dropdown. This creates a high-quality digital copy you can share by email without worrying about paper jams or printer settings.

Hide columns you rarely print: If your sheet has helper columns used for calculations, select those columns, right-click, and choose Hide. Print your report, then unhide them when you are done. This cleans up your printout without deleting data.

How To Print An Excel Spreadsheet FAQ

Why does my Excel spreadsheet print on multiple pages when it fits on one screen? The screen shows more content than fits on paper because of resolution differences. Use Page Setup and set "Fit to 1 page wide" to shrink the content to the paper size.

How do I print only certain rows or columns? Select the range you want, go to Page Layout, click Print Area, and choose "Set Print Area". Then press Ctrl + P and print normally. Excel will only print the selected range.

Can I print an Excel spreadsheet without gridlines? Yes. Go to Page Layout, look for Sheet Options, and uncheck the Print box under Gridlines. Your spreadsheet will print without the grid lines, giving a cleaner look.

How do I make my Excel spreadsheet fit on one page? Press Ctrl + P, go to Settings, and open the scaling dropdown. Choose "Fit Sheet on One Page". Excel scales down the content so it fits on a single sheet of paper.

Why is my Excel printout missing the last column? Your columns are too wide for the paper. Switch to Landscape orientation and set "Fit to 1 page wide" in Page Setup. Alternatively, reduce the column widths or margins.

How do I print row and column headings on every page? Go to Page Layout, click Print Titles, and in the "Rows to repeat at top" field, select the row with your headers. Excel will print that row on every page of your report.

Can I print only the active sheet in a workbook with multiple tabs? Yes. Ensure the sheet you want is selected, then press Ctrl + P and check that "Print Active Sheets" is selected in Settings. This prints only the sheet you are viewing.

What is the best way to print a very wide spreadsheet? Use Landscape orientation and set "Fit to 1 page wide". If the text becomes too small to read, split the data into two print areas and print them separately, or reduce the number of columns by hiding non-essential ones.

Final Checklist for Printing an Excel Spreadsheet

Selected the exact cells or range you need before setting the print area.
Set the print area via Page Layout, Print Area, Set Print Area.
Checked that print titles are set if your report spans multiple pages.
Chose the correct orientation (Landscape for wide data, Portrait for tall data).
Set scaling to "Fit to 1 page wide" or "Fit Sheet on One Page".
Adjusted margins and centred content on the page.
Added footers with page numbers for multi-page documents.
Previewed the printout and checked every page for cut-offs or blank pages.
Selected the correct printer (or Microsoft Print to PDF) and confirmed the number of copies.
Skipped the gridlines if you want a cleaner, more professional look.

FAQ

Common Issues

If the result is not working as expected, return to the previous step, check the material or setting involved, and make one adjustment at a time for how to print an excel spreadsheet.

What should I check before using this advice?

Check the current details that apply to how to print an excel spreadsheet, including availability, local rules, timing, compatibility, and any personal constraints.

Who is this guidance best for?

It is written for readers who want a practical starting point and are prepared to compare the advice with their own situation before acting.

What is the simplest next step?

Start with the first low-risk action, check the result, and make one adjustment at a time rather than changing several things at once.