Urgent - Printing does not fit

slayer1957

Board Regular
Joined
Jan 9, 2017
Messages
50
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: 9
  • Capture3.JPG
    Capture3.JPG
    226 KB · Views: 9
  • Capture.JPG
    Capture.JPG
    135.2 KB · Views: 9
  • Capture4JPG.JPG
    Capture4JPG.JPG
    156.8 KB · Views: 8

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
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
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
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,214,606
Messages
6,120,487
Members
448,967
Latest member
visheshkotha

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