Re: Lock Worksheet/Split and Lock Split

Le mercredi 08 décembre 2004 à 22:09 -0600, John Manceaux a écrit :

I have two questions about functionality, whether it exists, and how
to do it if it does.

1.  How can I lock a worksheet so that no changes can be made to it?

Format/Cells menu item, then in the Protection page, check "Protect
worksheet" and Apply.

2. How can I split and then lock a worksheet so that certain cells
remain in place while the others scroll?

View/Freeze Panes menu item.

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]