Forum Discussion
Excel PDF export on external monitor cuts off
If you are experiencing issues with Excel cutting off the chart when exporting to PDF on an external monitor, it could be related to the display settings or resolution settings on the external monitor. Here are a few suggestions to address this issue:
- Adjust the display settings on the external monitor:
- Right-click on the desktop and select "Display settings" (Windows) or "System Preferences" > "Displays" (Mac).
- Ensure that the resolution and scaling settings for the external monitor are set appropriately.
- Try different resolution options to see if it resolves the issue.
- Use the "Fit to Page" option before exporting to PDF:
- Select the chart in Excel.
- Go to the "Page Layout" tab in the Excel ribbon.
- Click on the "Print Area" dropdown and select "Fit to Page" or "Fit to Sheet".
- Adjust the scaling options if needed.
- Export the sheet to PDF again and check if the chart is properly displayed.
- Adjust the Excel window size on the external monitor:
- Maximize the Excel window on the external monitor to ensure that it occupies the entire screen.
- Resize the chart within the Excel window to fit properly.
- Export the sheet to PDF again and check if the chart is correctly included.
- Update the display drivers:
- Ensure that you have the latest display drivers installed for your external monitor.
- Visit the manufacturer's website or use a driver update utility to check for and install any available updates.
If the issue persists after trying these suggestions, it may be worth testing with different external monitors or consulting with your IT department for further assistance.
The steps were processed using AI.
Hope this will help you.
The page settings, including the print area, margins, and scaling, should be the primary factors that determine the layout and content of the exported PDF.
If the print area option is grayed out in Excel, it could be due to the following reasons:
- Active cell selection: Make sure that you have selected a cell within the range of your chart before accessing the "Page Layout" tab. The print area option may be disabled if no cells or objects are selected.
- Protected worksheet: If the worksheet is protected, the print area option might be restricted. You can try unprotecting the worksheet before modifying the print area.
- Chart in a grouped shape: If your chart is placed within a grouped shape or object, the print area option may be disabled. In this case, you would need to ungroup the shape or object before adjusting the print area.
If none of these reasons apply, it's possible that there may be other factors or limitations specific to your Excel version or configuration. In such cases, you could consider alternative methods for exporting the chart to PDF, such as using third-party PDF printer software or saving the chart as an image and then creating a PDF from the image file. It would be helpful to gather more information about the specific Excel version, operating system, and any other relevant details to further investigate and provide more accurate guidance. The steps were processed using AI.
I did not create this but it looks like the chart was moved to its own sheet with no cells in it by right clicking, choosing move chart, and doing new sheet. So there are no cells to select. The sheet is not protected.
Looks like any of the sheets where a chart has been moved to it's own page has the print area greyed out. The data sheet, it is not. I am guessing this is normal behaviour?
- Windows 11. Microsoft Office Professional Plus 2019 - en-us - 16.0.10399.20000
Please try the following steps on your Windows 11 system with Office 2019:
Adjust the display settings on the external monitor:
- Right-click on the desktop and select "Display settings".
- Ensure that the resolution and scaling settings for the external monitor are set appropriately.
- Try different resolution options to see if it resolves the issue.
Use the "Fit to Page" option before exporting to PDF:
- Select the chart in Excel.
- Go to the "Page Layout" tab in the Excel ribbon.
- Click on the "Print Area" dropdown and select "Fit to Page" or "Fit to Sheet".
- Adjust the scaling options if needed.
- Export the sheet to PDF again and check if the chart is properly displayed.
Adjust the Excel window size on the external monitor:
- Maximize the Excel window on the external monitor to ensure that it occupies the entire screen.
- Resize the chart within the Excel window to fit properly.
- Export the sheet to PDF again and check if the chart is correctly included.
