Urgent - Printing does not fit

slayer1957

New Member
Joined
Jan 9, 2017
Messages
42
Good day,

I am struggling to print a page, i want all columns to fit but it keeps on cutting off and page break looks fine, but page layout cuts off. Can someone assist urgently, what i could see there is a break in the fit of the page from uploaded images. How do i get this thing to decrease and fit inside the printable borders specified.

I have tried all i can think off, please help if someone knows.
 

Attachments

  • Capture2.JPG
    Capture2.JPG
    251.4 KB · Views: 8
  • Capture3.JPG
    Capture3.JPG
    226 KB · Views: 8
  • Capture.JPG
    Capture.JPG
    135.2 KB · Views: 8
  • Capture4JPG.JPG
    Capture4JPG.JPG
    156.8 KB · Views: 7

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

rollis13

Well-known Member
Joined
Jul 30, 2012
Messages
1,200
Office Version
  1. 2016
Platform
  1. Windows
If you have set a Print-Area to column H in the 'Page' tab of 'Page Setup' you will find the option 'Scaling', choose 'Fit to' then leave 1 in 'pages wide' field and if your are to print only a single sheet leave 1 in 'wide' elsewise blank the field (do not write 0).
 
Upvote 0

rollis13

Well-known Member
Joined
Jul 30, 2012
Messages
1,200
Office Version
  1. 2016
Platform
  1. Windows
Typo, should be:
choose 'Fit to' then leave 1 in 'pages wide' field and if your are to print only a single sheet leave 1 in 'tall' elsewise blank the field (do not write 0).
 
Upvote 0

SanjayGMusafir

Well-known Member
Joined
Sep 7, 2018
Messages
673
Office Version
  1. 2021
Platform
  1. MacOS
Try this - On Page Setup - First Select the area to be printed and then choose width as 1 page - See screenshot
 

Attachments

  • Screenshot 2022-08-28 at 18.57.21.png
    Screenshot 2022-08-28 at 18.57.21.png
    42.9 KB · Views: 3
Upvote 0

Forum statistics

Threads
1,187,221
Messages
5,962,296
Members
438,600
Latest member
jagadeesan12

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
Top