Hi, i am creating a template that has various cells that are locked to ensure the formulas stay intact. I protect the sheet and disallow selection of locked cells. This way the user doesnt have to click on everything and try to figure out where they are to input information and where they arent. This was all fine now i am trying to print it and this thing wont even fit properly on a 11x17 page and so therefore i now am trying to hide some of the excess rows. for example i have a part that has 15 rows of inputting data, they will probably only need 5 rows most of the time but i want to leave the extra rows there in order to allow for change on the fly. Now my question is when i protect it and turn selection of locked cells off, i can not hide or unhide rows. I can hide and unhide them if select locked cells is enabled however but like i stated it complicates it for users when they are inputting data. Any work arounds? Thank you very much