The basic steps to print an Excel spreadsheet

Open your spreadsheet in Excel, then press Ctrl+P on Windows or Command+P on Mac. This opens the print preview window. Choose your printer from the dropdown menu at the top, then click the blue Print button. Excel will send the document to your printer using the settings you see on screen.

Before you print, the preview window shows you exactly what will come out — this matters because Excel often prints differently than it looks on your monitor. Wide spreadsheets may split across multiple pages, or rows and columns may cut off mid-cell. Catching these problems in preview saves paper and frustration.

Key Takeaways

  • Use Ctrl+P (Windows) or Command+P (Mac) to open print preview, where you can see exactly what will print before sending it to your printer.
  • Adjust page orientation to Landscape if your spreadsheet is wider than it is tall, which often fits more columns on a single page.
  • Set the print area to specific cells if you only want to print part of your spreadsheet, rather than printing every sheet or every row.
  • Use the scaling options to shrink your spreadsheet to fit on one page, or enlarge it for readability, depending on your needs.
  • Check the margins and header/footer settings if your data is cutting off at the edges or if you want to add page numbers or a title.

Choosing landscape or portrait orientation

By default, Excel prints in portrait mode (taller than wide). If your spreadsheet has many columns, switch to landscape (wider than tall) so more columns fit on each page without wrapping to a second sheet. In the print preview window, look for Orientation near the top right. Click the dropdown and select Landscape.

Portrait works better for spreadsheets that are narrow and tall — like a list of names and phone numbers. Landscape works better for data with many columns across — like a budget with months as columns and expense categories as rows. You can see the difference in real time in the preview, so switch back and forth until the layout looks right.

Printing only part of your spreadsheet

If you have a large spreadsheet but only need to print certain rows or columns, set a print area first. Highlight the cells you want to print by clicking and dragging to select them. Then go to the Page Layout tab (in Excel on Windows) or Sheet tab (in Excel on Mac), find Print Area, and click Set Print Area. Now when you print, only those cells will come out.

This prevents printing 50 rows when you only need 10, and it keeps you from wasting paper on columns that aren't relevant to the person receiving the printout. If you change your mind, go back to the same menu and click Clear Print Area to return to printing the whole sheet.

Scaling your spreadsheet to fit on fewer pages

Excel often spreads a spreadsheet across many pages because it tries to keep your original font size and cell width. In the print preview window, look for Scaling options. You can choose Fit to one page (which shrinks everything to fit on a single sheet), or you can manually set a percentage like 80% or 90% to make it smaller without going all the way down to one page.

Be careful with very small percentages — if you shrink to 50%, the text may become hard to read. A better approach is often to remove unnecessary columns before printing, or to print in landscape mode, rather than scaling down so far that the numbers become tiny.

Adjusting margins and headers

If your data is cutting off at the edges of the page, your margins are too large. In the print preview, look for Margins and select Narrow or Custom to reduce the blank space around the edges. Custom margins let you set each side individually — useful if you need more room on the left for binding or on the top for a company logo.

Headers and footers appear at the top and bottom of every printed page. Click Page Setup or Sheet Options in the print preview to add a title, date, page number, or your name. This is helpful if the printout will be shared or filed — it makes clear what the document is and when it was printed.

Printing multiple sheets at once

If your Excel file has multiple sheets (tabs at the bottom), the print dialog will show you which sheet is selected. To print only the current sheet, make sure Print Active Sheets is selected. To print all sheets in the file, select Print Entire Workbook. Excel will print each sheet on separate pages, in the order the tabs appear at the bottom.

If you want to print some sheets but not others, hold Ctrl (Windows) or Command (Mac) and click the sheet tabs you want to include. Then choose Print Selected Sheets. This is faster than printing the whole workbook and then throwing away the pages you don't need.

Saving your print settings for next time

Once you have the page layout, margins, and scaling the way you want them, Excel remembers these settings the next time you open that file. If you print the same spreadsheet regularly, you only have to adjust these settings once. If you want to change them back later, just go through the print preview again and adjust.

Some people create a separate sheet in their file just for printing — they copy the data they want to print into that sheet, format it, and set the print area. That way the original data stays untouched, and they always have a clean version ready to print without fiddling with settings each time.

Frequently Asked Questions

Why does my spreadsheet print on multiple pages when it looks like one page on my screen?

Excel prints at a fixed size, usually 8.5 by 11 inches. Your monitor is much wider, so a spreadsheet that fits on screen may be too wide for one printed page. Use landscape orientation, reduce margins, or scale down to fit it on fewer pages. The print preview shows you exactly how many pages it will use.

How do I print just one column or row?

Select the column or row by clicking its letter or number on the left side of the spreadsheet. Then set the print area to that selection before printing. If you want multiple non-adjacent columns, hold Ctrl (Windows) or Command (Mac) while clicking each one, then set the print area.

Can I print to a PDF instead of paper?

Yes. In the print preview window, instead of choosing a physical printer, select Save as PDF or Print to File from the printer dropdown. This creates a PDF file on your computer that you can email, store, or print later without opening Excel again.

What if my printed spreadsheet is too small to read?

Increase the scaling percentage in the print preview — try 110% or 125% instead of the default 100%. You can also remove columns you don't need before printing, or print in landscape mode. If the spreadsheet is still too wide, consider printing only the most important columns and printing the rest on a separate page.

How do I add my company name or logo to every printed page?

Use the header and footer settings in the print preview or page setup. You can add text like your company name, the current date, or page numbers. Most versions of Excel do not let you insert an image directly into a header, but you can add a text-based company name or department name instead.