Trouble printing sheet after copying to another workbook

[KitaYama]

When I print a worksheet in a workbook, the whole sheet is printed in one A4 size page.
If I drag and copy the same worksheet to a new workbook, the sheet prints on two A4 pages.

I've gone through all print preview settings of two workbooks, they have the exact same settings.
Why the sheet prints on multiple pages after being copied to a new workbook?

Is there anywhere else that causes this difference?
This is what I have on both workbooks.

Cross posting:

Trouble printing sheet after copying to another workbook

When I print a worksheet in a workbook, the whole sheet is printed in a A4 size page. If I drag and copy the same worksheet to a new workbook, the sheet prints on two A4 pages. I've gone through all print preview settings of two workbooks, they have the exact same settings. Why the sheet prints...

www.access-programmers.co.uk

 

[rollis13]

Not sure on what happens with your Copy/Paste of the sheet since I believe that you aren't changing printer in the new workbook and since you have already checked all settings, you would be better off changing the settings in the pane where it says "No scaling" (Scaling pane) and set it to "Fit to: 1 wide 1 tall".

 

[KitaYama]

@rollis13 Thanks for trying to help.
Yes I know I can change the scaling to "Fit to", but it shrinks the font and column width to fit the page.
It means the print result from my source book and the target book doesn't look the same.

My main question was why coping a sheet from book A to book b doesn't print the same result.

During some tests by experts in my cross post shows that this only happens in office 365. Experts with office 2021 & 2016 couldn't replicate this problem.

Thanks for trying to help.