98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Protection
Protection
Resolved · Low Priority · Version 2007
Ian has attended:
Excel Intermediate course
Protection
How do you lock only two areas in different rows
Worksheet Protection and Un/Locking cells in Excel 2007
Dear Ian
Thank you for attending Excel 07 Intermediate course. I hope you enjoyed the course and found it helpful to carry out your day-to-day work activities.
Normally when you protect the whole worksheet then all the cells (which are locked by default) get protected as well. This means that you cannot enter or modify information as well as formatting on any cells.
In order for the users to enter information on certain cells you can unlock the cells and then protect your worksheet.
To unlock the cells you have to first select all the cells that you want to make the modification after the worksheet is protected and then use CTRL + 1 to get the Format cells dialog box. In the protection tab you uncheck the locked and then click OK.
Once you have done that you simply protect your sheet ( preferably with a password) and you will notice that you can enter data only on those cells that have been unlocked.
If you have a scenario where most of the cells need to be edited and only certain cells to be locked which I suspect you are asking for. Please the following steps:
Step 1: Use CTRL +A or click on the grey button on the left hand of Column A and above Row 1. This will select all your cells.
Step 2: You use CTRL + 1 to get to the Format cells.
Step 3: In the protection Tab un-tick the locked so that all the cells in the sheet are unlocked.
Step 4: Once you have done than select the specific cells that you want to be locked and again use the CTRL +1 to get to the format Cells dialog box. Put the tick on the locked.
Step 5: Protect your worksheet by choosing review tab on the ribbon and selected protect sheet.
You
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:Filtering Data in an Excel 2010 WorksheetWhen you have an Excel Worksheet with masses of data, it's not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter. |