Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training seminar - Excel

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel training seminar - Excel

Resolved · Low Priority · Version Standard

Reply Fri 17 Aug 2007, 14:03Delegate Jing said...

Jing has attended:
Excel Advanced course

Excel

How can I lock a particular cell rather than a full worksheet?

For upcoming training course dates see: Pricing & availability

Reply Mon 20 Aug 2007, 07:01Trainer Tracy said...

RE: Excel

Hi Jing,

Thanks for the question.

To lock a particular cell you would need to unlock the whole sheet and then go into the cell you want to lock and just lock that cell. So if you press Ctrl A that will highlight the whole sheet, go into Format Cells across to the Protection tab, and take the lock off the sheet, uncheck the locked box. Then highlight the cell you want to lock and go into Format>Cells>Protection and only lock that cell. Once this is done you can Portect the Sheet, Tools>Protection>Protect Sheet.

And that should work!

Tracy

Excel articles

· Tips for Transitioning to Excel 2007
· Make A Custom Sort List In Excel
· How To Use Freeze Panes In Excel 2007
· Tips to Facilitate Printing of Excel worksheets
· Utilise the web's information banks with Microsoft Excel

Excel tip:

No Zeros

Want all the zeros in your worksheet to appear blank? Choose Tools/Options, Click on the View Tab, Deselect the Zero Values Option, Click OK.
Easy wasn't it? But be aware that these cells are not actually blank, they still contain the value zero. This is important because certain functions (ie AVERAGE) make a distinction between blank cells and those with a zero value.

View all Excel hints and tips