Print multisheet as PDF, only the last page can be centered

[Richard Yan]

Hi Avatars,

I working on shipping marks with Excel. I want print all pages as PDF, but it seems only the last page can be centered. Anybody can help me? thank you very much。

[Roel Jongman]

The pages are setup correctly to center, however your layout is not exact,each page has blank row(s) which are also part of the centered image so for some pages there is a blankrow at the bottom for other pages it is at the top causing the labels to jump

You need to do a little more "design" of your pages by inserting pagebreaks and hiding the blank rows between the labels.
or even remove the blankrows between the labels then you only need the pagebreaks.

when you do that you will have perfect centered labels.

[Richard Yan]

Roel Jongman ,Thanks a million, you saved my life