98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses - Block cells
excel training courses - Block cells
Resolved · Low Priority · Version Standard
Thu 31 May 2007, 13:34Delegate Vinay said...
Vinay has attended:
No courses
Block cells
How do I block an excel cell so no-one can enter details with in the cell?
Fri 1 Jun 2007, 09:45Trainer Richard said...
RE: block cells
Cells and worksheets can be locked using the TOOLS > PROTECTION > PROTECT WORKSHEET feature.
If you click on FORMAT > CELLS > PROTECTION, then you will see a setting to lock or unlock individual cells.
It works on two levels. All cells are locked by default, but the activation of that feature happens when you use PROTECT WORKSHEET from the tools menu.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Select blank cells automaticallyGet Excel to find any blank (empty) cells in a region for you by: |
