How to print an Excel spreadsheet on one page on a Mac

To print an Excel sheet on one page on a Mac, tell the app to scale the sheet to the page instead of printing it at full size. In Excel that is Page Layout > Page Setup > Fit to 1 page wide by 1 tall. Numbers, LibreOffice and Google Sheets have the same idea under other names. Before you do it, decide whether you really need one page, or only all the columns on one page width. The second is what most people want, and it stays readable.

One page or one page width

A sheet that is a little too wide prints with its last column or two on a separate page. Fitting the width fixes that: every column is on the same page, and the rows carry on to page two or three as needed.

Fitting the whole sheet on one page also shrinks it until all the rows fit. With 40 rows that is fine. With 400 rows the text becomes too small to read. If the sheet is long, fit the width and let it run to more pages.

Three things make any sheet fit better before you touch the scale:

  • Landscape. A wide sheet fits far more columns on a page turned sideways.
  • Hide what you don’t need. Hidden rows and columns are not printed.
  • Narrower columns. One very wide column of notes is often what pushes the rest onto a second page.

With Excel for Mac

  1. Open the workbook and click the Page Layout tab.
  2. Click Page Setup. On the Page tab, under Scaling, choose Fit to.
  3. For one page, enter 1 page wide by 1 tall. For one page width, enter 1 wide and leave the tall box empty, or enter a large number such as 9999.
  4. Choose Landscape on the same tab if the sheet is wide, then click OK.
  5. Choose File > Print and check the preview.

To print only part of the sheet, select the cells and choose File > Print Area > Set Print Area first. Excel saves the scaling and the print area in the file.

With Numbers

Numbers comes with every Mac and opens .xlsx files.

  1. Open the file in Numbers.
  2. Choose File > Print. The sheet changes to a print preview, with print settings in the sidebar.
  3. Choose Landscape if the sheet is wide.
  4. Drag the Content Scale slider until the table fits, or click Fit to fit it to the page.
  5. Click Print, or choose PDF > Save as PDF in the print panel to make a PDF.

Numbers converts the workbook to its own format when it opens it, so don’t count on a print area or scaling made in Excel. Check the preview and set the scale in Numbers.

With LibreOffice Calc

LibreOffice is free and opens .xlsx files directly.

  1. Open the file in LibreOffice Calc.
  2. Choose Format > Page Style and click the Sheet tab.
  3. Under Scale, choose “Fit print range(s) on number of pages” and enter 1. For one page width, choose “Fit print range(s) to width/height”, enter 1 for the width and leave the height unchecked.
  4. On the Page tab, choose Landscape if needed, then click OK.
  5. Choose File > Print or File > Export as PDF.

Save as .xlsx with Keep Current Format if you want to keep the setting in the file.

With Google Sheets

Upload the file to Google Drive and open it in Google Sheets, then choose File > Print. Under Scale choose Fit to page, Fit to width or Fit to height, set the page orientation, and click Next. This works well, but the file has to be uploaded first, which is a poor fit for payroll, invoices or anything with personal details in it.

With Office Alternative

Office Alternative opens the .xlsx file as an Excel workbook, so the page setup saved in it is read: paper size, orientation, margins, the print area, print titles and Excel’s own fit-to-pages setting. If the person who sent the file set it to fit on one page in Excel, it prints on one page here too.

To make a PDF that fits the page:

  1. Open the workbook and choose File > Export To > PDF.
  2. Under Export, choose the current sheet, all visible sheets, or tick the sheets you want.
  3. Under Scale, choose one of three: - As saved in the workbook uses the file’s own page setup, including Fit to 1 page if Excel saved it that way. - Fit columns to page width shrinks the sheet so all the columns fit across the page. Rows continue on the next pages. - Actual size (100 %) prints at full size.
  4. Choose Portrait or Landscape, tick or untick Print gridlines, and click Export.

Then print the PDF, or send it. File > Print (Command-P) uses the same page layout as the PDF.

To print only part of a sheet, select the cells in Edit Mode and choose Sheet > Set Print Area. The same Sheet menu has Insert Page Break, Header & Footer, Print Gridlines and Print Headings (the row numbers and column letters). These are saved in the .xlsx file, so they also work when the file is opened in Excel.

Its limits, so you know before you rely on it:

  • There is no slider or percentage box, and no way to set your own “1 page wide by 2 tall”. To fit a whole sheet on exactly one page, the setting has to be saved in the file, for example by whoever made it in Excel.
  • Fit columns to page width never shrinks a sheet below half size. A sheet wider than that is split into bands of columns across more pages, so the text stays readable.
  • A CSV file has no page setup, so Set Print Area is not offered for CSV. Choose File > Export To > Excel Workbook first if you want to keep one.

Office Alternative costs $20 once to edit files. Without buying it you can still open, read, print and export them to PDF. More about how it handles workbooks is on the page about Excel files on a Mac.

A quick check before you print

  1. If the text is too small, go back to fitting the width only and turn the page to landscape.
  2. If a long table runs over several pages, set the header row to repeat on each page. In Excel it is Page Layout > Print Titles. In Office Alternative, freeze the top row to repeat it on every printed page.
  3. Check the last page. A stray value far below the table, or a cell with only a space in it, can add a page of empty grid.

If the sheet comes as a .csv file and opens as one long line, start with how to open a CSV file on a Mac. For a workbook you can’t open at all, see how to open an Excel file on a Mac without Excel.