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

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
You must log in or register to reply here.

Similar threads

T
  • Solved
Create a pdf with each page being just 4 rows and 1 column wide
Replies
3
Views
222
6StringJazzer
6StringJazzer
S
  • Question Question
VBA code to determine InDesign Layout
Replies
6
Views
442
Akuini
Akuini
B
  • Question 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
750
bruhyan
B
O
  • Solved
How to print (create PDF) document one page wide?
Replies
4
Views
448
OaklandJim
O
P
  • Question Question
Need Help in Print to PDF
Replies
1
Views
790
ChrisFoster
C

Forum statistics

Threads
1,223,904
Messages
6,175,295
Members
452,633
Latest member
DougMo

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