AjapaReporter

Home life · Updated

How to Print XLS Files: 5 Easy Ways

Time it takes5 min
Steps5in the list below
LevelEasyno special skills
Official sourceMicrosoft Supportcheck it for changes

Quick answer Printing an XLS file (Excel spreadsheet) is straightforward: open it in Excel or a compatible app, adjust the page setup so columns fit, then choose Print. This guide covers the steps for Windows, Mac, and mobile.

What You’ll Need

  • An XLS file (or XLSX) on your device
  • A program that can open it: Microsoft Excel, Google Sheets, LibreOffice Calc, or Apple Numbers
  • A printer (physical or PDF printer)

Step-by-Step

  1. Open the file in a spreadsheet app. Double-click the XLS file. If it opens in a viewer that doesn’t allow printing (like a browser preview), choose “Open with” and select Excel, Google Sheets, or LibreOffice.
  2. Check the print preview. Go to File > Print (or press Ctrl+P on Windows, Cmd+P on Mac). You’ll see a preview of how the pages will look. If data is cut off or too small, continue to the next step.
  3. Adjust page setup. In the print dialog, look for settings like “Portrait/Landscape,” “Scale to Fit,” or “Margins.” To make columns fit on one page, choose “Fit Sheet on One Page” or set the scale to a custom percentage (e.g., 80%).
  4. Choose your printer and settings. Select your printer (or “Save as PDF”), set the number of copies, and choose which pages to print (e.g., all or a specific range).
  5. Click Print. Confirm the settings and hit the Print button. If you chose PDF, pick a location to save the file.

Common Mistakes

  • Not adjusting the print area – printing the entire sheet when you only need a few columns.
  • Ignoring page breaks – data gets split awkwardly across pages.
  • Forgetting to set print titles – so header rows don’t repeat on each page.
  • Using the wrong paper size – e.g., A4 vs. Letter, causing margins to look off.

Tips

  • Use “Print Titles” (under Page Layout > Print Titles) to repeat header rows on every page.
  • Set a print area (Page Layout > Print Area) to print only selected cells.
  • Use “Fit to Width” to keep columns on one page while allowing rows to flow to multiple pages.
  • For large sheets, consider printing in landscape to get more columns across.
  • If you need a PDF, use “Save as PDF” instead of a physical printer – it’s often faster and paperless.

Troubleshooting

  • Columns are cut off: Go to Page Layout > Scale to Fit, set Width to “1 page” (or use “Fit Sheet on One Page”). Also check that margins are not too wide.
  • Print button is grayed out: Ensure you have a printer selected or added. If using a PDF printer, it may be disabled – re-enable it in system settings.
  • Text is too small: Increase the scale percentage or reduce the number of columns per page by selecting a print area.
  • Printing blank pages: This often happens due to stray cells with formatting. Clear the print area (Page Layout > Print Area > Clear Print Area) and set it again.
  • File won’t open: If the XLS is corrupted, try opening in Google Sheets (upload to Google Drive) or LibreOffice – these can often recover data.

Frequently Asked Questions

How do I print an XLS file without Excel?

Use Google Sheets (free with a Google account), LibreOffice Calc (free desktop app), or Apple Numbers (Mac). All can open and print XLS files.

Can I print only a specific part of my spreadsheet?

Yes. Select the cells you want, then go to Page Layout > Print Area > Set Print Area. Only that range will print.

Why does my spreadsheet print on multiple pages even though it’s small?

This usually happens because the columns are too wide to fit on one page. Use “Fit to Width” or reduce the scale in print settings.

How do I print gridlines in Excel?

In the print dialog, look for “Show Gridlines” under Page Setup > Sheet, and check the box. In Google Sheets, go to Print > Formatting > Gridlines.

Can I print an XLS file from my phone?

Yes. Open the file in the Excel mobile app or Google Sheets app, tap the three-dot menu (or share icon), and select Print. You can also save as PDF.

What’s the difference between XLS and XLSX for printing?

None for printing. XLS is the older format, XLSX is the newer one, but both print the same way.

Sources: Microsoft Support. Menus and buttons can differ slightly by version. Spotted something out of date? Tell us.