- Tgullo suggested using the Data Validation feature, setting the whole sheet to accept nothing and then resetting the input range to accept anything. It's quick and it works great.
- LocoLobo and Russell suggested the Allow Users To Edit Ranges option.
- Vijaykumanrdave suggested using Protection.
Display the Control Toolbox toolbar. (Choose Toolbars from the View menu, and check Control Toolbox.)
Click the Properties button on the Control Toolbox.
In the resulting Properties window, enter the input range as the Scroll Area setting.
Close the Properties sheet and close the Control Toolbox toolbar.
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.