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

Occasional Visitor

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.