I want to lock the printing preferences in a shared workbook

T

The Swimmer

I can lock cells and views but don't know how to lock the print to be only
one page wide.
 
D

David McRitchie

If you mean squeeze the print
File, page setup, Print (tab), [x] Fit to ___ pages wide by __ tall
set the pages wide to 1

If you want to restrict the print area
File, Print Area, A1:E54
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top