Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summary worksheet question | Excel Discussion (Misc queries) | |||
A Worksheet Protection Question | New Users to Excel | |||
Customizing Worksheet Menu Bar question. Help! | Excel Discussion (Misc queries) | |||
Copy worksheet question | Excel Worksheet Functions | |||
Question about sorting in protected worksheet | Excel Worksheet Functions |