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

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
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
246
6StringJazzer
6StringJazzer
S
  • Question Question
VBA code to determine InDesign Layout
Replies
6
Views
525
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
764
bruhyan
B
O
  • Solved
How to print (create PDF) document one page wide?
Replies
4
Views
457
OaklandJim
O
P
  • Question Question
Need Help in Print to PDF
Replies
1
Views
795
ChrisFoster
C

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

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