Fix Missing Text When Saving an Excel for Mac Workbook as PDF
Question details
The user needs all visible workbook text to appear when saving the file as a PDF.

- Product
- Microsoft Excel for Mac 16.16.9
- Device & OS
- Mac
- Scenario
- A workbook that changes frequently must be saved as a PDF repeatedly.
- Observed behavior
- Some text is visible in one Excel workbook but disappears from the saved PDF.
Open the affected workbook and locate examples of the missing text. Check whether the text is in cells, text boxes, or other objects so you can inspect the relevant print settings.
Check the workbook's print layout and text settings
Use this method to identify workbook-specific settings that may exclude or alter text in the PDF.
Select the affected sheet, then open Page Layout > Print Area. Clear or reset the print area if it excludes the cells containing the missing text.
Open View > Page Break Preview to check where the text falls. Then open File > Print and review the preview and scaling settings to make sure the affected content fits on the intended pages.
Select the rows or columns surrounding the missing text, then use the row or column header's Unhide command if any are hidden.
Select affected cells or text boxes and try an available standard font from the Home tab. For text boxes or other objects, check their placement and object properties for a print option, if available.
Use File > Save As and choose PDF, then open the resulting PDF and compare the affected text with the workbook.

Compare PDF output methods and test a new workbook
Use this method if the layout checks do not resolve the issue or if you need to isolate a workbook-specific problem.
Try WPS Spreadsheets for Workbook PDF Exports
WPS Office is a free, lightweight alternative with a familiar interface for opening Excel files and exporting spreadsheets to PDF. Its Excel format compatibility can make it easier to move existing workbooks, although it does not repair Excel for Mac's export behavior.

Frequently Asked Questions
Why does text appear in Excel but not in the PDF?
The text may fall outside the print area or page boundaries, be in a hidden row or column, use a problematic font, or be part of an object with unsuitable print settings. Check Page Layout > Print Area and the preview under File > Print.
How do I save a PDF using the Mac print dialog?
In Excel, choose File > Print, then select PDF > Save as PDF in the macOS print dialog. Compare the result with the PDF created through File > Save As.
How can I tell whether the problem is specific to one workbook?
Create a new workbook through File > New, copy the affected content into it, and export it as a PDF. If the text appears there, inspect the original workbook's print settings, fonts, and objects.
Can a text box be omitted from the PDF even when it is visible on the sheet?
Yes. Check where the text box sits relative to the print area and page breaks, and inspect its object properties for a print option if one is available.




