cell protection

AI Training: For Busy Decision Makers & Professionals Book now

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Cell Protection

Cell Protection

resolvedResolved · High Priority · Version 2007

Ariyanna has attended:
Excel Intermediate course
Excel Advanced course

Cell Protection

Is there anyway to Lock/protect single cells with formula is a Spreadsheet without locking the whole spreadsheet?

I have a worbook whic requires other users to put in a lot of data but I don't want them to edit the formulas by mistake so need to lock these?

RE: Cell Protection

Hi Ariyann, thanks for the query. To achieve this, you need to do three things.

1) Select the entire worksheet and click Format-Cells, the Protection tab and deselect the "Locked" tickbox, so all cells are unlocked.

2) Then repeat the process, but this time just select the cell you want to protect and make sure the "Locked" tickbox is selected.

3) Then Tools-Protection-Protect Sheet. Make sure that "select Locked cells" is deselected and "select unlocked cells" is selected. Hit OK and your cell will be untouchable!

You can add a password to prevent users undoing all this, and add in various other levels of security into the Protect Sheet dialog box.

Hope this helps,

Anthony

Thu 18 Jun 2009: Automatically marked as resolved.


 

Excel tip:

How to select certain data in an Excel 2010 workbook

If you want to select the correct data set in a page full of data, the most accurate and efficient way of doing this is to use the ''Shift and Click'' technique.

For example: If you want to select all data in cells A2 to E10, then click on cell A2, hold down the Shift key and click on cell E10 and all the data you want to see is highlighted.

Keep holding down the Shift key and you can move from cell E10 to any other cell in the spreadsheet.

View all Excel hints and tips


Server loaded in 0.11 secs.