Tuesday, July 11, 2006

Restricting Scrolling in an Excel Worksheet

Doug Klippert fom Unofficial Microsoft Office Stuff writes a really useful post about how to use the scroll property to restrict scrolling in a worksheet without using protection.

You can protect a spreadsheet so that data is shielded from inadvertent entries.
There is another way to set up a scroll area that does not involve protection.
Open the Control Toolbox (right-click any existing tool bar) and click on the Properties icon.

In the Scroll Area text box, type the scroll area range, or type the defined Name for the range.
To cancel the Scroll Area restricted range, clear the Scroll Area text box.

Pictures and how to find it in Excel 2007 can be found in his site.