Locking only one cell in Excel 2007
 

I am tring to lock only one cell in excel 2007 not the whole workbook. Can
any one help?

Locking only one cell in Excel 2007
 

Hi mahan8

For every sheet in the workbook do this

Click on the space above the first row header and on the left of the first column header.
All cells on the sheet are selected now

Ctrl 1 to open the format cells dialog
on the protection tab uncheck locked


After you do this select the cell you want to lock

Ctrl 1 to open the format cells dialog
on the protection tab check locked

Now protect every worksheet





--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"mahan8" wrote in message ...
I am tring to lock only one cell in excel 2007 not the whole workbook. Can
any one help?

Locking only one cell in Excel 2007
 

Thank you it worked like a charm.

"Ron de Bruin" wrote:

Hi mahan8

For every sheet in the workbook do this

Click on the space above the first row header and on the left of the first column header.
All cells on the sheet are selected now

Ctrl 1 to open the format cells dialog
on the protection tab uncheck locked


After you do this select the cell you want to lock

Ctrl 1 to open the format cells dialog
on the protection tab check locked

Now protect every worksheet





--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"mahan8" wrote in message ...
I am tring to lock only one cell in excel 2007 not the whole workbook. Can
any one help?