# How to print a sheet on one page in Excel on Mac: Microsoft 365 steps

> How to print a sheet on one page in Excel on Mac: Page Layout > Page Setup, Fit to, the preview check, and fixes when Excel won't shrink it.

URL: https://www.lazur.app/how-to/print-a-sheet-on-one-page-in-excel
Updated: 2026-11-09

To print a sheet on one page in Excel on Mac, go to Page Layout > Page Setup and choose Fit to under Scaling. Enter 1 in both boxes, click OK, then open File > Print or press ⌘P and check the preview before you print.

## Quick answer

- Use Page Layout > Page Setup, select Fit to under Scaling, and enter 1 in both boxes.
- Press ⌘P, then page through the preview with the arrows before you print.
- Excel for the web does not offer Fit to one page, so open the file in Excel for Mac.
- If the sheet still spills, check Adjust to, manual page breaks, and a greyed-out Page Layout tab.
- Microsoft's steps cover Microsoft 365, Excel 2024, and Excel 2021 for Mac.

Applies to: Excel for Microsoft 365 for Mac, Excel 2024 for Mac, Excel 2021 for Mac. Time: 3 min. Difficulty: Easy.

## What you need

- Excel for Mac: Microsoft 365, Excel 2024, or Excel 2021
- The file open in the desktop app, not Excel for the web
- A sheet you can edit, not a locked or grouped sheet (fixes are covered below)

## How to Print one Excel sheet on one page on Mac in Excel on a Mac

1. **Open the sheet in Excel for Mac.** Open the workbook in the Excel desktop app. Click the tab of the sheet you want to print, at the bottom of the window. Do this before you open any settings, so you change the right sheet.
2. **Open the Page Layout tab.** (Page Layout) Click Page Layout in the ribbon at the top of the window. If the tab is greyed out, read the greyed-out section on this page before you go on.
3. **Open Page Setup.** (Page Layout > Page Setup) Select Page Setup. The dialog opens with the Scaling options on the Page tab. Tip: If you find File > Page Setup instead, check that it shows the same Scaling options before you change anything.
4. **Select Fit to under Scaling.** (Page Setup > Scaling > Fit to) Under Scaling, select Fit to. This turns off Adjust to, which scales the sheet by a fixed percentage instead.
5. **Enter 1 in both page boxes.** (Page Setup > Fit to > Pages in width by) Enter 1 in the Pages in width by box, then enter 1 in the Tall box. The tip in Microsoft's article calls the first box Pages wide by, so read the label on your screen. Tip: For columns only, Microsoft's tip uses 9999 in Tall. The section on fitting all columns explains the difference.
6. **Click OK.** (OK) Click OK to save the Page Setup changes and close the dialog. Nothing prints yet, so the next step checks the result.
7. **Open File > Print.** (File > Print) Shortcut: ⌘P. Choose File > Print, or press ⌘P. The Print pane opens with a preview of the sheet.
8. **Page through the preview.** Use the arrows under the preview to move from page to page. If you see more than one page, cancel, go back to Page Layout > Page Setup, and check the Fit to values.
9. **Print or save a PDF.** When the preview shows the whole sheet on one page, click Print. To keep a file instead, use the PDF menu at the bottom of the print window.

Fit to one page is a print setting. Excel shrinks your data to fit the number of pages you choose, according to Microsoft's Fit to one page article. Excel also adds page breaks on its own. They show as a dashed line, and you can move or delete them. You don't need to change your data to get a one-page printout. You change how Excel prints it.

## Find the Fit to setting on your Mac

On Mac, Microsoft's steps start on the Page Layout tab. From there you open Page Setup, and the Scaling options live in that dialog. Castleink's guide says some Mac settings sit under File > Page Setup, which is a second route. Start with Page Layout, since that is the path Microsoft documents for Mac. If the File menu route shows different options, go back to Page Layout and open the dialog from there.

| Setting | Where to find it on Mac | Value for one page |
| --- | --- | --- |
| Fit to | Page Layout > Page Setup > Scaling | Selected |
| Pages in width by | Page Setup dialog, under Fit to | 1 |
| Tall | Page Setup dialog, under Fit to | 1 |
| Print preview and print | File > Print, or ⌘P | Check the preview, then print |

_The settings for one page, from Microsoft's Mac articles._

![A person at a desk checking a spreadsheet on a laptop before they print a sheet on one page in Excel on Mac](https://images.lazur.app/content-images/howto/print-a-sheet-on-one-page-in-excel/how-to-print-a-sheet-on-one-1-b5f44e.jpg)

## Fit all columns on one page and let the rows flow

Some sheets are wide but long. You may want every column on one page across, while the rows run onto more pages. Microsoft's one-page article tip says to enter 1 in the wide box and 9999 in the Tall box for that layout.

Microsoft's scaling article uses a different value. It sets Tall to 0 so the page count is unrestricted. Both values come from Microsoft, but I found no note that says 9999 means unlimited. Try 0 first. If the dialog rejects it, or the preview looks wrong, use 9999 and check the preview again.

Here is a worked example. Open a long list with many columns and set the wide box to 1. Leave Tall at 0, then open File > Print. The first page should hold every column, with the rows flowing onto later pages. If a column still lands on a second page across, move to the scale and paper size section below.

## Check the preview before you print

The preview lives inside File > Print. You don't need a separate window. Use the arrows under the preview to page through the sheet. Look at the right edge first. A column cut off there sits outside the print range.

Microsoft's notes list no shortcut for Print Preview or Page Setup. Use the menu path each time. The one shortcut Microsoft lists for this job is ⌘P, which opens Print.

- **16.114.4** Newest Excel for Mac build on Microsoft's update history page when checked, dated November 4, 2026 ([source](https://learn.microsoft.com/en-us/officeupdates/update-history-office-for-mac))
- **9999** Tall value in Microsoft's one-page tip for fitting all columns, while its scaling article uses 0 ([source](https://support.microsoft.com/en-us/office/print-a-sheet-on-just-one-page-in-excel-for-mac-30be3beb-d646-4925-a4a9-8ed32a4f6460))

## When the preview still shows several pages

1. Confirm that Fit to is selected, not Adjust to.
2. Confirm that the wide box reads 1 and Tall reads 1 for a full one-page print.
3. If the last column is missing, reset manual page breaks with Page Layout > Breaks > Reset All Page Breaks.
4. If the page still spills or the text is too small, change the paper size or the scale.
5. Print only after the preview shows the whole print range.

Change one setting at a time and check the preview after each change. That way you know which setting fixed the page.

## Why Page Layout is greyed out

The Page Layout tab goes grey when Excel can't change page setup at that moment. A cell edit is the simplest cause. Press Return to finish typing in the cell, then try again.

Grouped sheets also block the tab. Right-click the sheet tab and choose Ungroup Sheets. A protected sheet blocks it too. Check Review > Unprotect Sheet, and enter the password if the sheet has one. The guide at /how-to/protect-a-sheet-with-a-password-in-excel covers protecting a sheet with a password.

## Manual page breaks and Fit to

Manual page breaks are the lines you add yourself. Microsoft's scaling article says Excel ignores manual page breaks when Fit To is on. So with Fit to selected, your own breaks don't stop the sheet from fitting one page.

Breaks can still matter under Adjust to, based on Microsoft's wording. ExcelDemy describes a manual break before the last column that leaves that column out of the print range. Its fix is Page Layout > Breaks > Reset All Page Breaks. That guide uses the Windows ribbon, so look for the Breaks button on your Mac ribbon first.

![An office printer printing a single page on a desk beside a laptop, the end result of printing a sheet on one page](https://images.lazur.app/content-images/howto/print-a-sheet-on-one-page-in-excel/how-to-print-a-sheet-on-one-2-e89c0c.jpg)

## When Fit to is not enough: scale and paper size

Adjust to sets a fixed percentage. Microsoft's scaling article says printing never scales above 100% with that option. So Adjust to can shrink a sheet but never enlarge it. ExcelDemy lowers the scale to 90% as one fix. Try a value like that if a column still falls outside the page, then check the preview.

Paper size changes how much room you have. Open Page Layout > Size and choose a larger paper size. ExcelDemy lists that as another fix. After you change the paper, return to Page Setup and check the Fit to values again.

## Excel for the web does not support this

Fit to one page isn't available in Excel for the web. Microsoft says so, and its article tells web users to choose Open in Excel. Castleink's guide says the web keeps some scaling and margin settings. Microsoft is the more authoritative source here, so plan to make the change in Excel for Mac.

Open the file in the desktop app, set the Page Setup options there, and print from File > Print. The pages I read don't say how those changes carry back to the web copy, so check that yourself if you need both versions.

## Which Excel for Mac version to check

Microsoft's one-page article lists Microsoft 365, Excel 2024, and Excel 2021 for Mac. It shows no last-updated date, only a © 2026 footer. Its Mac scaling article uses the same Page Setup dialog, so the steps on this page match both articles.

Microsoft's update history lists 16.114.4, build 26110224, as the newest build on the page I checked, released November 4, 2026. Its release notes show no Excel printing, Page Setup, or Print dialog changes in the September and October 2026 entries. To see your own build, open Excel and choose Excel > About Excel. If yours is older, update before you assume a menu is missing.

## Mistakes people make with one-page printing

- Choosing Adjust to and expecting one page. Fit to is the option that shrinks the sheet to a page count.
- Entering 1 in only one of the two boxes. Fit to needs values in both.
- Trying to change Page Setup while a cell is still in edit mode. Press Return first.
- Looking for Fit to one page in Excel for the web, where Microsoft says it isn't available.
- Printing without looking at the preview. A cut-off column is easy to miss on screen.

![A MacBook on a tidy office desk, the setup for printing a sheet on one page in Excel on Mac](https://images.lazur.app/content-images/howto/print-a-sheet-on-one-page-in-excel/how-to-print-a-sheet-on-one-3-b16767.jpg)

## Where to go next

If your sheet is a report built on a pivot table, the guide at /how-to/make-a-pivot-table-in-excel covers the table itself. Fix the layout first, then run the one-page steps here. If the sheet is locked, /how-to/protect-a-sheet-with-a-password-in-excel explains sheet protection before you change page setup.

## Shortcuts

- Print (File > Print): ⌘P

## If it does not work

- **The preview still shows more than one page** Reopen Page Layout > Page Setup. Confirm Fit to is selected, not Adjust to. Confirm both boxes read 1, then check the preview again before you print.
- **Page Layout is greyed out** Press Return to leave cell edit mode. If sheets are grouped, right-click a sheet tab and choose Ungroup Sheets. If the sheet is protected, check Review > Unprotect Sheet. ExcelDemy's steps use Windows menus, so check the labels on your ribbon.
- **Fit to one page is missing in Excel for the web** Microsoft says Fit to one page is not available in Excel for the web. Choose Open in Excel, then set the options in the Mac app.
- **A column is missing from the printout** Check for a manual page break before that column. Use Page Layout > Breaks > Reset All Page Breaks, then check the preview.
- **The printout is too small to read** Choose a larger paper size with Page Layout > Size. Or keep 1 in the wide box, set Tall to 0, and fit only the columns so the rows run onto more pages.

## With Lazur

Lazur is a voice assistant for the Mac that lives in the notch. Hold ⌥ ⌘ and ask; it sees your screen, answers out loud, points at buttons and walks you through apps. Hold fn to dictate. Free for 3 days, then $18/month: https://www.lazur.app/download

- “Walk me through printing this sheet on one page.”: Lazur guides you through Fit to one page one click at a time, and waits for each click before it moves on. (Walks you through it)

## FAQ

### Does Fit to one page work in Excel 2021 and Excel 2024 for Mac?

Microsoft's Mac one-page article lists Excel 2024 and Excel 2021 for Mac alongside Microsoft 365. The steps on this page follow that article. Older versions may have a similar dialog, but this page does not confirm them.

### Can I fit a sheet to one page in Excel for the web?

Not with Fit to one page. Microsoft says that feature is not available in Excel for the web and recommends Open in Excel. Open the file in the Mac app, then set the scale there.

### What is the keyboard shortcut to print in Excel for Mac?

Command + P, written ⌘P, opens File > Print. Microsoft's common shortcuts page lists no shortcut for Page Setup or Print Preview, so use the menus for those.

### Should I enter 0 or 9999 in the Tall box?

Microsoft's scaling article uses 0 for an unrestricted page count. The one-page article tip uses 9999 for fitting all columns. Try 0 first, then 9999 if the dialog or the preview disagrees.

### Did a recent update change the Print dialog in Excel for Mac?

Not that I could find. Microsoft's release notes show no Excel printing, Page Setup, or Print dialog changes in the September and October 2026 entries. The newest build I could confirm is 16.114.4, released November 4, 2026.

### Can Excel save the sheet as a PDF automatically?

Office Scripts can save a worksheet as a PDF and email it. Microsoft added that in version 16.106 on February 10, 2026. It is automation, not a change to the Print dialog or Page Setup.

### Why is my printout so small?

Fit to shrinks the output to match the page count you set. Try a larger paper size in Page Layout > Size. Or keep 1 in the wide box, set Tall to 0, and check the preview.

## Sources

1. [Print a sheet on just one page in Excel for Mac](https://support.microsoft.com/en-us/office/print-a-sheet-on-just-one-page-in-excel-for-mac-30be3beb-d646-4925-a4a9-8ed32a4f6460), Microsoft Support, checked 2026-11-09
2. [Scale the sheet size for printing in Excel for Mac](https://support.microsoft.com/en-us/office/scale-the-sheet-size-for-printing-in-excel-for-mac-3ea263ac-c952-40b4-9a6c-515e8c69b826), Microsoft Support, checked 2026-11-09
3. [Common Office for Mac keyboard shortcuts](https://support.microsoft.com/en-us/office/common-office-for-mac-keyboard-shortcuts-307f469a-1a05-4263-9b55-49df19a8b8ff), Microsoft Support, checked 2026-11-09
4. [Fit to one page in Excel](https://support.microsoft.com/en-us/excel/fit-to-one-page-in-excel), Microsoft Support, checked 2026-11-09
5. [Release notes for Office for Mac](https://learn.microsoft.com/en-us/officeupdates/release-notes-office-for-mac), Microsoft Learn, checked 2026-11-09
6. [Update history for Office for Mac](https://learn.microsoft.com/en-us/officeupdates/update-history-office-for-mac), Microsoft Learn, checked 2026-11-09
7. [How to Print an Excel Spreadsheet That Actually Fits](https://castleink.com/blogs/printer-help/how-to-print-an-excel-spreadsheet-that-actually-fits), Castleink, checked 2026-11-09
8. [Print Scale to Fit Not Working in Excel](https://www.exceldemy.com/excel-scale-to-fit-not-working/), ExcelDemy, checked 2026-11-09
9. [Excel Page Layout Being Greyed Out](https://www.exceldemy.com/excel-page-layout-greyed-out/), ExcelDemy, checked 2026-11-09