![]() |
A question about locking or protecting a worksheet
Hi!
I have a worksheet that others need to input data into. I don't want them to be able to change the size of the cells. They keep dragging the cells into different sizes causing the thing to print off the page. (They say they don't know how they did it, lol) How can I protect the sheet so they can enter their info but not change the cell sizes? Thanks, Meenie |
A question about locking or protecting a worksheet
Unlock the cells you want them to be able to change
(Format/Cells/Protection), then protect the sheet. In article , Meenie wrote: Hi! I have a worksheet that others need to input data into. I don't want them to be able to change the size of the cells. They keep dragging the cells into different sizes causing the thing to print off the page. (They say they don't know how they did it, lol) How can I protect the sheet so they can enter their info but not change the cell sizes? Thanks, Meenie |
A question about locking or protecting a worksheet
It works great! :) Thank you very very much :)
"JE McGimpsey" wrote: Unlock the cells you want them to be able to change (Format/Cells/Protection), then protect the sheet. In article , Meenie wrote: Hi! I have a worksheet that others need to input data into. I don't want them to be able to change the size of the cells. They keep dragging the cells into different sizes causing the thing to print off the page. (They say they don't know how they did it, lol) How can I protect the sheet so they can enter their info but not change the cell sizes? Thanks, Meenie |
All times are GMT +1. The time now is 07:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com