Tarek78

New Member
Joined
Feb 21, 2021
Messages
46
Office Version
  1. 365
Platform
  1. Windows
Hi Everyone,

You can find attached a page the way I see it when printed out. The issue is that I have some blank areas on the left and right I want to remove.

I set up the margins to 0 but I still cannot get rid of this blank areas. Any ideas on how I can remove it?

Thanks!!!
Issue with page layout.PNG
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
If you select only the applicable columns you'd like printed, then go to Page Layout > Print Area > Set Print Area. Does that get rid of the blank space?
 
Upvote 0
Also, check the Page Setup's Margins tab. It may be centered horizontally on the page.
 
Upvote 0
Hi Breynolds,

Thanks for your reply. I have attached the margin layout. I have set it out to 0 and centered it horizontally and vertically. I tried to remove to center it, but the blank area is on the right now.

I only selected the area where I have data (from the title in bleu to the last cells where we have data). So not sure, why I have this
 

Attachments

  • Issue with page layout 2.PNG
    Issue with page layout 2.PNG
    137 KB · Views: 6
Upvote 0

Forum statistics

Threads
1,214,911
Messages
6,122,196
Members
449,072
Latest member
DW Draft

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