How to export to PDF and fill the entire page?

W

Waimea

Active Member
Joined
Jun 30, 2018
Messages
465
Office Version
  1. 365
Platform
  1. Windows
Hi, I am exporting a range to PDF but the range doesn't fill the entire page. I have custom margins set to 0.

The space at the top and bottom is ok. The space on the sides it too large. I want to have an A3 page with landscape mode.

The range I am using is A1:Z65. Ideally the entire PDF page would be dark blue.

How can I get the export to PDF function to fill the entire page?

MrExcel forum image2.png
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
You must log in or register to reply here.

Similar threads

B
  • Question
How can I save all my graphs in a single A4 size pdf without my graphs being split over 2 pages?
Replies
0
Views
569
bruhyan
B
O
  • Solved
How to print (create PDF) document one page wide?
Replies
4
Views
281
OaklandJim
O
P
  • Question
Need Help in Print to PDF
Replies
1
Views
693
ChrisFoster
C
A
  • Question
How can I get my print to PDF button print to normal page without selected printer?
Replies
1
Views
1K
DacEasy
DacEasy
K
  • Question
I was make Print to PDF With Duplex page , its Work , But How to set (Top, bottom, Left, Right Margin) in this VBA code....
Replies
2
Views
397
krunal123
K

Forum statistics

Threads
1,215,068
Messages
6,122,950
Members
449,095
Latest member
nmaske

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top