Forum Discussion

PeteShalek's avatar
PeteShalek
Copper Contributor
Sep 08, 2022

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

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

  • mathetes's avatar
    mathetes
    Gold Contributor

    PeteShalek 

     

    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.

     

Resources