Forum Discussion
Changing margins for odd and even pages
Hello,
I am trying to print a multi-page excel table that will be double-sided and needs to be side hole-punched. Because the table is large, and needs to span much of the width of the page, I need to set the margin on the side to be hole-punched larger than the side that isn't. I cannot find an option to create different margins for odd and even pages. I am using Excel 2016 from Office365. I have gone through the page setup and print setup tabs and have found nothing. There is a way to set different headers and footers for odd or even pages, but I can't find it for margins.I've searched through help and through forums all to no avail.
What am I missing? Can anyone assist me with this?
Thanks in advance,
Lane
- Haytham AmairahSilver Contributor
Hi Lane,
It seems that there is no option in Excel to set different margins for odd and even pages.
Someone asked the same question here.
- Lane R MandlisCopper ContributorThanks for linking the previous question. I searched but I wasn’t able to find it on the site. Thanks also for confirming that I was correct that there was no way to make the margins different on odd and even pages in Excel. I’ll have to use a different program to print the table. Kind regards Lane