Forum Discussion
Excel PDF export on external monitor cuts off
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.
If the chart has been moved to its own sheet using the "Move Chart" feature in Excel, it is expected behavior that the print area option is grayed out on that specific chart sheet. When a chart is moved to its own sheet, Excel treats it as a separate object rather than a part of the worksheet containing cells and data.
In this case, to adjust the print area for the chart sheet, you can follow these steps:
- Go to the chart sheet where the chart is located.
- On the Excel ribbon, go to the "Page Layout" tab.
- Click on the "Print Area" dropdown.
- Select "Set Print Area" from the dropdown.
- Adjust the dotted lines that appear on the chart sheet to encompass the desired print area.
- Save the changes.
By following these steps, you can define the print area for the chart sheet and ensure that the desired portion of the chart is included when exporting to PDF or printing.
Please note that when the chart is on its own sheet, the print area settings are specific to that chart sheet and won't impact the print area settings on other sheets. Each sheet, including the chart sheet, can have its own separate print area defined.
The steps were processed using AI.
I apologize for any confusion caused earlier, and I hope this clarifies the print area functionality for chart sheets in Excel.
I am really sorry. In this post you said it's expected behavior for the print area to be greyed out but then you said in the steps to go to the print area. Which is greyed out and expected.
Also, I am able to reproduce this using the same setup as the user (same model laptop\monitor). Drivers are update to date and the display scaling and resolution are normal.However on my laptop, different model, and monitor (which is the same model) it works fine.
- The different behavior between different laptops and monitors can actually occur due to differences in hardware configuration, graphics drivers or compatibility with Excel versions. These factors can affect how Excel handles certain features, including the print area option for chart sheets.
Also, if the issue occurs on a particular laptop and monitor combination while it works fine on others, that would suggest that the behavior is related to the specific hardware and software setup of that particular combination, otherwise I can't figure it out either explain... I'm at the end of my wits too. Maybe work through everything from scratch. Win & Office update, start Excel in safe mode, deactivate all AddIns, and if none of this helps, also install new monitor drivers. I can't think of more than what to do.