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.
If you are using Office 2007+, the Property icon is on the Developers tab.
Multiple areas can be selected using Protection, but only one area is allowed using the Scroll Property.
See all Topics