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

@PeteShalek 

 

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

mathetes_0-1662944111034.png

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.

mathetes_0-1662944214734.png

 

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