Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 11:00 AM (PST)
Microsoft Tech Community

Can I Lock Page Setup For a Particular Excel Worksheet/book?

Copper Contributor

I created an Excel file for someone else to use, but when they open it, their page breaks are different.

Yes, they are using a different printer, but should that matter?

How do I get it so that no matter who opens it, the pages will always be the same?

1 Reply



You can insert page breaks "manually" using the selection for that on the "Page Layout" toolbar.


The Insert menu across the top of the screen also has a "Page Break" feature (about 1/3 of the way down on this image). So you have your choice.



You probably would still need to make sure that the other user isn't using wildly different paper sizes or the like.